From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Lars Ingebrigtsen Newsgroups: gmane.emacs.devel Subject: Re: sqlite3 Date: Fri, 10 Dec 2021 01:25:51 +0100 Message-ID: <87fsr12tm8.fsf@gnus.org> References: <87tufmjyai.fsf@gnus.org> <87tufhel3z.fsf@posteo.net> Mime-Version: 1.0 Content-Type: text/plain Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="29152"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) Cc: emacs-devel@gnu.org To: Philip Kaludercic Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Fri Dec 10 01:26:40 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 1mvTkG-0007Pd-Ph for ged-emacs-devel@m.gmane-mx.org; Fri, 10 Dec 2021 01:26:40 +0100 Original-Received: from localhost ([::1]:48894 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1mvTkF-0002nD-C1 for ged-emacs-devel@m.gmane-mx.org; Thu, 09 Dec 2021 19:26:39 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:37172) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mvTjc-00027A-AL for emacs-devel@gnu.org; Thu, 09 Dec 2021 19:26:00 -0500 Original-Received: from [2a01:4f9:2b:f0f::2] (port=39302 helo=quimby.gnus.org) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mvTja-0004E5-NZ for emacs-devel@gnu.org; Thu, 09 Dec 2021 19:26:00 -0500 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnus.org; s=20200322; h=Content-Type:MIME-Version:Message-ID:In-Reply-To:Date: References:Subject:Cc:To:From:Sender:Reply-To:Content-Transfer-Encoding: Content-ID:Content-Description:Resent-Date:Resent-From:Resent-Sender: Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=dZsS3BfkfK5trXdfIZ/0FuUttzIiSuNYsRxxssfbZm4=; b=OKZWNHs4VKrbugpc1r6vRg+C3j 5W6gZx7spExqjzJ+FAsvbG+I1+0V1pRSUpUnRQSmHb7JoOxzDO4lwstmdvF038K2mhKCSyfjb4lyS T4/568kZhw4BlOXtgS4xGCDIvccmNebPNxQ1RzD0SR1t6To6/IypQrZZxaGNcnGQGDb8=; Original-Received: from [84.212.220.105] (helo=xo) by quimby.gnus.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mvTjT-0006Qx-S1; Fri, 10 Dec 2021 01:25:54 +0100 Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwBAMAAAClLOS0AAAABGdBTUEAALGPC/xhBQAAACBj SFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAAElBMVEWZb3hlVl+/qKtM MzwkFhn///8fEXZMAAAAAWJLR0QF+G/pxwAAAAd0SU1FB+UMCgAPBKDl9SIAAAGuSURBVDjLrZNr kuMgDIQFzgHAcABZcwF7xAHioPufaVt+TZLZ/NiqVVXi4I9u9CBEiJDfIwnlv8ZnQB9A/n8ghRMU Xfz7NzDrWYHzsq/jAUpXAMQpOUFTtUX3eAFmzdYD7Ganwsw0/wYwsl7nopqmw+wArjBFziIDNMuT ogOoAy5a+gl869AbcosuaesFZhGpXWfCMyDzC3zjxa37fjxRa3AQxgHWwrUvlCmGpiNkhCkKuxPF MrMStU0IACwZnyhfD8k0oAczxwO4WCSNQqGarcJUNqvB/HC4ETIygxM80Uip9mAkylm4devYMnVC cWrtQRTlhhzqUtatJsqKwuwuLPE2EpUYvchqAMiv2SgcCzEl8SLZHBisXBINCn9LVHvZASLV2b7j 4Af7zVDS7bUH8lFLUUr11RPYYuWhhR1s63bJJm15A836UhJdhMr+E81Eh4TqCcbp2NDu3iPM8wD3 Q0vb1Igj22uQd4aZ4vQOfHgSpiM7v0VPgGlIGB1ull1VUfJBoKkbeLbSu58ReHg/A32VIH54by+g dcwT1+LrXdFswX8m/JR+WX2Ifwd/ABSkr20AjVmfAAAAJXRFWHRkYXRlOmNyZWF0ZQAyMDIxLTEy LTEwVDAwOjE1OjA0KzAwOjAwXinEUQAAACV0RVh0ZGF0ZTptb2RpZnkAMjAyMS0xMi0xMFQwMDox NTowNCswMDowMC90fO0AAAAASUVORK5CYII= X-Now-Playing: New Order's _Power, Corruption & Lies_: "586" In-Reply-To: <87tufhel3z.fsf@posteo.net> (Philip Kaludercic's message of "Thu, 09 Dec 2021 17:36:32 +0000") X-Host-Lookup-Failed: Reverse DNS lookup failed for 2a01:4f9:2b:f0f::2 (failed) Received-SPF: pass client-ip=2a01:4f9:2b:f0f::2; envelope-from=larsi@gnus.org; helo=quimby.gnus.org X-Spam_score_int: -35 X-Spam_score: -3.6 X-Spam_bar: --- X-Spam_report: (-3.6 / 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, RDNS_NONE=0.793, 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:281558 Archived-At: 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. -- (domestic pets only, the antidote for overdose, milk.) bloggy blog: http://lars.ingebrigtsen.no