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 16:45:02 +0300 Message-ID: References: <83a6h9tu1c.fsf@gnu.org> <87sfuzwzk0.fsf@gnus.org> <87fsqyh17u.fsf@gnus.org> <87sfuxrvm0.fsf@gnus.org> <87tufbr6lc.fsf@gnus.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="17356"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Mutt/2.2.0 (2022-02-12) Cc: eric@ericabrahamsen.net, cesar.mena@gmail.com, emacs-devel@gnu.org, pipcet@gmail.com, Lars Ingebrigtsen , eliz@gnu.org To: Richard Stallman Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Mon Feb 14 15:40:42 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 1nJcWv-0004JD-Jp for ged-emacs-devel@m.gmane-mx.org; Mon, 14 Feb 2022 15:40:41 +0100 Original-Received: from localhost ([::1]:45684 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nJcWt-0002bh-Gz for ged-emacs-devel@m.gmane-mx.org; Mon, 14 Feb 2022 09:40:39 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:36242) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nJbep-0003PD-1a for emacs-devel@gnu.org; Mon, 14 Feb 2022 08:44:47 -0500 Original-Received: from stw1.rcdrun.com ([217.170.207.13]:44829) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nJben-00078e-8N; Mon, 14 Feb 2022 08:44:46 -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 0000000000055D52.00000000620A5CC3.0000761C; Mon, 14 Feb 2022 06:44:35 -0700 Mail-Followup-To: Richard Stallman , Lars Ingebrigtsen , eric@ericabrahamsen.net, eliz@gnu.org, cesar.mena@gmail.com, pipcet@gmail.com, emacs-devel@gnu.org 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:286271 Archived-At: * Richard Stallman [2021-12-15 08:16]: > [[[ To any NSA and FBI agents reading my email: please consider ]]] > [[[ whether defending the US Constitution against all enemies, ]]] > [[[ foreign or domestic, requires you to follow Snowden's example. ]]] > > > > It looks quite binary to me. > > > Uhm... yes? Nobody has said that it isn't. > > A real text file is more robust when things go wrong. Not so categorically speaking. Text files depend on binary foundation such as the file system and its storage. Change a byte by `poke' on file system and things may go wrong. Hard disks failures will change files as well, make them disappear or break all the data. For things not to go wrong one has to make backups and move data to different media. > A binary format that you can convert to text is not as robust as real > text. Converters are designed to handle a valid binary file. In > general, it's not clear what is the proper conversion of a corrupted > binary file. Backup of sqlite to text is easy: sqlite> .output "mybackup.sql" sqlite> .dump > Thus, in general, when the file is corrupted, you can't convert it > to text. When text file is really corrupted one cannot recover the data that was there in the text file. When it is deleted, one cannot get it (unless with undelete tools). It is very simple to invoke database backups. It was always suggestion for computer users to backup their file systems, diskettes, cassettes, to "archive" data, that was since the inception of computers. Security of data applies equally to text files and binary files. > Therefore, "text file" should be the default option for configuration > data in Emacs. People who would rather use an sqlite3 file should > select that option explicitly. I agree to that for reason of Emacs history and Emacs Lisp usage over time. I don't agre to arguments for that. Databases have been designed with integrity, safety, reliability, recoverability, fault tolerance. Generalization which represent your personal opinions, cannot dispute those well established, technical and known facts. Jean Take action in Free Software Foundation campaigns: https://www.fsf.org/campaigns In support of Richard M. Stallman https://stallmansupport.org/