Comment on Thoughts on lightweight platforms like gotosocial?
ocean@lemmy.selfhostcat.com 6 days agoI’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
mbirth@lemmy.ml 6 days ago
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.ocean@lemmy.selfhostcat.com 6 days ago
That’s very helpful! Thank you for taking the time to explain