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.bugs Subject: bug#59346: Adding sqlite-backup Date: Sat, 19 Nov 2022 08:29:58 +0300 Message-ID: References: <837czsd7sr.fsf@gnu.org> <83h6ywbgo5.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="30016"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Mutt/2.2.7+37 (a90f69b) (2022-09-02) Cc: Eli Zaretskii , 59346@debbugs.gnu.org To: Andrew Hyatt Original-X-From: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane-mx.org@gnu.org Sat Nov 19 06:31:13 2022 Return-path: Envelope-to: geb-bug-gnu-emacs@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 1owGRc-0007dv-Li for geb-bug-gnu-emacs@m.gmane-mx.org; Sat, 19 Nov 2022 06:31:12 +0100 Original-Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1owGRU-0001fG-92; Sat, 19 Nov 2022 00:31:04 -0500 Original-Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1owGRS-0001f7-LO for bug-gnu-emacs@gnu.org; Sat, 19 Nov 2022 00:31:02 -0500 Original-Received: from debbugs.gnu.org ([209.51.188.43]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1owGRS-0007HY-DC for bug-gnu-emacs@gnu.org; Sat, 19 Nov 2022 00:31:02 -0500 Original-Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1owGRS-0003Xt-9Z for bug-gnu-emacs@gnu.org; Sat, 19 Nov 2022 00:31:02 -0500 X-Loop: help-debbugs@gnu.org Resent-From: Jean Louis Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Sat, 19 Nov 2022 05:31:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 59346 X-GNU-PR-Package: emacs Original-Received: via spool by 59346-submit@debbugs.gnu.org id=B59346.166883584513590 (code B ref 59346); Sat, 19 Nov 2022 05:31:02 +0000 Original-Received: (at 59346) by debbugs.gnu.org; 19 Nov 2022 05:30:45 +0000 Original-Received: from localhost ([127.0.0.1]:38763 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1owGRB-0003X7-2w for submit@debbugs.gnu.org; Sat, 19 Nov 2022 00:30:45 -0500 Original-Received: from stw1.rcdrun.com ([217.170.207.13]:45489) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1owGR6-0003Wu-Tc for 59346@debbugs.gnu.org; Sat, 19 Nov 2022 00:30:43 -0500 Original-Received: from localhost ([::ffff:197.239.5.174]) (AUTH: PLAIN admin, TLS: TLS1.3,256bits,ECDHE_RSA_AES_256_GCM_SHA384) by stw1.rcdrun.com with ESMTPSA id 00000000000F612E.00000000637869FE.0000118E; Fri, 18 Nov 2022 22:30:38 -0700 Content-Disposition: inline In-Reply-To: X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list X-BeenThere: bug-gnu-emacs@gnu.org List-Id: "Bug reports for GNU Emacs, the Swiss army knife of text editors" List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane-mx.org@gnu.org Original-Sender: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane-mx.org@gnu.org Xref: news.gmane.io gmane.emacs.bugs:248303 Archived-At: * Andrew Hyatt [2022-11-19 05:07]: > But if you are interested in furthering the conversation, which has a lot > to do with what I'm talking about in my upcoming (and already recorded) > Emacs conference talk, I don't think the distinction you are making between > files and databases is important. Let's say I wanted to store, use and > otherwise manipulate contact information with emacs. Right now that sort > of thing happens with a file with emacs-readable lists inside, but it's > really more natural to do it with a database. The fact that it's done via > a file now seems historical, especially now that we have sqlite. I expect > that sqlite will be used for this sort of thing more often. However, if > there's no database option, then maybe not, since it won't be seen as > reliable as the filesystem. I don't think it is reasonable to expect users > to figure out how to do this, even if the info is easy to find. I'd like > us to be able to encourage the use of sqlite for data, and give the user a > good experience when sqlite is the backend. I totally agree on that. I have already made SQLite version of CRM for Emacs by using SQLite, but it is not polished for public, it will be soon. Backing up database which does not run on the file system is trivial. That often needs human interaction. Though there are use cases when programs run continuously without human interaction and where there are too many changes to the database that one cannot just control by human. Thus program itself should be able to reliably backup the database while it is running without human supervision. There are programs like sending of mailing list, sending thousands of SMS messages, and such programs may run autonomously over days. That is how my programs are designed. They may accept the sales lead and re-check if any new person has subscribed, then dispatch e-mail and SMS to that person. Having reliable backup functions thus is necessary and useful in those cases of running programs. -- Jean Take action in Free Software Foundation campaigns: https://www.fsf.org/campaigns In support of Richard M. Stallman https://stallmansupport.org/