small survey:
what databases do you use in your software?
(renote for visibility, thanks)
Thread
Login to reply
Replies ()
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
MongoDB 🤢 , Postgres
View quoted note →
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)
IndexedDB
SQLite
BadgerDB
Oracle and Postgres at work. Used to be big on MySQL.
LSM trees are usually only good for point lookups
mysql / postgres / redis / sled
is sled better than redb? is it finished?
Fjall is better than both I believe
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
Postgres, sqlite and mongo (sadly)
PostgreSQL, MongoDB (meh).