small survey:
what databases do you use in your software?
(renote for visibility, thanks)
Login to reply
Replies (23)
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.
Sqlite, postgres, lmdb (only a tiny bit recently)
IndexedDB
SQLite
BadgerDB
they don’t have a consistency model
Oracle and Postgres at work. Used to be big on MySQL.
mysql / postgres / redis / sled
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
if a backend db is needed, then postgres is our go-to, unless there are specific reasons to use an alternative
LSM trees are usually only good for point lookups
Postgres at work. Sqlite for hobby (although with multi-threaded python it often breaks)
is sled better than redb? is it finished?
Postgres always. SQLite occasionally. MySQL never.
MongoDb: not even once
Fjall is better than both I believe
BRK uses a hand crafter db (brk_vecs) and Fjall
Supabase
Postgres, sqlite and mongo (sadly)
PostgreSQL, MongoDB (meh).