When I self host I lean towards SQLite simply because it’s simpler. In-place upgrades, trivial backups via Litestream, etc. Postgres major version upgrades are

When I self host I lean towards SQLite simply because it’s simpler. In-place upgrades, trivial backups via Litestream, etc. Postgres major version upgrades are the main reason I don’t self host it, though maybe I should rethink my position on that!