Re: Cuirass and SQL

[Ryan Prior]

------- Original Message -------
On Saturday, May 28th, 2022 at 8:45 AM, Arun Isaac <arunisaac@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.