This is what it takes to run a basic postgres database on my own PC (in a docker compose file):
postgres:
image: postgres:12.7
container_name: postgres
environment:
- PGDATA=/var/lib/postgresql/data/pgdata
- POSTGRES_PASSWORD=<pw>
volumes:
- ./volumes/postgres/:/var/lib/postgresql/data/
For someone who's completely allergic to SSH and linux, a managed Postgres service will take care of all that too.SQLite seems simple in that its "just a file". But its not. You can't pretend a backup is just copying the file while a DB is operating and expect it to be consistent. You can't put the file on NFS and have multiple writers and expect it to work. You can't use complex datatypes or have the database catch simple type errors for you. Its "simple" in precisely the wrong way - it looks simple, but actually using it well is not simple. It doesn't truly reduce operational burden, it only hides it until you find that it matters.
Similarly postgres is not automatically complex simply because it _can_ scale. It really is a good technology that can be simple at small scale yet complex if you need it.