From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp10.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms5.migadu.com with LMTPS id qCoWK8LvkWKqSwAAbAwnHQ (envelope-from ) for ; Sat, 28 May 2022 11:47:46 +0200 Received: from aspmx1.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp10.migadu.com with LMTPS id KCEoKsLvkWJMGAAAG6o9tA (envelope-from ) for ; Sat, 28 May 2022 11:47:46 +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 70F57246CB for ; Sat, 28 May 2022 11:47:46 +0200 (CEST) Received: from localhost ([::1]:35886 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nus8S-0001xA-DL for larch@yhetil.org; Sat, 28 May 2022 04:49:24 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:34990) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nus5O-0000Yd-N2 for guix-devel@gnu.org; Sat, 28 May 2022 04:46:15 -0400 Received: from mugam.systemreboot.net ([139.59.75.54]:37900) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nus5L-0006VB-Db; Sat, 28 May 2022 04:46:13 -0400 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=systemreboot.net; s=default; h=Content-Type:MIME-Version:Message-ID:Date: References:In-Reply-To:Subject:To:From:Sender:Reply-To:Cc: Content-Transfer-Encoding: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=Z841Pzd72f4lSyJTGNf8wxzHjGGdpBIHR6myG+7blJc=; b=HjtXErkzDROuRNy/1OyuaycGPT hNzugkyn/xL9ds7ATLjKZBkb5XHxbcPKFANzFL/byCryIUKJ3f68eUKR3X1mQgPaSVweR7x5mJQ9y CgR92v/QglQViEoABNJs0fAUGi5WxXFEdHTckQNQWpsV/i3vO+diubn5q0RETGilEHNRZl/C67QFm QYWzqZECdOSsTjkgLAXDn5aPjCmwL2NN4zhvBsYNPbKrWYy8Qpfq9fdxeULo2pjvNl8+YgD/AgaOo IGEhzVzYJmFWXDQNNKIJpn8sqCbf7W1lY3pRyysiJAobESrg9tPWBXpqxrnxOqvyu1wcc9aLdi9W0 wFXtO3xA==; Received: from [192.168.2.1] (port=9506 helo=steel) by systemreboot.net with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.95) (envelope-from ) id 1nus55-000R15-L6; Sat, 28 May 2022 14:15:55 +0530 From: Arun Isaac To: zimoun , Olivier Dion , jgart , Guix Devel , Mathieu Othacehe Subject: Re: Cuirass and SQL In-Reply-To: <878rqncpkf.fsf@gmail.com> References: <20220524182656.GB31176@gac> <877d69hf6u.fsf@laura> <87mtf5o32q.fsf@systemreboot.net> <878rqncpkf.fsf@gmail.com> Date: Sat, 28 May 2022 14:15:54 +0530 Message-ID: <87wne6m4e5.fsf@systemreboot.net> MIME-Version: 1.0 Content-Type: text/plain 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=1653731266; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:mime-version:mime-version: content-type:content-type:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=Z841Pzd72f4lSyJTGNf8wxzHjGGdpBIHR6myG+7blJc=; b=EbdWjDvPysjuTeLkjBEIzJYQNVEdx2XK6F3srbNCM/NdjTgCSTqJNp/gAg2Nw63PeKUCxE L5Bd36LEYyUZ6oQyrOJ664fMpazlJStnWIqTcoCXbLYoVv0buQKsaf6OpKcGSuyYTX2Dhv prB5tm1hSR61N6uR+XInk+q/iWVWgfXDPpRl1srQHjEhm6/RVo+/aAcm4clwpiooC7Y2AC 2ht23lDNYCFjjkXEb+AH/5xH3+XOS1GD2IDfuZcia2r2IIl45qVcrH3oV2rAbAmcT9poUJ RdNDIWPmMfdYHj+wURhmyHQ+/N+B2PRzH8v7r0Ytv+eXeOz7Cg5IGKVASy+4Rg== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1653731266; a=rsa-sha256; cv=none; b=G+Ur4fTy8LWa/10UOJfdzh8OvjdBaqAjrGdO+7FZ2FMxJ/xsoGgmsaA2E+PtmOMpLqtTVK m6OWQHH7env++hnv07NbFm/IPyMS53gMNWjFYNneZ73Q4aQEueB1UncSEAV6qs9E39ZOF9 h6JPk5wMAtTGu6t9r0wYlVPw+PsSxjWeZOsnEh4fP8D6Sc3IzTYnqbTqY4cVmyg/2oWDt0 N0mUzrMX9OI+8ph4dVn0gPRRfan6i9B1KHMN64lS9asVYycLkWfsHvWnWyuOb6nVmvL0dj bXsIAWfDkXkOVpj3nnx9BBFrY063pDEEJP9mcab4OYgLp4GgUfkEYzwz/bHbhg== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=systemreboot.net header.s=default header.b=HjtXErkz; 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: 7.85 Authentication-Results: aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=systemreboot.net header.s=default header.b=HjtXErkz; 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: 70F57246CB X-Spam-Score: 7.85 X-Migadu-Scanner: scn0.migadu.com X-TUID: AyhuMswvLGSX 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 doable from > a maintenance point of view. It should be possible with guile-dbi and guile-dbd-*, which abstract away the database server in use. But, cuirass switched from guile-sqlite3 to guile-squee, both of which are database server specific. > About the complexity of PostgreSQL, I think the Guix services [2,3] > help here. There's still the complexity of backing up a PostgreSQL database---something IIUC the Guix service does not help with, and probably cannot help with. Then, there's the added complexity of maintaining database users and authentication. All this is very overkill for a small CI system. Cheers! Arun