[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Cuirass and SQL

From: Ryan Prior
Subject: Re: Cuirass and SQL
Date: Sat, 28 May 2022 14:25:14 +0000

------- Original Message -------
On Saturday, May 28th, 2022 at 8:45 AM, Arun Isaac <> 

> 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 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.

reply via email to

[Prev in Thread] Current Thread [Next in Thread]