From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp11.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms5.migadu.com with LMTPS id QC7VJRoxkmI5VwEAbAwnHQ (envelope-from ) for ; Sat, 28 May 2022 16:26:34 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp11.migadu.com with LMTPS id IP+6JRoxkmJdBAAA9RJhRA (envelope-from ) for ; Sat, 28 May 2022 16:26:34 +0200 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 4532615E51 for ; Sat, 28 May 2022 16:26:34 +0200 (CEST) Received: from localhost ([::1]:43632 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nuxOj-0007c3-Dd for larch@yhetil.org; Sat, 28 May 2022 10:26:33 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:48030) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nuxNk-0006rx-6p for guix-devel@gnu.org; Sat, 28 May 2022 10:25:32 -0400 Received: from mail-4316.protonmail.ch ([185.70.43.16]:47539) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nuxNi-0002mV-00 for guix-devel@gnu.org; Sat, 28 May 2022 10:25:31 -0400 Date: Sat, 28 May 2022 14:25:14 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=protonmail.com; s=protonmail3; t=1653747920; x=1654007120; bh=jZjmXz5A/PTZoK/WGZ9EwfbV1Z+9hR20cCJBVWELHHo=; h=Date:To:From:Cc:Reply-To:Subject:Message-ID:In-Reply-To: References:Feedback-ID:From:To:Cc:Date:Subject:Reply-To: Feedback-ID:Message-ID; b=Rqtg5D2OmATEiO/tq2jUt9Bdqoeaq9FhOnp9xMTRBdpn44x9dM2xlVjdDcixkIpsT LT2bIBlAUGyoPnJEGSZSw5CaU623BxivRtRAM+d71miJADENU5etqlK8dPQIsMqH3f csHkQqdqfD83DrKzSwhh5nmeUMEkdlmuGJt7riawH5S9EAQ4p/j/XKUmh3LVHtr4iq 0Iy5uCOLGosSA+D70FkxciT63q0HfHVCx0W6+iQV70jRI1LunnI+njb6/16oi7I9qj VklMCDhA4a1ERoRh8Ej3/78dx+jdRtMw0f06cQW/Swo8BeaDODKJKF3Yiwvf9Xw+gB A/yPKfDXzEeLQ== To: Arun Isaac From: Ryan Prior Cc: Guix Devel Subject: Re: Cuirass and SQL Message-ID: In-Reply-To: <87wne6m4e5.fsf@systemreboot.net> References: <20220524182656.GB31176@gac> <877d69hf6u.fsf@laura> <87mtf5o32q.fsf@systemreboot.net> <878rqncpkf.fsf@gmail.com> <87wne6m4e5.fsf@systemreboot.net> Feedback-ID: 7396961:user:proton MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Received-SPF: pass client-ip=185.70.43.16; envelope-from=rprior@protonmail.com; helo=mail-4316.protonmail.ch X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001, T_SCC_BODY_TEXT_LINE=-0.01 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: guix-devel@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "Development of GNU Guix and the GNU System distribution." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Reply-To: Ryan Prior Errors-To: guix-devel-bounces+larch=yhetil.org@gnu.org Sender: "Guix-devel" X-Migadu-Flow: FLOW_IN X-Migadu-To: larch@yhetil.org X-Migadu-Country: US ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1653747994; h=from:from:sender:sender:reply-to:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references:list-id:list-help: list-unsubscribe:list-subscribe:list-post:dkim-signature; bh=jZjmXz5A/PTZoK/WGZ9EwfbV1Z+9hR20cCJBVWELHHo=; b=uwo7BWT8dMZczcfBpv2vQoPI5f5C63qbXfpLjRCRxVraaxECnZeSHnaKlXfC2mOzOjGPNO o8Udl4+spkzvliF9Z1cijWQVr202LqocKScyyQ9J9w5/cLKELSDpbxhK5A2lw3RxBT3fxN GQhyMq6qmqWh8f35x6Cusi1H8BSN11rWJvu2e6qMo/WEHO6yLMV/pgkdlSxsmwxQlRMVL9 IpXd32U4B6XOaEP0ZJKO2jrxjLB0HlL2/dd/b9hODKLzSbcrEeF3Y+7+vjmBr2IGBbVwvw v9tODkgxA8QTFN8KKf/4Sr1drHl+nqyk84lyGBytf/or7bGFXyNVi+BLv8UsWw== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1653747994; a=rsa-sha256; cv=none; b=LzoOrfsXzi3fUaIYWDx9Qgep7RzxHQw2Y7EZwskdl9A8F0YlnSN0JvdC0IGzcgO7Oz+ZQ/ iaP4fOT2CZFgxnIXMTa5gxdNtZ2fb+QF11rres9Fm0eqTihU0v0YaIo0hQ0D7NheZkAshS 0AhviNmbgPrznOnJuhVNWUOjDPJJ6yJMbDX9ufsdKfrQT9wxYWRhXbH3ShzJRGeUDxfPIc vE4RCitBfnyp/vwbg+tzA4y18wY2wTZQiyTL5WdTdc6WlKj/mMiJj7/F+bB9g2EYrxyK5w NQ2ml8dK3nzUHGA4XaAcHGDi8rdZqcuG+ICFUKtSOHYqvuW/ZrQ7A8h7o1jGrw== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=protonmail.com header.s=protonmail3 header.b=Rqtg5D2O; dmarc=pass (policy=quarantine) header.from=protonmail.com; spf=pass (aspmx1.migadu.com: domain of "guix-devel-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="guix-devel-bounces+larch=yhetil.org@gnu.org" X-Migadu-Spam-Score: -2.54 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=protonmail.com header.s=protonmail3 header.b=Rqtg5D2O; dmarc=pass (policy=quarantine) header.from=protonmail.com; spf=pass (aspmx1.migadu.com: domain of "guix-devel-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="guix-devel-bounces+larch=yhetil.org@gnu.org" X-Migadu-Queue-Id: 4532615E51 X-Spam-Score: -2.54 X-Migadu-Scanner: scn1.migadu.com X-TUID: QhRVSxXk3j6j ------- 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 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 i= n "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 t= hat you'd use for an sqlite3 db file: file permissions.