From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp12.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 6DS/Bc8blWLwHAEAbAwnHQ (envelope-from ) for ; Mon, 30 May 2022 21:32:31 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp12.migadu.com with LMTPS id iKuZBc8blWK4rwAAauVa8A (envelope-from ) for ; Mon, 30 May 2022 21:32:31 +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 9C89D32665 for ; Mon, 30 May 2022 21:32:30 +0200 (CEST) Received: from localhost ([::1]:37932 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nvkpS-0004Ja-1o for larch@yhetil.org; Mon, 30 May 2022 15:13:26 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:57344) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nvkoy-0004FS-7i for guix-devel@gnu.org; Mon, 30 May 2022 15:12:56 -0400 Received: from mugam.systemreboot.net ([139.59.75.54]:37910) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nvkou-0004Mr-Qd; Mon, 30 May 2022 15:12:55 -0400 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=systemreboot.net; s=default; h=Content-Transfer-Encoding:Content-Type: MIME-Version:Message-ID:Date:References:In-Reply-To:Subject:Cc:To:From:Sender :Reply-To:Content-ID:Content-Description:Resent-Date:Resent-From: Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help: List-Unsubscribe:List-Subscribe:List-Post:List-Owner:List-Archive; bh=KDhvqqGFrRTqONguO7ELz+Mlcnq0o93hu+2eKthFSHA=; b=P8jrPbcKGzLvh7gVMYDdRdl2ii PMbMV10c8KP8rvSwHcfX2J5LypZAZmb1l8/dD6z8xsWSQnDMtEFAqCqkOQE+lITjuHrHbLpkdfTS4 onCKDidUFIZY27IfehzJSWHgviYPYnCz1L8I98+YFHJHmsRYdq5EP2/CkTwOZMT8TH5lzlOHpCj5l /zCNWBezzLrCUc/2ArloY7NUdE81KqZUURfULixjwFe0r4rpuuIR9V7hDPu0IWaTUt4cZkCEIlCVV Nlr0zUxt511e0krM8bP6XewmDF+eqouP+DOePGLpSmlIBvzFfm3HED2URXgjssR7mCVnV5Q2F7cds nLN2kYNA==; Received: from [192.168.2.1] (port=10156 helo=steel) by systemreboot.net with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.95) (envelope-from ) id 1nvkog-000X3u-NW; Tue, 31 May 2022 00:42:38 +0530 From: Arun Isaac To: Ludovic =?utf-8?Q?Court=C3=A8s?= Cc: zimoun , Olivier Dion , jgart , Guix Devel , Mathieu Othacehe Subject: Re: Cuirass and SQL In-Reply-To: <87wne310kf.fsf@gnu.org> References: <20220524182656.GB31176@gac> <877d69hf6u.fsf@laura> <87mtf5o32q.fsf@systemreboot.net> <878rqncpkf.fsf@gmail.com> <87wne6m4e5.fsf@systemreboot.net> <87wne310kf.fsf@gnu.org> Date: Tue, 31 May 2022 00:42:38 +0530 Message-ID: <87sfoqdec9.fsf@systemreboot.net> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Received-SPF: pass client-ip=139.59.75.54; envelope-from=arunisaac@systemreboot.net; helo=mugam.systemreboot.net 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, SPF_HELO_NONE=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: , 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=1653939150; h=from:from:sender:sender: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=KDhvqqGFrRTqONguO7ELz+Mlcnq0o93hu+2eKthFSHA=; b=V/j/JOezM25v/0NGu/H97rrTXIJbhmuu6vOWYJM5e2tDQYRSXLXEhNnm08+td7sJVHMjc4 v0HTYUF459A1AHBXkELrjPc5yMgY2OCB4Q+NhAOZz/MUbLWSczBc3ifGQvKl0qzR7KrvFF DARtIVUIlNm5dNcg/7DcxBg3RDrwp8ZcoEuLa1HNppwJq3mxnvjX9rxSZ+WP1IzV+v75Tu N0nDtHqXe7S7N3Aa02rGdUPyd2KBWo44wsUwN5CDOb+CCAnRhGosR4WBC4ItX4BeEqwJTJ +rSpbr/Ip1MO9BeyD8xM445kZsqqMu1sELAbMzU1dOULCYasmghKNpksItQ4jg== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1653939150; a=rsa-sha256; cv=none; b=K9qpQqyJXf/CKLP4NWgFaDVWTxc/q3bNf/M8C1Jl6Xn+n++k02nME6stouKsI20W95pVh3 wLjk48uVeQWyy+nOTtIM1QUyz+OPi3lPgiZ5Omyopmx1otcXZJjACOdmKffpYUHHDZM9vY M1BFGiBDEIn6O4CtiU8Tnk5fltLly9dPEzUa1GJdiNiRAdIIRwC+wHzPRe+EoqRTA4zD07 m6gsiDlstXjid//9Ng/4OKTAICMXAMXbn/nOgABRF67nC7pjifh5Hzj9uu6ByKXICJ865F ZlaQgZVrn14wT2BpMdpQhjtBgOrxwZLXQsCWUYORfgaVTfeFc/QVOIMvmtF6aw== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=systemreboot.net header.s=default header.b=P8jrPbcK; dmarc=fail reason="SPF not aligned (relaxed)" header.from=systemreboot.net (policy=none); 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: 6.57 Authentication-Results: aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=systemreboot.net header.s=default header.b=P8jrPbcK; dmarc=fail reason="SPF not aligned (relaxed)" header.from=systemreboot.net (policy=none); 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: 9C89D32665 X-Spam-Score: 6.57 X-Migadu-Scanner: scn0.migadu.com X-TUID: VCTGHgqdifj3 Hi Ludo, > Years before, Hydra (https://nixos.org/hydra) also dropped its SQLite > backend in favor of PostgreSQL only. > > Like you, not being a database person, I liked that SQLite was easy to > deploy and had a clear model: it just touches this one file and that=E2= =80=99s > it. Exactly! :-) If we use guile-dbi, it should be possible to support both sqlite and postgresql. Popular projects like Nextcloud do allow the user to choose their preferred database system. But, then again, Cuirass is built for very large scale. So, perhaps it is best to not try and also cover the small scale end. > SQLite may be good enough at a small scale; the problem is that you > never know how long it=E2=80=99ll be before the project you=E2=80=99re ho= sting is no > longer small-scale. Scale may not be an issue at least for the CI. Unlike Guix which needs to rebuild the entire world of software, most other software are only going to have a handful of jobs---easily less than 5 or less than 10 in the worst case. So, even if we trigger all these jobs on every commit, the total number of runs will easily be manageable with sqlite. Regards, Arun