this post was submitted on 22 Apr 2025
26 points (88.2% liked)
Fediverse
32959 readers
140 users here now
A community to talk about the Fediverse and all it's related services using ActivityPub (Mastodon, Lemmy, KBin, etc).
If you wanted to get help with moderating your own community then head over to [email protected]!
Rules
- Posts must be on topic.
- Be respectful of others.
- Cite the sources used for graphs and other statistics.
- Follow the general Lemmy.world rules.
Learn more at these websites: Join The Fediverse Wiki, Fediverse.info, Wikipedia Page, The Federation Info (Stats), FediDB (Stats), Sub Rehab (Reddit Migration)
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Whenever it is supported, yes. I’m a huge fan of SQLite.
I’ve only run docker containers with their own db. It sounds more logical to run one db, right? My only concern would be if that db corrupts then they all do.
Why do you like that over postgresql
Ohh, SQLite isn't "one" db. SQLite is file-based. I.e. a database in e.g. PostgreSQL (containing several tables, views, indexes, etc.) would translate to one SQLite file (e.g.
mydatabase.db3ormyappdata.sqlite). And each app has its own file/database. If the file corrupts, then it's only affecting that specific app. (However, SQLite is pretty robust.) And since these are just files, you can backup them together with the application. No need to export data or shutdown the database first.That’s very helpful! Thank you for taking the time to explain