From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp12.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 0I5WInnQkWIEPAEAbAwnHQ (envelope-from ) for ; Sat, 28 May 2022 09:34:17 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp12.migadu.com with LMTPS id AOMdInnQkWKHwwAAauVa8A (envelope-from ) for ; Sat, 28 May 2022 09:34:17 +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 1E9692E4B for ; Sat, 28 May 2022 09:34:17 +0200 (CEST) Received: from localhost ([::1]:41776 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nuqxj-0004RW-VG for larch@yhetil.org; Sat, 28 May 2022 03:34:15 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:53732) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nuqs4-0008Gh-0t for guix-devel@gnu.org; Sat, 28 May 2022 03:28:25 -0400 Received: from mail-pl1-x634.google.com ([2607:f8b0:4864:20::634]:39929) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1nuqs2-0002xy-2o for guix-devel@gnu.org; Sat, 28 May 2022 03:28:23 -0400 Received: by mail-pl1-x634.google.com with SMTP id a13so5990116plh.6 for ; Sat, 28 May 2022 00:28:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=sweatshoppe-org.20210112.gappssmtp.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=Rl8eATOd0xcbof7SHIQkC0vxs9UxUilm/Ygy2PPoWes=; b=7LuNBKfJd7deWC9tBK8k3al8kfhQ8ckUbBjAdVFf+CaN+yN/MeL8bqyAa+C186991+ JcQ5jKZVQJU4t51rDIY0rzb2f4EvByJHexQEYj2UTFcuNPL84krZ5ARJ/PoGUYFiNAXT Qh37lhpGOjr5e0y7ePl11F+It0FyUOmIdSXgTjZ7BUcm8xD7QtTj7kEaLV1K+YRKxraQ /wJUQR6ABIA+HxVHQEhwKkhzAYfxvQnVKPpK6G1NQDQ5A5PfZWQPA/R2YJjt0ln5o95S BynGMUhImSYjbL0BNAHfcOiHgDrnkPk3ox1T3anu51JfIUnu05C+DcCcdLStNGthEyqP XZyg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=Rl8eATOd0xcbof7SHIQkC0vxs9UxUilm/Ygy2PPoWes=; b=TXujMqHz0pWQEOtQmntPChgNw6WWzqLQVMFrMrb39/EdIP632RyJW48NO70LotSPoe q7zDLM4lSLvcuC4J8Uo7hxrY4EAcaYol16q43YMgcDrvqdgdmvc71E11NhGcESgNpMez JRMrIoXrcvndD+rEOhBSHKYymXYEwTXmdwPiIfHvu4ylMG0ZKmEn/PZA69H1BBGRbGGC oVnTTC9erkqZmbwYBr4hISQR1Y8j3t+FnWtYkT7CFMqfkW+opJhLMRcUzxzt5beEEnQn rnoDeol3kbF6gai5CGh99pKvNMSo+LiZmEvop6FoJ4W0aT9DSed95gqalgBNxrHls8LO B4/A== X-Gm-Message-State: AOAM533DMIJoUnC66aTgUS5YZxoxq2QTYQUioinq4bZP9O9vVJmJhg5l zxwnVC7e2/yr/tXgifmsHiknP8gZICNMOtf9o5GvlA== X-Google-Smtp-Source: ABdhPJzgWjDgVAoXaj+0HAEQipS81jRDwJKQFGX6pBwO251/z5TU+opaTg9a8/LManfWsJuI0UQYwJNzihi66PBhN7Y= X-Received: by 2002:a17:902:eb86:b0:162:1654:4a08 with SMTP id q6-20020a170902eb8600b0016216544a08mr30827644plg.72.1653722899834; Sat, 28 May 2022 00:28:19 -0700 (PDT) MIME-Version: 1.0 References: <20220524182656.GB31176@gac> <877d69hf6u.fsf@laura> <87mtf5o32q.fsf@systemreboot.net> <878rqncpkf.fsf@gmail.com> In-Reply-To: <878rqncpkf.fsf@gmail.com> From: Blake Shaw Date: Sat, 28 May 2022 14:28:08 +0700 Message-ID: Subject: Re: Cuirass and SQL To: zimoun Cc: Arun Isaac , Olivier Dion , jgart , Guix Devel , Mathieu Othacehe Content-Type: multipart/alternative; boundary="000000000000007fba05e00d5e19" Received-SPF: none client-ip=2607:f8b0:4864:20::634; envelope-from=blake@sweatshoppe.org; helo=mail-pl1-x634.google.com 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, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_NONE=0.001, T_SCC_BODY_TEXT_LINE=-0.01 autolearn=unavailable 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=1653723257; 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:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=Rl8eATOd0xcbof7SHIQkC0vxs9UxUilm/Ygy2PPoWes=; b=psT0L/43QmA6r4OA15V8jgj29z71R+XAPGbCUz6f5CsBG4VO4iqGj2RqyjLCXVl95eg5fC /T9d7ujdefZgyytv+ynZEStK//vMfCLRrAduPFy+/r0fU4qERIaGCh4TJO16mMq3S4O+ev roRT+ni2aMkkazLYXMtMW00NxOlHtV3PvxiEKIUR+Yr7u+AgWwfy/jYmvS6P1qUATRoo9Q P9j2GHRSu9LPAP30yxEBD7goAS8xyYILkMLM9paWjAUcXOgqPLGO/dYksDtPMnytUreI7q 6a+YnhDINv3mbB86cL6+2vk8wuFJL3QWuTS+LV/LBt8k33BpyJo4tpPbGPND2g== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1653723257; a=rsa-sha256; cv=none; b=uOt1RLr/qF2O/l4UyaXkSf1K2gj0EUeP38QPg6HfPIsvWXq3DqskY0CICq15mHv39G167W W6wlZUb3v+lMghu71KYwBZvmmr+OSNJFa9paTp7sLKwGt50QiwpqkjJiWFYLOShjjMxPQl cPW4974/SfvcSwxLccTV1F7SDDhajXMO4Uy7HPF3Q3I4dSi83ELKMXUOENboOckQfAlMBB yF9ZI4MfpdlQ2dYcPqGBx7Mp2fjKM3jXrg5zLE1aynYe01ATjboUaBz+hkASX0NmWH613t J5b9J56OQS4YhV4gGSoLsrO3K9/GRt3igCKo0GJratLqI2E7OXTjhK1oesa9mQ== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=sweatshoppe-org.20210112.gappssmtp.com header.s=20210112 header.b=7LuNBKfJ; dmarc=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: -1.05 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=sweatshoppe-org.20210112.gappssmtp.com header.s=20210112 header.b=7LuNBKfJ; dmarc=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: 1E9692E4B X-Spam-Score: -1.05 X-Migadu-Scanner: scn0.migadu.com X-TUID: fbXe3p0z7Fux --000000000000007fba05e00d5e19 Content-Type: text/plain; charset="UTF-8" For any cuirass-curious readers, I want to say I deployed it on Linode a week ago and its been one of the most "just works" out-of-the-box tools in the guix arsenal that I've encountered. It was really easy and painless to get going, and makes "pinning" milestone system & profile generations a breeze so that you always have substitutes available for them. This has sped up my guix workflow tremendously, as I'm able to just commit push, branch off, try other ideas, push, review past results and keep moving, instead of getting distracted by checking the news or what have you. The remote-server sometimes stops allocating builds to workers though, but I just restart the server and its fine. Feels like proper boutique gear, too ;) On Fri, May 27, 2022, 16:41 zimoun wrote: > Hi, > > On jeu., 26 mai 2022 at 00:24, Arun Isaac > wrote: > > >> Quick question about guix-forge. Why laminar instead of cuirass as > >> the CI? > > > > Two reasons: > > > > - Cuirass requires a PostgreSQL database, but I wanted guix-forge to be > > as stateless as possible and definitely not require a complex database > > server like PostgreSQL. Laminar just uses sqlite. > > Initially, Cuirass was using SQLite but then switched [1] to > PostgreSQL. The main reason is scalability. > > 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. > > About the complexity of PostgreSQL, I think the Guix services [2,3] help > here. > > > > 1: < > http://git.savannah.gnu.org/cgit/guix/guix-cuirass.git/commit/?id=cbc462679d2647ecc897231cc78781a90fa2441a > > > 2: < > https://guix.gnu.org/en/manual/devel/en/guix.html#Continuous-Integration> > 3: > > > Cheers, > simon > > --000000000000007fba05e00d5e19 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
For any cuirass-curious readers, I want to say I deployed= it on Linode a week ago and its been one of the most "just works"= ; out-of-the-box tools in the guix arsenal that I've encountered. It wa= s really easy and painless to get going, and makes "pinning" mile= stone system & profile generations a breeze so that you always have sub= stitutes available for them. This has sped up my guix workflow tremendously= , as I'm able to just commit push, branch off, try other ideas, push, r= eview past results and keep moving, instead of getting distracted by checki= ng the news or what have you.

= =C2=A0The remote-server sometimes stops allocating builds to workers though= , but I just restart the server and its fine.

Feels like proper boutique gear, too = ;)

On Fri, May 27, 2022, 16:41 zimoun <zimon.toutoune@gmail.com> wrote:
Hi,

On jeu., 26 mai 2022 at 00:24, Arun Isaac <arunisaac@systemreboo= t.net> wrote:

>> Quick question about guix-forge.=C2=A0 Why laminar instead of cuir= ass as
>> the CI?
>
> Two reasons:
>
> - Cuirass requires a PostgreSQL database, but I wanted guix-forge to b= e
>=C2=A0 =C2=A0as stateless as possible and definitely not require a comp= lex database
>=C2=A0 =C2=A0server like PostgreSQL. Laminar just uses sqlite.

Initially, Cuirass was using SQLite but then switched [1] to
PostgreSQL.=C2=A0 The main reason is scalability.

I do not know if it is a technically doable to have two SQL backends and let the user pick the one they prefer.=C2=A0 For sure, it is not doable fro= m
a maintenance point of view.

About the complexity of PostgreSQL, I think the Guix services [2,3] help he= re.



1: <http://git.savannah.gnu.org/cgit/guix/guix-cuiras= s.git/commit/?id=3Dcbc462679d2647ecc897231cc78781a90fa2441a>
2: <https://gu= ix.gnu.org/en/manual/devel/en/guix.html#Continuous-Integration>
3: <https://guix.gn= u.org/en/manual/devel/en/guix.html#Database-Services>


Cheers,
simon

--000000000000007fba05e00d5e19--