From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Po Lu Newsgroups: gmane.emacs.devel Subject: Re: sqlite3 Date: Mon, 06 Dec 2021 13:26:30 +0800 Message-ID: <87mtlenw1l.fsf@yahoo.com> References: <87tufmjyai.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="6088"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.0.60 (gnu/linux) Cc: emacs-devel@gnu.org To: Lars Ingebrigtsen Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Mon Dec 06 06:28:04 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 1mu6Xk-0001Kg-8J for ged-emacs-devel@m.gmane-mx.org; Mon, 06 Dec 2021 06:28:04 +0100 Original-Received: from localhost ([::1]:40044 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1mu6Xi-0005FT-JX for ged-emacs-devel@m.gmane-mx.org; Mon, 06 Dec 2021 00:28:02 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:38168) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mu6WS-0004X1-Js for emacs-devel@gnu.org; Mon, 06 Dec 2021 00:26:44 -0500 Original-Received: from sonic313-10.consmr.mail.ne1.yahoo.com ([66.163.185.33]:34824) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1mu6WQ-0000y2-4E for emacs-devel@gnu.org; Mon, 06 Dec 2021 00:26:44 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1638768400; bh=0WdL/KpNvpgKpx02RXA2CZ6sdK+srhYe8scYJFjNOr4=; h=From:To:Cc:Subject:References:Date:In-Reply-To:From:Subject:Reply-To; b=fUouC5o3K9zAESLUDWYuPAx95og8yLiLhj2S+f0s23bneMrldw/MH8vBK+IIPbzbHBmMHeM5UZpbtsOF8afPwjCwpsCJIu7yEykAo7eu9Xw1JuU+vqtVvRa7N9n8Q3tFMGQujZN7TeNMQ0ZfXGgVReS8EZHpREXt5BspLfZTrX78X3v3aXzNi4+anQoXCLYMRbT2PmMcJVAlYgA7UKinYz6r+wJ34TYob9y59nXuIbhr3Z0XbLf01bkmZuOZx1sHIXlj0azQOGcDhKxaEQnS0p66E3mFXkklkkg55VAWvNWTfcjjA20vbLHqcorLcXie43hAn8A2Ni+2BEyPOXXhEw== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1638768400; bh=7FkgEsVvViMMrwnYo0nza1sVpkGJqbrNhiz7/HeaZJ9=; h=X-Sonic-MF:From:To:Subject:Date:From:Subject; b=EHnyA9zqN/abjQZeOjczfAxQgacjv+hf4RHH9kgOpgNWMmnpTg1O4Q89K8ogkMWITOpQyHYgBbLIf3RPDHbTRrPJOmWB8/bRTm+32qRlfIxKA/wvPWZj0dafed4gzg3yFFKKBs5xptF3gDVQu1IjraW84al7xgZD+y+sLUvF9ui+EjsGwqxSF4GFXmhj3YeuqJEyNvzAXFy9lQJ5xgIlqVzy1AyIlqHjAQ5SoVocIui/wu1o9GDguxWbhR3ced/9OEi0/P2L0PLm9lYEZFuImVGVRhhNnEbSB4iY/k1sf1nfWQa8i22SXdzDFFOxzWeSM2PBDmhSawCSQ9G02fdBgQ== X-YMail-OSG: 2HqiUbQVM1ldOXgOBWR_4I_X_RCUX_E.__pWCpU7Af5Rum0Wrcv4Gz7G1M2yCqy HFOXpV4M8m4iswO2LkIGwpA0sGCKkt_cApvvVu9bLoxj90mJcgkP5qwRNvKAokLH_zqaNMrocuGc MITNsrFfUrTAfdAlk6nzWeWfuDn.6okbUYnNnyG0iOmR5BKEta1RyJOxsvptAcHQRGy1kVdvkF7k RE_7oFFMuT8mZyY4HzTs878_Yw7dsdFqAEujnPI0j0oQiqSV7mx_GFXhpVEj5.FCWrdXUEJJKWp2 Pp4LCTwQT0922c1K46Kgy3_.cPa4Rn1TEti9FS4eqmbCBoYOcMT..XWn8kDa.Mu6ubqMj_v2KK3y JW9gjL1foSZL.ttPViz5Epo6ckQLhMjiovSLX8uqb0d.YI9BllavMbFVYtYi_9cTdZA_0kZgzHqE o_.4bVdEGPUn4dL0EjiaRSgObIdRwSRPpb_7tgNWlSgXvWvFNog2Mq1RzQ.Le15.yF2MiG8dkWmB NzK6FGBJdAUVx3VkTOSDMFsWG46NzeMhTG4gAb2E_ud7ootzgvrBj4kdG_lrMIKh_Gg9vO8iMdGm es5Lc29iWPwBF8XZszlzR_OseBUfWud0H8y2zNWNEjY6M6g43nBX_LkQ2CjTaLfQr8mYzMHnf8eH 10aax7aAX5d_hwOm1JHPd644oHtjnA4UzTLiRTTROfQ8RHdfsGcNqjggIa.Fb6ZMZ.ldDV5VGgAP 39KtZ7tTFs7VW.d3RvZoawJFF6IVu.Ee8AX0BwygGjnBk_vmTtyFwJUtyuVyHlA2kmQ5kpJE50Fn 5Ch.ExiN.YT2ywnsSka2cQLzM19gz2J8SWiuAJ7yAV X-Sonic-MF: Original-Received: from sonic.gate.mail.ne1.yahoo.com by sonic313.consmr.mail.ne1.yahoo.com with HTTP; Mon, 6 Dec 2021 05:26:40 +0000 Original-Received: by kubenode512.mail-prod1.omega.sg3.yahoo.com (VZM Hermes SMTP Server) with ESMTPA ID cbca5bfcf1a7595a4c009ddc635efe67; Mon, 06 Dec 2021 05:26:35 +0000 (UTC) In-Reply-To: <87tufmjyai.fsf@gnus.org> (Lars Ingebrigtsen's message of "Mon, 06 Dec 2021 02:51:33 +0100") X-Mailer: WebService/1.1.19306 mail.backend.jedi.jws.acl:role.jedi.acl.token.atz.jws.hermes.yahoo Received-SPF: pass client-ip=66.163.185.33; envelope-from=luangruo@yahoo.com; helo=sonic313-10.consmr.mail.ne1.yahoo.com X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 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, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, 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:281051 Archived-At: Lars Ingebrigtsen writes: > It's the many things that fall between these two extremes that have the > problem: Where you want to store some state, but figuring it's just too > much work to figure out Yet Another Storage Format, but the data is too > messy to stash in somebody's .emacs file via Customize (like lists of > stuff). > > So there's a bunch of stuff that Emacs just forgets when you shut down, > where it perhaps shouldn't. > > 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. > > This comes with questions about how the users are supposed be able to > clear out the data, for instance, but we could have a `M-x > list-persistent-data' where the users could blow out whatever they want > to. Wouldn't recfiles be better for this purpose?