Re: Cuirass and SQL

2022-05-28 Thread jgart
On Fri, 27 May 2022 11:06:24 +0200 zimoun wrote: Hi Guixers, Here is the video recording from today: https://archive.org/details/guix-forge-arun-isaac-may-28-2022 enjoy, jgart https://whereis.xn--q9jyb4c/

Re: Cuirass and SQL

2022-05-28 Thread Arun Isaac
> 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. This

Re: Cuirass and SQL

2022-05-28 Thread Ryan Prior
--- Original Message --- On Saturday, May 28th, 2022 at 8:45 AM, Arun Isaac 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

Re: Arun Isaac Presentation on guix-forge this Saturday

2022-05-28 Thread david larsson
On 2022-05-25 16:14, Olivier Dion via "Development of GNU Guix and the GNU System distribution." wrote: On Tue, 24 May 2022, jgart wrote: hi guixers! I'd like to invite you this Saturday to a presentation on guix-forge by Arun Isaac: https://guix-forge.systemreboot.net/ Quick question abo

Re: Cuirass and SQL

2022-05-28 Thread Arun Isaac
Hi zimoun, > Initially, Cuirass was using SQLite but then switched [1] to > PostgreSQL. The main reason is scalability. Ah, I see. I didn't know that. > I do not know if it is a technically doable to have two SQL backends and > let the user pick the one they prefer. For sure, it is not doabl

Re: Cuirass and SQL

2022-05-28 Thread Blake Shaw
For any cuirass-curious readers, I want to say I deployed it on Linode a week ago and its been one of the most "just works" out-of-the-box tools in the guix arsenal that I've encountered. It was really easy and painless to get going, and makes "pinning" milestone system & profile generations a bree