From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Lars Ingebrigtsen Newsgroups: gmane.emacs.devel Subject: Re: sqlite3 Date: Sun, 12 Dec 2021 05:54:45 +0100 Message-ID: <87fsqyh17u.fsf@gnus.org> References: <87tufmjyai.fsf@gnus.org> <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> <83a6h9tu1c.fsf@gnu.org> <87sfuzwzk0.fsf@gnus.org> Mime-Version: 1.0 Content-Type: text/plain Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="15992"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) Cc: eric@ericabrahamsen.net, eliz@gnu.org, cesar.mena@gmail.com, pipcet@gmail.com, emacs-devel@gnu.org To: Richard Stallman Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Sun Dec 12 05:55:53 2021 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 1mwGtt-0003tv-FT for ged-emacs-devel@m.gmane-mx.org; Sun, 12 Dec 2021 05:55:53 +0100 Original-Received: from localhost ([::1]:46306 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1mwGts-0000Mx-68 for ged-emacs-devel@m.gmane-mx.org; Sat, 11 Dec 2021 23:55:52 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:38194) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mwGsy-00080K-8S for emacs-devel@gnu.org; Sat, 11 Dec 2021 23:54:57 -0500 Original-Received: from [2a01:4f9:2b:f0f::2] (port=34246 helo=quimby.gnus.org) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mwGsw-0000QJ-Pq; Sat, 11 Dec 2021 23:54:55 -0500 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnus.org; s=20200322; h=Content-Type:MIME-Version:Message-ID:In-Reply-To:Date: References:Subject:Cc:To:From:Sender:Reply-To:Content-Transfer-Encoding: Content-ID:Content-Description:Resent-Date:Resent-From:Resent-Sender: Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=Q+LZqF99JjtyBmLQMAn8dn40gv4Jcp6Fr6GEJtlzq2M=; b=TAfD725LTMhIhigDBPXXHTJOSL Y0K4QpvO9MGHW0H+t6yZpSEmU+OlqxEqx3/Uaj17DWLRsQHQE7vlUWo7ycbQAAqmPHfyYflsgUnNi d1hOGG4nwHpyHS9lH4csWKSnZ1KdH4Xjg0fsmbHcvaiXJKpFwh08hQY80JVgFyLRrllI=; Original-Received: from [84.212.220.105] (helo=xo) by quimby.gnus.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mwGsp-0001rb-Cy; Sun, 12 Dec 2021 05:54:50 +0100 Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwBAMAAAClLOS0AAAABGdBTUEAALGPC/xhBQAAACBj SFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAAD1BMVEXu3QKgkgFcVAGF egH///9tNUTkAAAAAWJLR0QEj2jZUQAAAAd0SU1FB+UMDAQqHHkYSpMAAAGjSURBVDjLrZTblSMx CEQlO4FGJLCIBCzIP7ep0qPds9+jY//omgIK5FL+8DTJ6N/zr4xSPxOk5wPYazSLBe4zQcXHFhjz VhYDkLBKoCKKex7NsEuijxkx5D4T9O4T6ONeFComV3mAFceIhgpWHzzNVkyzGpkPqWREOAtyWVoL BCKiz8iM7PWWYrl9gqu80w4IBnQCtcout4moSYXlE8gIWV5B26dQzghI+ZFKyvRhLSnVfUnRKsW9 qri40nZpB2AEJpH46lSpu3MEoKxAf5L2puwGGC2bjm4EbHUlZ4YY0thI2oVxfXZVyBypnOyAu2dL lFIRKYMAbvRxm9g6fi9GF3POw49XQwjofNL2s3BwpIdMoASxIxBKdiIu7T5zNPwgPeKWgpt74YKb 8MixZ96SbsHAIwUfbpDqN6h21QW8DW0Abjp318NXDnSMCNhIkPa6pKyqBk1yzm31ccxqbLs7LeYO rXlsSwYfmzoeygDA/N5ndyGtGBNSixUvbc5XZXyfAaRe2Mb2/8MhKP1T1179AvmdYMvfEVN5Apj7 APgD2ODPzg8tvl9S/uy48AAAACV0RVh0ZGF0ZTpjcmVhdGUAMjAyMS0xMi0xMlQwNDo0MjoyOCsw MDowMA8+UZYAAAAldEVYdGRhdGU6bW9kaWZ5ADIwMjEtMTItMTJUMDQ6NDI6MjgrMDA6MDB+Y+kq AAAAAElFTkSuQmCC X-Now-Playing: Snapped Ankles's _Come Play The Trees_: "Come Play The Trees" In-Reply-To: (Richard Stallman's message of "Sat, 11 Dec 2021 22:59:48 -0500") X-Host-Lookup-Failed: Reverse DNS lookup failed for 2a01:4f9:2b:f0f::2 (failed) Received-SPF: pass client-ip=2a01:4f9:2b:f0f::2; envelope-from=larsi@gnus.org; helo=quimby.gnus.org X-Spam_score_int: -35 X-Spam_score: -3.6 X-Spam_bar: --- X-Spam_report: (-3.6 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, RCVD_IN_DNSWL_MED=-2.3, RDNS_NONE=0.793, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 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:281744 Archived-At: Richard Stallman writes: > > I think you're mistaken. sqlite3 databases are pretty transparent. > > Would you please email me an sqlite3 database file, as an attachment? You probably have several of them on your computer -- it's pretty hard to not, these days. "find / -name '*.sqlite" will give you a list. > > There's trivial tools that dump the contents as a series of "insert" > > statements, that are about as easy to read as Emacs Lisp. > > I'm sure that is helpful, but there is a big difference between > conversion to and from text, and actually being textual. There's certainly a difference, but I'm not sure it's that big. A dump of an Emacs Lisp hash table is certainly "textual", but I'm pretty sure most users won't be able to read/alter it with confidence. To view the contents of the sqlite file, you can use `M-x sqlite-mode-open-file' on the current Emacs trunk, or you can say echo -e '.dump' | sqlite3 file.sqlite -- (domestic pets only, the antidote for overdose, milk.) bloggy blog: http://lars.ingebrigtsen.no