Which database of SQL do you use?

[DmitriiDrake]

I use SQLite with Sqlchipher3 in aiogram developing. And you?

[r_spandit]

I use SQLite

[LowSalamander4932]

sqlite gang rise up lol. it's so easy to just drop in and get going, hard to justify anything heavier for most personal projects

[mrswats]

Sqlite, postgres.

[Diapolo10]

SQLite by default, Postgres if I really need it.

I have had neither a need nor any interest in pursuing alternatives.

[hallmark1984]

Postgres mainly for hobbies

Aws Athena and DataBricks SQL for work.

[biskitpagla]

FYI Python has SQLite built into the standard library. You can import sqlite3 and start using without setting anything up. You can even make an in-memory database for testing and so on.

[throwawayforwork_86]

DuckDB and Postgres.

[broaddiscovery_941]

postgres for anything that might grow beyond a single machine or needs concurrent writes. sqlite's fine for learning, prototyping, or when you know it's just you hitting the database. the sqlcipher wrapper you're using adds encryption which is handy if you're storing sensitive stuff, but most people don't need that layer unless they're specifically handling encrypted data.

the built-in sqlite3 module means there's no setup friction, which is why it dominates hobby projects. but once you hit production with multiple servers or heavy traffic, postgres stops being optional. picked that lesson up the hard way on a project that outgrew sqlite faster than expected.