From mboxrd@z Thu Jan 1 00:00:00 1970 From: Ricardo Wurmus Subject: Re: postgresql vs sqlite for Cuirass (was Re: Hackathon: Mumi and Cuirass) Date: Fri, 17 May 2019 22:29:51 +0200 Message-ID: <874l5sese8.fsf@elephly.net> References: <875zqrgqlf.fsf@elephly.net> <20190506225554.43e93d0d@alma-ubu> <87imuabhsw.fsf@roquette.mug.biscuolo.net> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Return-path: Received: from eggs.gnu.org ([209.51.188.92]:56580) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1hRn1F-0007t7-6l for guix-devel@gnu.org; Fri, 17 May 2019 20:16:10 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1hRn1E-00073w-6z for guix-devel@gnu.org; Fri, 17 May 2019 20:16:09 -0400 Received: from sender4-of-o53.zoho.com ([136.143.188.53]:21302) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1hRn1D-000735-RA for guix-devel@gnu.org; Fri, 17 May 2019 20:16:08 -0400 In-reply-to: List-Id: "Development of GNU Guix and the GNU System distribution." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: guix-devel-bounces+gcggd-guix-devel=m.gmane.org@gnu.org Sender: "Guix-devel" To: Aljosha Papsch Cc: guix-devel@gnu.org Aljosha Papsch writes: > Am Freitag, den 17.05.2019, 10:26 +0200 schrieb G=C3=A1bor Boskovits: >> Any suggestions to overcome this would be appreciated. > > I would go with the client/server database. It helps scaling in the > long term and Guix must take over the world, no? With SQLite you'll be > stuck with the single file on a single server. You could implement your > custom replication using rsync or whatever, but you'll have to ensure > that the receivers do not write to the file (readonly "slaves"). In the > end it will be a problem already solved by Postgres and other > server/client databases. Our current problem is not replication and we=E2=80=99re far from needing i= t at this point. I think there are better ways to improve Cuirass than to switch to Postgres. -- Ricardo