hmm, i'm curious why people think sqlite is easier/simpler than postgres?
@f0x that’s just `sqlite3 the-database-file`
@f0x I always have problems configuring permissions and access. Sqlite is just a file on the disk, and doesn’t require a daemon process, so you don’t have different processes vying for access to one shared system service. It’s so much easier from a small-time admin perspective!
@f0x With SQLite, I never need to run upgrade scripts because the major version didn’t change for over 10 years, migrating databases to a new server (and backing them up) is simpler, I don’t have to deal with another set of users and permissions. Every time the major version of PostgreSQL changes I have to look up the steps I have to take and make sure I have enough space (can be a problem on small VPSs).
I wouldn’t use sqlite for intensive things like a fediverse instance, but for a git forge with few users or a freshrss instance it’s great.
sqlite etc I always forget how to open the db file in case I need to do db surgery. I have postgres on basically all my systems and it uses like no resources?