From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Philip Kaludercic Newsgroups: gmane.emacs.devel Subject: Re: sqlite3 Date: Fri, 10 Dec 2021 14:46:17 +0000 Message-ID: <87y24s4ix2.fsf@posteo.net> References: <87tufmjyai.fsf@gnus.org> <87tufhel3z.fsf@posteo.net> <87fsr12tm8.fsf@gnus.org> Mime-Version: 1.0 Content-Type: text/plain Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="30495"; mail-complaints-to="usenet@ciao.gmane.io" Cc: emacs-devel@gnu.org To: Lars Ingebrigtsen Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Fri Dec 10 15:48:14 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 1mvhC1-0007hD-3c for ged-emacs-devel@m.gmane-mx.org; Fri, 10 Dec 2021 15:48:13 +0100 Original-Received: from localhost ([::1]:45472 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1mvhBy-0008Ra-SF for ged-emacs-devel@m.gmane-mx.org; Fri, 10 Dec 2021 09:48:10 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:53132) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mvhAK-0006rA-0F for emacs-devel@gnu.org; Fri, 10 Dec 2021 09:46:29 -0500 Original-Received: from mout02.posteo.de ([185.67.36.66]:38705) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mvhAG-0007KO-Q2 for emacs-devel@gnu.org; Fri, 10 Dec 2021 09:46:27 -0500 Original-Received: from submission (posteo.de [89.146.220.130]) by mout02.posteo.de (Postfix) with ESMTPS id 5B4ED240103 for ; Fri, 10 Dec 2021 15:46:22 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=posteo.net; s=2017; t=1639147582; bh=4clwcdUAERKyqdUxhP85s2Fr2ve1uVkCZpMBCtR5rZU=; h=From:To:Cc:Subject:Autocrypt:Date:From; b=QWoVHslECtF104qAjdQIPkTEB0z82BdHlhnadnR1wot5dnaPW58NGchnd24XnQwMI 5KIKlf/iNsATSmj2QUO/g+20yzNgFFMeUfN+Fo+C+Lal8fy23lwX5sMs6qcZpfGR5W f58Gfhz2cqvPT2X1NPLIXnrA3tKeeFpO2wIuo6MfNzmi54vg8INVeOaTeQiejJfoZj tJF6ZzXJCNLMX5DqDuWeG0fXu0oqpKm/wq9mwysc8zIEVhwihUNJ8Amm5vhwbHDCpg Qg31CcHNQbm0MfaGE40pewRxGZKYlPSHTIePvIRPbcLY2ZHgypih5lWRCED78Fv4iA 8EMqOSTGv8glw== Original-Received: from customer (localhost [127.0.0.1]) by submission (posteo.de) with ESMTPSA id 4J9Ycs2z2rz6tm6; Fri, 10 Dec 2021 15:46:21 +0100 (CET) Autocrypt: addr=philipk@posteo.net; prefer-encrypt=nopreference; keydata= mDMEYHHqUhYJKwYBBAHaRw8BAQdAp3GdmYJ6tm5McweY6dEvIYIiry+Oz9rU4MH6NHWK0Ee0QlBo aWxpcCBLYWx1ZGVyY2ljIChnZW5lcmF0ZWQgYnkgYXV0b2NyeXB0LmVsKSA8cGhpbGlwa0Bwb3N0 ZW8ubmV0PoiQBBMWCAA4FiEEDM2H44ZoPt9Ms0eHtVrAHPRh1FwFAmBx6lICGwMFCwkIBwIGFQoJ CAsCBBYCAwECHgECF4AACgkQtVrAHPRh1FyTkgEAjlbGPxFchvMbxzAES3r8QLuZgCxeAXunM9gh io0ePtUBALVhh9G6wIoZhl0gUCbQpoN/UJHI08Gm1qDob5zDxnIHuDgEYHHqUhIKKwYBBAGXVQEF AQEHQNcRB+MUimTMqoxxMMUERpOR+Q4b1KgncDZkhrO2ql1tAwEIB4h4BBgWCAAgFiEEDM2H44Zo Pt9Ms0eHtVrAHPRh1FwFAmBx6lICGwwACgkQtVrAHPRh1Fw1JwD/Qo7kvtib8jy7puyWrSv0MeTS g8qIxgoRWJE/KKdkCLEA/jb9b9/g8nnX+UcwHf/4VfKsjExlnND3FrBviXUW6NcB In-Reply-To: <87fsr12tm8.fsf@gnus.org> (Lars Ingebrigtsen's message of "Fri, 10 Dec 2021 01:25:51 +0100") Received-SPF: pass client-ip=185.67.36.66; envelope-from=philipk@posteo.net; helo=mout02.posteo.de X-Spam_score_int: -43 X-Spam_score: -4.4 X-Spam_bar: ---- X-Spam_report: (-4.4 / 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_MED=-2.3, RCVD_IN_MSPIKE_H2=-0.001, SPF_HELO_NONE=0.001, SPF_PASS=-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:281601 Archived-At: Lars Ingebrigtsen writes: > Philip Kaludercic writes: > >>> I think it'd be good to bring that into core, and then write a small >>> wrapper library (well, a trivial ORM) for the rest of Emacs to use, so >>> that we don't have to write SQL all over the place. That is: >>> >>> (setf (persistent-data :namespace "emoji" :key "favorites") emoji--favorites) >>> >>> I.e., what Emacs needs is a persistent key/value store, and this would >>> give us that. >>> >>> In addition, if somebody really wants to write SQL stuff (it can be very >>> handy for some things), having sqlite3 in there gives us that in >>> addition for free. >> >> What would the use-case for this be? And would this be part of the >> same interface ("persistent-data"), or would they be separate? I >> think the latter would be preferable, because then systems that might >> not have SQLite installed -- for whatever reason, despite it's wide >> availability -- could fall back on a Elisp implementation. > > I'm not quite sure what you're asking here? The use case for having > persistent data or for writing SQL? > > Nobody that uses the persistent data interface would have to write SQL. Yes, but do you want the persistent data interface to be bound to SQLite, or should a separate backed be implemented, if required? -- Philip Kaludercic