------- Original Message ------- On Saturday, May 28th, 2022 at 8:45 AM, Arun Isaac <arunis...@systemreboot.net> wrote:
> There's still the complexity of backing up a PostgreSQL > database How much easier is sqlite3? I host a Postgres server on DigitalOcean with automatic db backup. I've had to restore, it's easy and it works. I also have a few apps in Fly.io using sqlite3, backups are equivalently easy. > Then, there's the added complexity of > maintaining database users and authentication For simplicity in a single-system deployment I recommend running postgres in "trust" mode and listen on a local unix socket rather than exposing it to the network. This allows you to use the same access control for Postgres that you'd use for an sqlite3 db file: file permissions.
