Database Options with Python APIs
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.