From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Jonas Bernoulli Newsgroups: gmane.emacs.devel Subject: Re: sqlite3 Date: Wed, 08 Dec 2021 01:17:28 +0100 Message-ID: <87a6hc7xwn.fsf@bernoul.li> References: <87tufmjyai.fsf@gnus.org> <9217effc-960a-0b80-50b2-88142806cdae@gmail.com> <87r1aqmdsr.fsf@gnus.org> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="10773"; mail-complaints-to="usenet@ciao.gmane.io" Cc: emacs-devel@gnu.org To: Lars Ingebrigtsen , =?utf-8?Q?Cl=C3=A9ment?= Pit-Claudel Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Wed Dec 08 01:21:23 2021 Return-path: Envelope-to: ged-emacs-devel@m.gmane-mx.org Original-Received: from lists.gnu.org ([209.51.188.17]) by ciao.gmane.io with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1muki2-0002cL-LM for ged-emacs-devel@m.gmane-mx.org; Wed, 08 Dec 2021 01:21:23 +0100 Original-Received: from localhost ([::1]:37318 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1muki0-0000am-PL for ged-emacs-devel@m.gmane-mx.org; Tue, 07 Dec 2021 19:21:20 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:59832) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mukeP-00086A-68 for emacs-devel@gnu.org; Tue, 07 Dec 2021 19:17:37 -0500 Original-Received: from mail.hostpark.net ([212.243.197.30]:45610) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mukeM-00070m-N2 for emacs-devel@gnu.org; Tue, 07 Dec 2021 19:17:36 -0500 Original-Received: from localhost (localhost [127.0.0.1]) by mail.hostpark.net (Postfix) with ESMTP id 709171651F; Wed, 8 Dec 2021 01:17:30 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=bernoul.li; h= content-transfer-encoding:content-type:content-type:mime-version :message-id:date:date:references:in-reply-to:subject:subject :from:from:received:received; s=sel2011a; t=1638922648; bh=OgvyS wHx5IkyyDJjFmIigMSiqC21pHWMh+wu/rw44fA=; b=A2+8QK3NiNNe0HK4o3a0j YGCMToCot3BrxT147tRBd1H1w5MdrcTXzbDkozzTIYAHyTKFuWLMSUoeGcskpUFd VfHVe00byrmyON1lOf+gM1RWXUW9o0shw7mMu1daCvkbTH8REpyZh2DHvroGF/zL woQSjyZvoj1+aN3ehEsObE= X-Virus-Scanned: by Hostpark/NetZone Mailprotection at hostpark.net Original-Received: from mail.hostpark.net ([127.0.0.1]) by localhost (mail0.hostpark.net [127.0.0.1]) (amavisd-new, port 10224) with ESMTP id Wi7rO712ftGD; Wed, 8 Dec 2021 01:17:28 +0100 (CET) Original-Received: from customer (localhost [127.0.0.1]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-256) server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) by mail.hostpark.net (Postfix) with ESMTPSA id 4766D165C5; Wed, 8 Dec 2021 01:17:28 +0100 (CET) In-Reply-To: <87r1aqmdsr.fsf@gnus.org> Received-SPF: none client-ip=212.243.197.30; envelope-from=jonas@bernoul.li; helo=mail.hostpark.net X-Spam_score_int: -27 X-Spam_score: -2.8 X-Spam_bar: -- X-Spam_report: (-2.8 / 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, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_HELO_NONE=0.001, SPF_NONE=0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-devel@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "Emacs development discussions." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Original-Sender: "Emacs-devel" Xref: news.gmane.io gmane.emacs.devel:281292 Archived-At: Lars Ingebrigtsen writes: > Cl=C3=A9ment Pit-Claudel writes: > >> There is also https://github.com/skeeto/emacsql , which builds SQLite3 >> as part of its installation. It's already available and in use by the >> forge package (https://magit.vc/manual/forge.html), and it doesn't >> depend on modules. > > "It works by maintaining a inferior process running (a "connection") for > interacting with the back-end database." > > So it just talks to an sqlite3 executable over a pipe? That's not > really what we're looking for here... Emacsql provides mainly two things: 1) An abstraction over different sql implementations. 2) A s-expressions dsl to write sql. But I also think we should use syohex's sqlite3 module directly. That being said emacsql can be taught to use the sqlite3 module, in fact I have already done that in the emacsql-libsqlite3 [1] package. 1: https://github.com/emacscollective/emacsql-libsqlite3 In my experience the sqlite3 module works reliably and I though I would mention my wrapper around that in case Cl=C3=A9ment or some other Forge/Epkg user would be interested in something like that. Jonas