This writeup is to provide an up-to-date list of database options for use in any Python application. I find that it's hard to know exactly what the landscape is out there. I will address database options (like SQLite) and database interface options (like SQLAlchemy). Data is sourced from the intersection of {Google Search, ChatGPT, I have personally used it}.

Databases

SQLite

ORMs

To be honest, probably just stick with SQLAlchemy with SQLite for local and Postgres for remote.