From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Jean Louis Newsgroups: gmane.emacs.devel Subject: Re: sqlite3 Date: Mon, 14 Feb 2022 15:14:31 +0300 Message-ID: References: <87tufmjyai.fsf@gnus.org> <877dcil2sj.fsf@ericabrahamsen.net> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="28047"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Mutt/2.2.0 (2022-02-12) Cc: emacs-devel@gnu.org To: Eric Abrahamsen Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Mon Feb 14 13:23:39 2022 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 1nJaOI-00077v-L3 for ged-emacs-devel@m.gmane-mx.org; Mon, 14 Feb 2022 13:23:38 +0100 Original-Received: from localhost ([::1]:58356 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nJaOH-00076R-1C for ged-emacs-devel@m.gmane-mx.org; Mon, 14 Feb 2022 07:23:37 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:43270) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nJaFj-0004s3-SN for emacs-devel@gnu.org; Mon, 14 Feb 2022 07:14:47 -0500 Original-Received: from stw1.rcdrun.com ([217.170.207.13]:60373) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nJaFh-0000e2-BQ for emacs-devel@gnu.org; Mon, 14 Feb 2022 07:14:47 -0500 Original-Received: from localhost ([::ffff:41.75.189.127]) (AUTH: PLAIN admin, TLS: TLS1.3,256bits,ECDHE_RSA_AES_256_GCM_SHA384) by stw1.rcdrun.com with ESMTPSA id 0000000000055D61.00000000620A47AE.00006E6F; Mon, 14 Feb 2022 05:14:37 -0700 Mail-Followup-To: Eric Abrahamsen , emacs-devel@gnu.org Content-Disposition: inline In-Reply-To: <877dcil2sj.fsf@ericabrahamsen.net> Received-SPF: pass client-ip=217.170.207.13; envelope-from=bugs@gnu.support; helo=stw1.rcdrun.com X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001, T_SCC_BODY_TEXT_LINE=-0.01 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:286252 Archived-At: * Eric Abrahamsen [2021-12-06 08:30]: > Lars Ingebrigtsen writes: > > > I think many user experience things in Emacs would be better if Emacs > > remembered more. > > > > The bigger systems don't have this problem -- Gnus needs a large > > .newsrc.eld file, and it maintains that. > > A plea from the heart: Gnus also needs a better data store, and sqlite3 > is the answer to that need. The .newsrc.eld format is not okay. sqlite3 is local file system database. In the great motion to include the database one shall consider that database system shall become available to Emacs Lisp programmers. And in that sense, the motion shall expand into using the network databases such as PostgreSQL. Module for it already exists. I am sure that developers are fine to include it in Emacs or ELPA. I have asked them and we discussed it. Reference: emacs-libpq @ Github https://github.com/anse1/emacs-libpq Please keep the motion to include sqlite3, PostgreSQL, GDBM and other DBM-like databases, so that Emacs can be built or support such. I am working with PostgreSQL all the time. For example I store my cursors places in the database, for any single editable database entry. It will boost Emacs' capabilities. -- Jean Take action in Free Software Foundation campaigns: https://www.fsf.org/campaigns In support of Richard M. Stallman https://stallmansupport.org/