From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Qiantan Hong Newsgroups: gmane.emacs.devel Subject: Re: sqlite3 Date: Mon, 6 Dec 2021 12:42:13 +0000 Message-ID: <16FC4A4D-8846-45B0-9DC3-1B6301CCA08C@mit.edu> References: <87tufmjyai.fsf@gnus.org> <875ys2lyt0.fsf@yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="38080"; mail-complaints-to="usenet@ciao.gmane.io" Cc: Po Lu , "larsi@gnus.org" , "emacs-devel@gnu.org" To: Arthur Miller Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Mon Dec 06 13:46:23 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 1muDNv-0009h2-ND for ged-emacs-devel@m.gmane-mx.org; Mon, 06 Dec 2021 13:46:23 +0100 Original-Received: from localhost ([::1]:60310 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1muDNt-000104-2s for ged-emacs-devel@m.gmane-mx.org; Mon, 06 Dec 2021 07:46:21 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:51216) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1muDKN-0007k5-B4 for emacs-devel@gnu.org; Mon, 06 Dec 2021 07:42:46 -0500 Original-Received: from outgoing-exchange-7.mit.edu ([18.9.28.58]:59579) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1muDKL-0008BA-9V for emacs-devel@gnu.org; Mon, 06 Dec 2021 07:42:42 -0500 Original-Received: from w92exedge3.exchange.mit.edu (W92EXEDGE3.EXCHANGE.MIT.EDU [18.7.73.15]) by outgoing-exchange-7.mit.edu (8.14.7/8.12.4) with ESMTP id 1B6CgaeU005124; Mon, 6 Dec 2021 07:42:39 -0500 Original-Received: from w92expo16.exchange.mit.edu (18.7.74.70) by w92exedge3.exchange.mit.edu (18.7.73.15) with Microsoft SMTP Server (TLS) id 15.0.1497.26; Mon, 6 Dec 2021 07:41:30 -0500 Original-Received: from oc11expo16.exchange.mit.edu (18.9.4.47) by w92expo16.exchange.mit.edu (18.7.74.70) with Microsoft SMTP Server (TLS) id 15.0.1497.23; Mon, 6 Dec 2021 07:42:14 -0500 Original-Received: from oc11expo16.exchange.mit.edu ([18.9.4.47]) by oc11expo16.exchange.mit.edu ([18.9.4.47]) with mapi id 15.00.1497.023; Mon, 6 Dec 2021 07:42:14 -0500 Thread-Topic: sqlite3 Thread-Index: AQHX6kP05Uksy0m/5EaKKPl4hlIxS6wlvKyA In-Reply-To: Accept-Language: en-US Content-Language: en-US x-ms-exchange-messagesentrepresentingtype: 1 x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [128.12.11.144] Content-ID: Received-SPF: pass client-ip=18.9.28.58; envelope-from=qhong@mit.edu; helo=outgoing-exchange-7.mit.edu X-Spam_score_int: -41 X-Spam_score: -4.2 X-Spam_bar: ---- X-Spam_report: (-4.2 / 5.0 requ) BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3, RCVD_IN_MSPIKE_H2=-0.001, 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:281088 Archived-At: > I suggested hashmap serialzied to/from file. I used such approach myself = for > key-value pairs. It worked fine for me, it was quite simple to read/write > it. Currently I am testing a thing, and I use just assoc list to read/wri= te it > to a file, and it works fine for me too. Did you do it in one-batch, or do you do it incrementally (aka only write t= he delta?). AFAIK the former is currently basically the standard practice (printing/reading an alist or sth similar), and it can get too slow if=20 the key value map gets large. Best, Qiantan