alt Hacker NewsWhat about Postgres isn't low-maintenance?
The ball-ache of SQLite not scaling outweighs any "maintenance" Postgres needs (it really is just set-and-forget and use a Docker container to schedule database backups—whole thing takes a couple minutes).
Replies
nullify88 • today at 1:39 PM
I'm only now just starting out my on prem photo library and have a couple of thousand which sqlite with WAL seems to have no problems with.
Also considering the type of workload, I imagine photo albums to be write heavy upon photo imports but read heavy afterwards which sqlite should excel at. I'll mostly be syncing pictures from our phones, and it'll be me and the wife using it. Postgres is overkill for my needs.
What about having to do db migrations across major updates?
“SQLite doesn’t scale” is a common belief, but simply not true. It has limitations on certain sorts of loads, but you won’t run into them on this sort of app—in fact, I would expect consistently better performance from SQLite than from PostgreSQL in typical apps like this. And then SQLite is definitely easier to maintain, being just files.