From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp10.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms5.migadu.com with LMTPS id ULmVH97clGICyQAAbAwnHQ (envelope-from ) for ; Mon, 30 May 2022 17:03:58 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp10.migadu.com with LMTPS id UCqeHt7clGLshwAAG6o9tA (envelope-from ) for ; Mon, 30 May 2022 17:03:58 +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 2A2ECAC2D for ; Mon, 30 May 2022 17:03:58 +0200 (CEST) Received: from localhost ([::1]:38966 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nvgw1-0000W1-8o for larch@yhetil.org; Mon, 30 May 2022 11:03:57 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:53168) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nvgvI-0000Ve-Qd for guix-devel@gnu.org; Mon, 30 May 2022 11:03:12 -0400 Received: from smtp.polymtl.ca ([132.207.4.11]:56020) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nvgv2-0005M8-8T; Mon, 30 May 2022 11:03:11 -0400 Received: from localhost (modemcable094.169-200-24.mc.videotron.ca [24.200.169.94]) by smtp.polymtl.ca (8.14.7/8.14.7) with ESMTP id 24UF2Zht004301; Mon, 30 May 2022 11:02:39 -0400 DKIM-Filter: OpenDKIM Filter v2.11.0 smtp.polymtl.ca 24UF2Zht004301 To: zimoun , Arun Isaac , 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: Mon, 30 May 2022 11:02:35 -0400 Message-ID: <8735grrrlg.fsf@laura> MIME-Version: 1.0 Content-Type: text/plain X-Poly-FromMTA: (modemcable094.169-200-24.mc.videotron.ca [24.200.169.94]) at Mon, 30 May 2022 15:02:35 +0000 Received-SPF: pass client-ip=132.207.4.11; envelope-from=olivier.dion@polymtl.ca; helo=smtp.polymtl.ca X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, 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: , Errors-To: guix-devel-bounces+larch=yhetil.org@gnu.org Sender: "Guix-devel" Reply-to: Olivier Dion From: Olivier Dion via "Development of GNU Guix and the GNU System distribution." 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=1653923038; h=from:from:sender:sender:reply-to: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; bh=log/sTTY2ROiL58PvJKHlvD1IxK6Ij2rFFU5A1aNsis=; b=lTp+l0Wnt/TN7jG6iYiwXdr2NZjyMbNyyZ34dzhpBVnML/QFuPKaFRZsKE8+JkDCM51KXo VShBTqN6+57sY26Jug+VvKr3pkwf/VRPq7V2vQ/KzbS3f1fpP52Barn7McX1T5NM/adIlZ 2wjc37NderuN8bvWRnNhHwLYQqlUxjEbndrls/WBIKK7vMXSrIauDjKdbYGr92OddZ8GkV VcXwMdzpRSRE5oDD/kobF6GvCJ3WPn8SSMqD8TlBXVYc+b5DmyTxEe44GMlROgv6KzeqP8 7nTCRA2mFy6ZF7cM6uuRWAlKfZpc+sI+UjZ6esughF2xnE510yjtlFU8rSOZ8g== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1653923038; a=rsa-sha256; cv=none; b=oCoc8BK3pDnyio2jRaJZdxNBHXbhFq+hcl38CHFz0c+hGEK/Sn8COtWMGvI6EMoaNks7DZ G8MJGYtDkHUyErWeR9NHimvYxvrpThHTalCkJqx1XlgHFM2wnf61kStaSe7KqLGVWjK4gZ WGjrIXC5K6PY4Rfj/1BkZFuP12mCjGi3xnXsq+lpPcyMK7QJaN4H+VKaIY+o70SrDLW9ba 4btgY7y/3e8c7YR1ofDXdt/svIorWauj/ZM7mP0QtAvcVnQbmum6FVgED5cUCoDr3fAm1O /0NG+YjYzyp1nh73kZcyyGmCeDQ0V6xL5N1Og7QO5ABsBiTYxw9dV0SqxPVVZg== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=none; dmarc=pass (policy=none) header.from=gnu.org; 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: -1.53 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=pass (policy=none) header.from=gnu.org; 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: 2A2ECAC2D X-Spam-Score: -1.53 X-Migadu-Scanner: scn1.migadu.com X-TUID: bzBPldUic17d On Fri, 27 May 2022, zimoun wrote: > Initially, Cuirass was using SQLite but then switched [1] to > PostgreSQL. The main reason is scalability. Make sens for the main CI used by Guix or for an organization. > 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. With guile-dbi, the maintenance is trivial. > About the complexity of PostgreSQL, I think the Guix services [2,3] > help here. This is what I did. I have a local CI as a service that build my projects at every new commits on a specific branch. It works, but I feel thing would have been easier to setup with SQLite. It could had been a guix-home service for example instead of a system service and testing the configuration is much easier with a scratch DB. -- Olivier Dion oldiob.dev