small survey:
what databases do you use in your software?
(renote for visibility, thanks)
Discussion
note:
software like strfry that act almost identically to a database count
service discovery and secret storage counts
object storage also counts
redis also counts
- nostr relays
- postgres
- SQLite
- Browser storage
In memory, I'm learning mongo stuff, SQLite for anything else.
mongo is shit
I feel like that can't be true. It's different. There are other schemes to make a document store just as fast. Not the same as SQL databases.
they don’t have a consistency model
That's not really true. Oob it's configured for high availability and flexibility. But you can configure read write concerns to control how many replicas must acknowledge a change before it's considered successful if you need more consistency.
That's just the nature of a document store vs a relational db.
you can build a document db with strict serializability and you can build a relational db with the consistency model of mongo
having strict consistency does not require trading off high availability or flexibility
mongodb does not fsync by default so if it crashes it can lose “written” data
it is a dynamo-type DB, but objectively worse
Sqlite, postgres, lmdb (only a tiny bit recently)
if a backend db is needed, then postgres is our go-to, unless there are specific reasons to use an alternative
whatever chatgpt tells me to install
Postgres at work. Sqlite for hobby (although with multi-threaded python it often breaks)
Postgres always. SQLite occasionally. MySQL never.
MongoDb: not even once
BRK uses a hand crafter db (brk_vecs) and Fjall
Supabase
Postgres, sqlite and mongo (sadly)
PostgreSQL, MongoDB (meh).