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 07:52:33 +0300 Message-ID: References: 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="28004"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Mutt/2.2.7+37 (a90f69b) (2022-09-02) Cc: 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:05:28 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 1owG2h-000768-Gz for geb-bug-gnu-emacs@m.gmane-mx.org; Sat, 19 Nov 2022 06:05:27 +0100 Original-Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1owG2R-0004Rv-JE; Sat, 19 Nov 2022 00:05:12 -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 1owG2K-0004QH-I9 for bug-gnu-emacs@gnu.org; Sat, 19 Nov 2022 00:05:05 -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 1owG2I-00007l-Nj for bug-gnu-emacs@gnu.org; Sat, 19 Nov 2022 00:05:02 -0500 Original-Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1owG2I-0002q3-HS for bug-gnu-emacs@gnu.org; Sat, 19 Nov 2022 00:05: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:05: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.166883429410882 (code B ref 59346); Sat, 19 Nov 2022 05:05:02 +0000 Original-Received: (at 59346) by debbugs.gnu.org; 19 Nov 2022 05:04:54 +0000 Original-Received: from localhost ([127.0.0.1]:38702 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1owG2A-0002pR-8J for submit@debbugs.gnu.org; Sat, 19 Nov 2022 00:04:54 -0500 Original-Received: from stw1.rcdrun.com ([217.170.207.13]:36779) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1owG26-0002pF-FW for 59346@debbugs.gnu.org; Sat, 19 Nov 2022 00:04:52 -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.00000000637863F1.00000EF5; Fri, 18 Nov 2022 22:04:49 -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:248298 Archived-At: * Andrew Hyatt [2022-11-18 05:42]: > Currently there's no great way to perform a proper backup of a sqlite > database if you use the built-in sqlite in emacs 29. If you just copy the > file, there's a chance another database user is in the middle of something, > and the database could be corrupted. > > I've included a patch that fixes this. I would the sqlite-backup function > to exist so I can use it in the ELPA triples package. How I see those functions, that shall be included in Emacs as they are standard part of SQLite. SQLite Backup API: https://www.sqlite.org/backup.html -- Jean Take action in Free Software Foundation campaigns: https://www.fsf.org/campaigns In support of Richard M. Stallman https://stallmansupport.org/