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:33:19 +0300 Message-ID: References: <87o85tcwm0.fsf@ericabrahamsen.net> <874k7ljwkr.fsf@gnus.org> <87fsr5cuzq.fsf@ericabrahamsen.net> <878rwx8mdn.fsf@gnu.org> <87zgpdhw4d.fsf@yahoo.com> <2F63580E-FF58-45D0-9DBB-389ED64C0F11@mit.edu> <83v8zzw867.fsf@gnu.org> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="37588"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Mutt/2.2.0 (2022-02-12) Cc: Qiantan Hong , rms@gnu.org, eric@ericabrahamsen.net, cesar.mena@gmail.com, emacs-devel@gnu.org, luangruo@yahoo.com, Eli Zaretskii To: Alan Mackenzie Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Mon Feb 14 14:28:18 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 1nJbOs-0009Xo-PV for ged-emacs-devel@m.gmane-mx.org; Mon, 14 Feb 2022 14:28:18 +0100 Original-Received: from localhost ([::1]:43710 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nJbOp-0006xU-ME for ged-emacs-devel@m.gmane-mx.org; Mon, 14 Feb 2022 08:28:15 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:47818) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nJaZ8-0001Nq-Fu for emacs-devel@gnu.org; Mon, 14 Feb 2022 07:34:50 -0500 Original-Received: from stw1.rcdrun.com ([217.170.207.13]:36251) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nJaZ4-0003wr-7e; Mon, 14 Feb 2022 07:34:48 -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.00000000620A4C61.00006FBB; Mon, 14 Feb 2022 05:34:40 -0700 Mail-Followup-To: Alan Mackenzie , Eli Zaretskii , Qiantan Hong , rms@gnu.org, eric@ericabrahamsen.net, cesar.mena@gmail.com, emacs-devel@gnu.org, luangruo@yahoo.com Content-Disposition: inline In-Reply-To: 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:286261 Archived-At: * Alan Mackenzie [2021-12-11 00:26]: > Hello, Eli and Emacs. > > On Wed, Dec 08, 2021 at 15:14:08 +0200, Eli Zaretskii wrote: > > > From: Qiantan Hong > > > Date: Wed, 8 Dec 2021 05:41:17 +0000 > > > Cc: Po Lu , Eric Abrahamsen , > > > cesar mena , "emacs-devel@gnu.org" > > > > I’m against using sqlite3, or maybe in general any database. > > > Why would you be against adding to Emacs infrastructure that might be > > useful for some applications? > > Because it can degrade other applications. To me the inclusion of PostgreSQL module is making my life and business so much easier since its inception. Before that I was using other PostgreSQL Emacs Lisp interfaceses. Usage of such module does not degrade and did not degrade any other application that I know in Emacs. sqlite3 is lite as compared to PostgreSQL and I think it is blazing fast. Once can intersect data with speed and I doubt it would be slower than what Emacs Lisp can do. My experience with PostgreSQL tells me that information locating is so much faster than if I would use plain Emacs Lisp without the database. > Primarily Emacs is a programmers' text editor, and I would like it > to stay that way. SQLite - Wikipedia https://en.wikipedia.org/wiki/SQLite Research the subject. Browsers are for Internet browsing and they are using SQLite. File system is remember also a database, including text files with ordered data. Don't be afraid. > Adding database functionality is inessential to that prime function > (regardless of how important it might be), therefore is a burden to > that prime function. Lack of well structured database and by that I mean SQL relational databases, is and always was a burden to my programming. With databases I have increased my productivity and minimized programming efforts, thus gained speed and also much money. Without databases and connection from withing Emacs I would be lost and would be spending time. Back in time I have been using web interface on a local Apache web server, and now I am using exclusively Emacs. I can connect to remote databases and allow other people connect to my database and by using Emacs edit all the information, update, delete, query and follow up with people for sales and other purposes. > All things like gnus, org-mode are likewise inessential - they add > many megabytes to the source-code, greatly increase build time, take > up key-bindings, space in documentation (hopefully ;-) and so on. That is possible to solve, there is minimal Emacs I guess in Debian and this option: ./configure --without-all and I often use it on remote servers that way. > Similarly, I would be very unhappy if somebody transformed Emacs into a > database engine, where its prime features were unusable without the > database features being built in. I think this possibility, remote at > this juncture, should be borne in mind. Database backed variables may be think of as global variables and they could be quite comfortable for a programmer with the difference that such remain persistent in background. -- Jean Take action in Free Software Foundation campaigns: https://www.fsf.org/campaigns In support of Richard M. Stallman https://stallmansupport.org/