From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Richard Stallman Newsgroups: gmane.emacs.devel Subject: Re: sqlite3 Date: Mon, 14 Feb 2022 23:31:28 -0500 Message-ID: References: <874k7ljwkr.fsf@gnus.org> <87fsr5cuzq.fsf@ericabrahamsen.net> <878rwx8mdn.fsf@gnu.org> <87r1aphuei.fsf@gnus.org> <837dcex6ub.fsf@gnu.org> <83a6h9tu1c.fsf@gnu.org> Reply-To: rms@gnu.org Content-Type: text/plain; charset=Utf-8 Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="36685"; mail-complaints-to="usenet@ciao.gmane.io" Cc: eric@ericabrahamsen.net, cesar.mena@gmail.com, emacs-devel@gnu.org, pipcet@gmail.com, eliz@gnu.org, larsi@gnus.org To: Jean Louis Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Tue Feb 15 05:35:37 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 1nJpYu-0009Ln-OY for ged-emacs-devel@m.gmane-mx.org; Tue, 15 Feb 2022 05:35:36 +0100 Original-Received: from localhost ([::1]:41488 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nJpYt-0005bV-NS for ged-emacs-devel@m.gmane-mx.org; Mon, 14 Feb 2022 23:35:35 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:58268) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nJpUw-0008TX-5P for emacs-devel@gnu.org; Mon, 14 Feb 2022 23:31:32 -0500 Original-Received: from [2001:470:142:3::e] (port=47174 helo=fencepost.gnu.org) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nJpUv-0006jZ-ME; Mon, 14 Feb 2022 23:31:29 -0500 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnu.org; s=fencepost-gnu-org; h=Date:References:Subject:In-Reply-To:To:From: mime-version; bh=BU1vC9/gvWYJ8zhDP/G2Y4VFDqGvI9AdOq8dZphompw=; b=LzTz4bcvJsvK 3BkKoUSJ3pJLbK+9KPbfqyD0ueyBqlr86Gsh6ddhqnkoI8PDBmEjtNcpvAlIOR5bUBR2q5l964MUo /NuCHa/YkYqNLL7YJ6+0DGlBo1GDgT+kSjohTSN2d+Bl7W01TfCe+m3lMDHUwwpBgNmDyCtqIr4pu JD2VrXPSBqJ4ZLz84jHbAy/iRR+2DfUfEJTRQP8OYS5GgUO+E//9bTt+qpehCCC6GHPf9hYip9gp3 XGBL2QJBYeE4asBS2GBW90S8pALaANVJ7vXxKZ1UTg5gCXJKZMGMVRBTAlxvMTNtChIs4blLgMioA FcbNV/3h5fjJY1DrWIn2jg==; Original-Received: from rms by fencepost.gnu.org with local (Exim 4.90_1) (envelope-from ) id 1nJpUu-0005KB-Fk; Mon, 14 Feb 2022 23:31:28 -0500 In-Reply-To: (message from Jean Louis on Mon, 14 Feb 2022 16:31:23 +0300) 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:286313 Archived-At: [[[ 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. ]]] > > > > The crucial difference between text files and sqlite3 databases, > > unless I'm mistaken about the latter, is that text files are simple > > and transparent, but sqlite3 databases are not. > To see a text file on Unix-like system, one needs at least `cat' > command, or `less', `more' and similar, and better is to have text > editor. One could click on desktop system and open such file. THat is true, but I think we're not talking about the same question. I'm not talking abut the question of whether there is a command to view the format, or whether the sqlite3 files have a documented format. I am talking about the kind of format that the file contains, and the implications of that format. Decades of experiences have taught me that files with internal pointers are more likely to get badly corrupt that sequences of characters. Also, when part of a character-sequence file gets corrupt, the rest of it is usually still valid data and usable. The pointer-based file tends to become totally incomprehensible. -- Dr Richard Stallman (https://stallman.org) Chief GNUisance of the GNU Project (https://gnu.org) Founder, Free Software Foundation (https://fsf.org) Internet Hall-of-Famer (https://internethalloffame.org)