From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Thierry Volpiatto Newsgroups: gmane.emacs.devel Subject: Re: Against sqlite3!!! Date: Thu, 09 Dec 2021 19:16:57 +0000 Message-ID: <878rwt1tcm.fsf@posteo.net> References: <12908535.gTCiKFHhma@galex-713.eu> <24465971.J1OoJ6LT5i@galex-713.eu> <9B4512CF-55D3-4619-95B8-0AA30C3E7F47@mit.edu> 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="10667"; mail-complaints-to="usenet@ciao.gmane.io" Cc: Alexandre Garreau , "emacs-devel@gnu.org" To: Qiantan Hong Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Thu Dec 09 20:18:49 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 1mvOwL-0002ZR-Gh for ged-emacs-devel@m.gmane-mx.org; Thu, 09 Dec 2021 20:18:49 +0100 Original-Received: from localhost ([::1]:33036 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1mvOwK-0007bP-86 for ged-emacs-devel@m.gmane-mx.org; Thu, 09 Dec 2021 14:18:48 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:52728) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mvOui-0006NI-Dh for emacs-devel@gnu.org; Thu, 09 Dec 2021 14:17:08 -0500 Original-Received: from mout02.posteo.de ([185.67.36.66]:55169) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mvOuf-0004jZ-PM for emacs-devel@gnu.org; Thu, 09 Dec 2021 14:17:08 -0500 Original-Received: from submission (posteo.de [89.146.220.130]) by mout02.posteo.de (Postfix) with ESMTPS id E06FB24010B for ; Thu, 9 Dec 2021 20:17:01 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=posteo.net; s=2017; t=1639077421; bh=piDm7whX+q/KhSZzq3ME3/vE9aKX2XrC0Jl3Cjpal1A=; h=From:To:Cc:Subject:Autocrypt:Date:From; b=EMA7TcVZpnS2Nb5vJOmW4zGNQOLf4oZ4OVAchSqkSpSG7tpScAJk9qeY9CcUVkmj6 cFeTfSCFjqGhfCH1OIPMcWJBwn3gMi+BPPVc8/V3aI5cOYTnTEG0kdsNCHjRwK7XQq Bbxu30oXOY3taSMx5BJ1xjvBCoGuwbALlAGlPvFiZDnlgR9NqdOqLfbDSZkfiwBHHC K+Y2b0R3uESsWFEJhbZM7LlejN0hX9VZbIupr11HxAy8T8qfNpKUuqwTQcSd6EDG// Y4FGP13hOXFbjO/aJERau/dUPHj7TL1x0mn4pBVa5sZnWxGj/niwIwmHCjEKzDSfif y/RNNJP4P9t8w== Original-Received: from customer (localhost [127.0.0.1]) by submission (posteo.de) with ESMTPSA id 4J93gc0gWdz6tlh; Thu, 9 Dec 2021 20:16:59 +0100 (CET) Autocrypt: addr=thievol@posteo.net; prefer-encrypt=mutual; keydata= mQGNBF8ylcIBDADG+hy+zR6L4/vbdDDZuSaMmSrU3A5QZJpeBCvxTr7MpzzruZbhLPW1K3R6N2MA edi8Y+C8o27FVRIjpdbaKMGu9je7JV/TbUQYo3SOwCK1vM4LUn4V6ZLzSYkuiEt4eyMoiDdyvN0p kcK6P9x9DCetcEVszXzQg+yzCVrQ2hXWDXWT4M18EC3wtO7RHPouMqGiwBFhBAYErCqFWFxQHkfb tG/4yGyJ58rglb65O3qijjMWvYwcWZun9/7qm8Z4/4mHopmo2zgU+OrptnLSZfkZGz3Y7Uf452xQ GVq0Fv75NPvQru7y+DYVhuVXXyAmGxt+vf4rIiixMBbhKEPjcxEPAa2LTzex2IsTZR+QVG9uDnqC WcgaOEQ58fzXNvNhtwwF/Rgio2XWAJVdmFWS59/k9W58CIUSNKBMZh2XeGdEmtHvDtCxW3z6FJha 36RzOM3fMNNiAGdFZJA84gcdloJR+sHCDTTPT3784fjr+V8An7sI581NGFzkRQqPvEQCZbUAEQEA AbQSdGhpZXZvbEBwb3N0ZW8ubmV0iQHUBBMBCgA+FiEEI9twfRN7r3nig/xwDsVtFB0W75MFAl8y lcICGwMFCQPCZwAFCwkIBwIGFQoJCAsCBBYCAwECHgECF4AACgkQDsVtFB0W75MB3QwAlTsVzFmr +S/tMKwwwOibjhNPi/OZiUC2AYfaqfVAiIHDT3RbzDe03sAJoomJkJnYVjGzQZwibCMO2+ITkMPV 2wvrd4CbgS1KCVbrltwcuK/nxPCBaHytOCZUIInnhJo5PE/h03K In-Reply-To: <9B4512CF-55D3-4619-95B8-0AA30C3E7F47@mit.edu> (Qiantan Hong's message of "Thu, 9 Dec 2021 07:50:18 +0000") Received-SPF: pass client-ip=185.67.36.66; envelope-from=thievol@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:281530 Archived-At: Qiantan Hong writes: >> If you start dividing your file into pages and loading one page at a tim= e,=20 >> you=E2=80=99re starting to reimplement a kv-database, just as gdbm (or s= ome=20 >> filesystems). You=E2=80=99d better reuse gdbm, > There is a subtle but IMO significant benefit of resist!, it understands > more than kv-put. In the current version, it also understands > kv-push and kv-delete (aka list operations). > > I imagine this can be very useful for Lisp because lots of time people > just add or remove data from a list. Some implementation that doesn=E2=80= =99t > understand this would need to dump the whole list again. > >> and work on something higher level=20 >> and more fun like a lisp sql-like query language, inspired from (or even= =20 >> compatible with) sql or sparql or prolog, except each expression would=20 >> return a lisp value. That would be very beautiful. > That=E2=80=99s definitely a cool idea. I=E2=80=99ll probably just go for = an embedded Prolog=20 > with S-exp syntax. > > It=E2=80=99s probably not my current priority though, because > Emacs packages at the moment still use mostly LISt Processing, > and somehow people still find enough incentive to introduce SQLite3, > which I attribute to the lack of a decent pure Lisp persistent store. Emacs-lisp provide eval-when-compile which allows saving elisp objects in compiled files, I use this since years to save my variables in emacs. See psession package. --=20 Thierry