From mboxrd@z Thu Jan 1 00:00:00 1970 From: Christopher Baines Subject: Re: Hackathon: Mumi and Cuirass Date: Mon, 06 May 2019 23:10:19 +0100 Message-ID: <878svjnsj8.fsf@cbaines.net> References: <875zqrgqlf.fsf@elephly.net> <20190506225554.43e93d0d@alma-ubu> Mime-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha512; protocol="application/pgp-signature" Return-path: Received: from eggs.gnu.org ([209.51.188.92]:41979) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1hNloa-0000YG-52 for guix-devel@gnu.org; Mon, 06 May 2019 18:10:30 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1hNloY-0000se-WC for guix-devel@gnu.org; Mon, 06 May 2019 18:10:28 -0400 Received: from mira.cbaines.net ([2a01:7e00::f03c:91ff:fe69:8da9]:44202) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1hNloY-0000oV-69 for guix-devel@gnu.org; Mon, 06 May 2019 18:10:26 -0400 In-reply-to: <20190506225554.43e93d0d@alma-ubu> 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: =?utf-8?Q?Bj=C3=B6rn_H=C3=B6fling?= Cc: guix-devel@gnu.org --=-=-= Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Bj=C3=B6rn H=C3=B6fling writes: >> 2) Cuirass > > On Guix days, we discussed the idea of using Postgresql as a backend. > Could that also be a task for hacking? > > Chris, have you worked on that? I think I saw you adding some > guile-postgres bindings as a Guix-package. I've been using PostgreSQL from Guile for the Guix Data Service [1] stuff, guile-dbd-postgresql didn't work out, I can't remember exactly why, but I think it could have had something to do with error handling/reporting. Anyway, guile-squee seems to do the trick. 1: https://git.cbaines.net/guix/data-service/ I'm interested in doing some Cuirass stuff, but I'm still a little uncertain about how you might go about that. I think there's probably some easier related tasks though. One thing that I saw related to Sqlite is that the rowid's that Cuirass does use behave differently if there's an INTEGER PRIMARY KEY column in the table [2]. This is important I think, because without this, operations like VACUUM can change the rowid's [3]. I think Cuirass uses rowid's as the identitifers for builds for example, but not in this way. 2: https://www.sqlite.org/draft/lang_createtable.html#rowid 3: https://www.sqlite.org/draft/lang_vacuum.html --=-=-= Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQKTBAEBCgB9FiEEPonu50WOcg2XVOCyXiijOwuE9XcFAlzQsMtfFIAAAAAALgAo aXNzdWVyLWZwckBub3RhdGlvbnMub3BlbnBncC5maWZ0aGhvcnNlbWFuLm5ldDNF ODlFRUU3NDU4RTcyMEQ5NzU0RTBCMjVFMjhBMzNCMEI4NEY1NzcACgkQXiijOwuE 9Xc7+hAAnzl9x+d7ber8n9vkTsQrKvisD10p085pW1p/yH4XiR3VnCfs2Hu1rucD 7w2ZjxUuqBTkz9uJuMPgaSmfjPMBHr9Vq+SZsXwAqPcPOd6Lwb6HeT9f504rFREj R2vxf5/yl8FGGE1wCe2KnUdmDV8Sw+BMx3hWy7OyxY5Ud1UmyYZLonHj5VJbQ4KM RDwepRsvXvZSL7G3CvpxaYnN+hzDHZE3G0dOCP9lk7BjI23jX4UzWhrqVfnayN5k WISBVeEVr+YTfWFZm/Ey8Rz1PiLntsoOsOtmuXtu5mxryJNw0lFkGMtCcWnznD5S AQ+EbLfCHyJUirQReDitRqkaSyLYVDe8kYZ3s3X2In1RsTMBKOLK0PuCqaK7X8iM 4ew2+ov+eLmyHRieSgCRRMkZpFRfp5wLCrE/UWSv9XfiW5vW7NEdqpSUkzW6qOFC 69WOQjLdb07iXtyFPhEhoWz7wyKd9VEgkq2Gc5uJPP0bIz8UYCREG14IItV9eqSv aEz2tMtQEsHldmGdYkIq9Udf6zUUo0/ZGP2xK2hOuJ0s5nPDy+VyQCtHqVW8aI6U lHFP9AqXV7pE8SclmR6aAr1DHKKJUJ8u16SqYg76bZL6CIL4bysklkhys/7iAKgW hFA0jAYBP0Ou8vWh4J0pIhVMf/BSgtq79lR+hvLMozgVYgcivW8= =Znm5 -----END PGP SIGNATURE----- --=-=-=--