From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Po Lu Newsgroups: gmane.emacs.devel Subject: Re: sqlite3 Date: Mon, 06 Dec 2021 20:42:02 +0800 Message-ID: <87wnkhlxb9.fsf@yahoo.com> References: <87tufmjyai.fsf@gnus.org> <875ys2lyt0.fsf@yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="36098"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.0.60 (gnu/linux) Cc: Lars Ingebrigtsen , 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:02 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 1muDNa-0009Ci-1X for ged-emacs-devel@m.gmane-mx.org; Mon, 06 Dec 2021 13:46:02 +0100 Original-Received: from localhost ([::1]:59954 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1muDNY-0000cN-JN for ged-emacs-devel@m.gmane-mx.org; Mon, 06 Dec 2021 07:46:00 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:50984) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1muDJv-0007Un-Jb for emacs-devel@gnu.org; Mon, 06 Dec 2021 07:42:15 -0500 Original-Received: from sonic315-20.consmr.mail.ne1.yahoo.com ([66.163.190.146]:45211) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1muDJu-0006bb-2S for emacs-devel@gnu.org; Mon, 06 Dec 2021 07:42:15 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1638794531; bh=XPJ6p+PIhhZSv/U5O3uYGqE5o2VxQmAxT5r00Tw6Izs=; h=From:To:Cc:Subject:References:Date:In-Reply-To:From:Subject:Reply-To; b=ZCUyrRJh1tUotBKP08xAN9yMBSIwrBXKn+5ULx/rON6TCEiVP+9TZrAc5Y78YQbsK+oGcfPbxUK9Ji7Sd8JPZUIb0aR0z9F8sZd4a2LoTUMyolhyk91Zdf6RDk2cDJNfN7/B3paJcMQd4j2aOm79J4wPePXLpiLITa0NII5rimryRJ348ANlyJb5MrCTLebsm86vh/Tay254SGbiBK+j5+bLb9MtlHGLv+snFipUGSfnc4WHvKQQb5+XamSN1BAe9/Ok/rPIzjI+sIfHeLirh9/9/0oOP+e2ixRsoNC3pqnepitjoTKU2vFyvWcqTc+kuIKkwNtNuLMHOo6zwpQF6Q== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1638794531; bh=xt7dy0I98wj75JUQF5Fhi2nVbS3Kpd5zU1n3ubr+Nmt=; h=X-Sonic-MF:From:To:Subject:Date:From:Subject; b=eLfJX57y1gXopZhtVKAclQq0AehffOwS43oORWA6C1+ZkwtgLVzOwdalWXBJl26+EvVyDdGokd1uIkEa1yyxRr65OolXPE1ex05sfbBz3/MkhEaliOmSYsN86xnjyX7KDeQjQ3utFCBi58s+UE88BoNS1+RHCIMk3G/46xxTmJbgm8xDy2ASWdQpshO6hhNqX6byVY8+bQ9HWx9qu2UmYO0pGzCaK41GVJSj9Q+gwL/Nig6XqyAdbsLhjrV5JS2gktrrzGNdK6kENjP3RPC2xlEy7I6yn8pa2s9qvXrtGxotxD6J68rv73fFN0dtEN3oo5SqYj/JLzGQkUxAveNg5Q== X-YMail-OSG: KMEelEQVM1n.imxXvl3_xqiFAMA478_JxTjdPxZ_LFRM4d_yx4mub4t8mXrjOSn dWDJdFYSqSzYmz5Z79s50.OyzqCrjga1b6N2evYRqojVFLpRvBM.gn5On.OaRyLrjTGd2KhVOhQ7 Htk9g_FDLN60Nc6ObQpPhxfeNINSk1R6EhmIxnj6gbKVv3E.M_n4ZYJhd_HRJcDyYYKqN25A28DR MxzSgiephNiTuw7gGCTj8aVEMhzWlPUtTrOCOsYQAx_9IUYkLrbiZapoTWVF1dGDm7ZLbuKBeATD ljx3U8b1v3yxgGnWf9xBkfVlKxyYdZ3ONtuGyiGAB8OyXPOvvjAcnspE8upkg6JuUe9m6ET_KyLb gAM7f1aZhyymhU1vMNMwBQIcmA7FK.cCEPZ5MnqWo4kYCPcX9JlAvkwZhnYHj6g7z.vJHUVLCaKS 979NHrTbcCkwjyc49syUii1TMzgEZ6cqvZnxrwK5smLCs3uepkJqmYTvHb2rAUdMUoXefZFAGN_A is.nFD_iLOIBKPdcj1uc9rM9crJjO2j0.zv8rk7y1sYcHBoaQ9nM46giPtZ28gvFksXMrhfMEyqU Ra558ZV8V2BALaqpB6oNFgKtnkpN1VRweVAlxLYwUkieUOZBcDMh7kxsr3HHjSlj4vvAVsOE6uhm T.wBsneIbUwYQXUJXExc_nrBnaF8BcOJ5wRQPZRacurNxbp_EjptkNRG2om.0wOYKzc4JU7dkm4C Cw_Jun7usQ0AZXjokdpZbD8ijR1.SELVAip.9pkTOGLxgUcZkNla99wWPXVUPgJQ4nsfi5rqoug9 fct550Gn54P4OTz43DUrzAym.LUQ365BszwMj0Q4dF X-Sonic-MF: Original-Received: from sonic.gate.mail.ne1.yahoo.com by sonic315.consmr.mail.ne1.yahoo.com with HTTP; Mon, 6 Dec 2021 12:42:11 +0000 Original-Received: by kubenode518.mail-prod1.omega.sg3.yahoo.com (VZM Hermes SMTP Server) with ESMTPA ID 2c3fccbd6542535c6607d394458378ba; Mon, 06 Dec 2021 12:42:07 +0000 (UTC) In-Reply-To: (Arthur Miller's message of "Mon, 06 Dec 2021 13:36:08 +0100") X-Mailer: WebService/1.1.19415 mail.backend.jedi.jws.acl:role.jedi.acl.token.atz.jws.hermes.yahoo Received-SPF: pass client-ip=66.163.190.146; envelope-from=luangruo@yahoo.com; helo=sonic315-20.consmr.mail.ne1.yahoo.com X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 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, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, 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:281087 Archived-At: Arthur Miller writes: > 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/write it to a file, and it works fine for me too. I think the ideal choice would either be dbm (and the GNU variant, gdbm, which improves upon it in every area) or recutils. Which still raises the other important question of how to serialize data, and how to do it better than `read' and `print'. > Just because everyone uses sqlite is maybe not the best argument, but > anyway, sqlite is maybe faster when serializing that reading/writing > lisp objects. I don't know, I am not familiar so much with elisp vs > sqlite. Also, there are many uses for relational databse than just > persisting user settings. I am thinking of desktop applications a l=C3=A1 > Access/Excel and similar. What is special about the settings of MS Access or MS Excel that warrant a relational database for storing them?