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

Database	Python API/Library
SQLite	sqlite3
PostgreSQL	psycopg2
DuckDB	duckdb
MongoDB	PyMongo

ORMs

ORM
SQLAlchemy
PonyORM

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