Thoughts on lightweight platforms like gotosocial? (lemmy.selfhostcat.com)

submitted 2 weeks ago by ocean@lemmy.selfhostcat.com to c/fediverse@lemmy.world

18 comments fedilink hide all child comments

you are viewing a single comment's thread
view the rest of the comments

[-] mbirth@lemmy.ml 5 points 2 weeks ago

Very happy with it. I’m running it with an SQLite database, so no extra database server is needed. And I’m using Elk as a frontend for when I don’t feel like using an app.

[-] ocean@lemmy.selfhostcat.com 2 points 2 weeks ago

Oh that’s very nice! Do you use that db for other services too?

[-] mbirth@lemmy.ml 1 points 2 weeks ago

Whenever it is supported, yes. I’m a huge fan of SQLite.

[-] ocean@lemmy.selfhostcat.com 2 points 2 weeks ago

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

[-] mbirth@lemmy.ml 2 points 2 weeks 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.db3 or myappdata.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.