I might have some tips for ya as I do quite a bit of Python and PostGIS these days. PostGIS is a Postgresql extention that allows you to work with geodata and is the bread and butter of most of my geo algorithems these days.
You're one of the inspirations for the project.
And, I can confidently speak well to what the heck this means now too:
Plotly Dash which I think is phenomenal and has been on my to-learn list for over a year now. It does require you to understand Python decorators, which I haven't figured out yet. But it means you can load dynamic data into a customizable dashboard without any front end dev, and no matter what job you end up with that's a damned usefull piece of wizardry to have.
My north star in visual, clear design is the Vignelli Canon. Look it up, absorb it, you won't regret it I think.
I have to say that using something other than Seaborn and Plotly were explicit design constraints last semester. So, I'm ready to hulk out using those this time around.
For the key thing: learn how to use github, save the key in a file, use .gitignore for the file, open(file, r).
Sweet lord, thank you. That's been bugging me. Using Github makes it more simple.
Also, found a free version of Vignelli Canon. Woot!