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:52:25 +0300 Message-ID: References: <877dcil2sj.fsf@ericabrahamsen.net> <87czm98qi1.fsf@gnu.org> <87o85tcwm0.fsf@ericabrahamsen.net> <874k7ljwkr.fsf@gnus.org> <87fsr5cuzq.fsf@ericabrahamsen.net> <878rwx8mdn.fsf@gnu.org> <87r1aphuei.fsf@gnus.org> <837dcex6ub.fsf@gnu.org> 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="40386"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Mutt/2.2.0 (2022-02-12) Cc: rms@gnu.org, eric@ericabrahamsen.net, cesar.mena@gmail.com, emacs-devel@gnu.org, Pip Cet , larsi@gnus.org To: Eli Zaretskii Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Mon Feb 14 14:21:03 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 1nJbHr-000ANm-34 for ged-emacs-devel@m.gmane-mx.org; Mon, 14 Feb 2022 14:21:03 +0100 Original-Received: from localhost ([::1]:35180 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nJbHp-0000ph-Pl for ged-emacs-devel@m.gmane-mx.org; Mon, 14 Feb 2022 08:21:01 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:51834) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nJasM-0001yz-BY for emacs-devel@gnu.org; Mon, 14 Feb 2022 07:54:42 -0500 Original-Received: from stw1.rcdrun.com ([217.170.207.13]:38279) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nJasJ-0006vg-4a; Mon, 14 Feb 2022 07:54:41 -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.00000000620A510B.0000718B; Mon, 14 Feb 2022 05:54:35 -0700 Mail-Followup-To: Eli Zaretskii , Pip Cet , eric@ericabrahamsen.net, larsi@gnus.org, emacs-devel@gnu.org, cesar.mena@gmail.com, rms@gnu.org Content-Disposition: inline In-Reply-To: <837dcex6ub.fsf@gnu.org> 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:286260 Archived-At: Someone said previously: > > that cannot be readily inspected, diffed, backed up, > > version-controlled, shared, altered, or understood. (Or archived, > > published, indexed, checksummed, ...) Myself I inspect almost any database backed values through Emacs, edit it, update it, delete it. Then I have implemented for my rather simple purposes a `rcd-vc' package that saves any edited database column value that I designate to be saved into the database. And I have implemented for myself `diff' feature to find differences. Not that I have much time and need for it, but from time to time I find it very handy. Thus same can be implemented for SQLite. Emacs: RCD Version Control system with PostgreSQL backend: https://hyperscope.link/3/6/7/9/6/Emacs-RCD-Version-Control-system-with-PostgreSQL-backend-36796.html Databases can be easily archived, its tables, columns, can be archived, that is what rcd-vc.el is doing within the database. Indexing and checksuming and many other features are often built-in features in the database. Access to databases opens wide range of opportunities for Emacs users. Jean Take action in Free Software Foundation campaigns: https://www.fsf.org/campaigns In support of Richard M. Stallman https://stallmansupport.org/