Setting up heroku database

I have heard of this referred to as the curse of knowledge and it is a tough one!

You and Ben's videos (and this forum) are the only reason I was able to find my way thorugh Wappler. I really appreciate your willingness to share 40+ years of experience with so us all.

Things I think aren't immediately obvious to learners include:

The difference between Database Manager settings and what ends up in Server Connect Globals - Database Connections really didn't make sense to me for a long time. Wappler doesn't seem to have user interface cues or guardrails for things you must do ... like closing db.json before swiching between and editing environments. Sure, it makes sense why you have to close these things, but the lack of error messaging makes it one of those things you just "have to know"

I learned a lot watching the 2020 Zoom meeting I linked above where George intro'd the first version of Database Manager. It is outdated now, but contains so much foundational knowledge that helped me grasp how the Database Manager is expected to work and be used. I don't know if that same info is in Docs somewhere.

I've also been using Wappler long enough to remember when every API step needed its own DB connection step in a repetitive way. So I understand why things are the way they are now, but if you didn't use the "old way" the new way really seems counterintuitive to me. Not that it can't be learned or doesn't make sense, it is just difficult to understand why the Target settings and Database Manager settings and Globals - Database Connections can sometimes by sync'd, sometimes not, sometimes overwritten, etc.

Thanks again for all the knowledge you share on these topics!