30
Thoughts on lightweight platforms like gotosocial?
(lemmy.selfhostcat.com)
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 !moderators@lemmy.world!
Learn more at these websites: Join The Fediverse Wiki, Fediverse.info, Wikipedia Page, The Federation Info (Stats), FediDB (Stats), Sub Rehab (Reddit Migration)
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.db3
ormyappdata.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