From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Arthur Miller Newsgroups: gmane.emacs.devel Subject: Re: sqlite3 Date: Mon, 06 Dec 2021 13:36:08 +0100 Message-ID: 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="11336"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) Cc: Lars Ingebrigtsen , emacs-devel@gnu.org To: Po Lu Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Mon Dec 06 13:40:54 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 1muDIa-0002kE-Mv for ged-emacs-devel@m.gmane-mx.org; Mon, 06 Dec 2021 13:40:54 +0100 Original-Received: from localhost ([::1]:55678 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1muDIY-0005u9-40 for ged-emacs-devel@m.gmane-mx.org; Mon, 06 Dec 2021 07:40:50 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:49440) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1muDE7-0002pw-VL for emacs-devel@gnu.org; Mon, 06 Dec 2021 07:36:16 -0500 Original-Received: from mail-db8eur05olkn2036.outbound.protection.outlook.com ([40.92.89.36]:36643 helo=EUR05-DB8-obe.outbound.protection.outlook.com) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1muDE5-0003pm-JC for emacs-devel@gnu.org; Mon, 06 Dec 2021 07:36:15 -0500 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=ke+JU2LaLGlFZNkm4QZvwm7LuSpk/UeNfgzitbgutjRb+hkQpYZ0i2K/OntQkjCa+rARHNzMf/yBDeS/FkBvLzfgWzdr9jMfaAJh5vpJ/ewg7ZYuLcn7hLx1YZNcZD3WCjhLVAAmoP2xK2Nx3zeoxj4ChhDw05WISLcERptxSleL0GWfV26SgQ+bRaVQmRWR5kArvEAPgK/A7lG2G4d9hK30rZHdJuVtSNXYOPQl+/2j2qnz8cQ+VkkeK02O6RP2yScyzwSDv/kof6mBgnOiu4Z/Y/43pVrWaAY7z2vLkmj4nDnpVss/e+FDPOYgqlJb+yMzZHgq+LEGqj8FSiL2IA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=eE3W893ayYX5vdhnLDz9l2fVdZGWqUcs6Kcwcn098gQ=; b=I2q4YZTNp/Rg7yqgAxbM+GW2CzZU5dxH10kbP24zHYzS6/v9L/G2iof+BQqmgJW+WEdFiNl9Bfcs9LGKh1U6VBnd5gbnMczo1evBv7mdgG+Oxj6wYSPzBAha/kSZnyWW0CP5boEOLpKBWCBbd2dR01NgTDWHks/m0hXqKY71hgJqzn+0WB2r2zzAuvj8Vtas4j+s7ZUEuuP+BePr7/2PzTBTm3vGNKFqcYNCsJigmWcLL8z7fCgdWm3XeXi8qUIfwK0Ar0kpFYDfgtLkPM7BTRcVYS5RK6QU5zq0KAK47UncljGrGG5Gi+1B1hdd/IP1B7APgkQD+3qUwy46SIJJwg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=live.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=eE3W893ayYX5vdhnLDz9l2fVdZGWqUcs6Kcwcn098gQ=; b=aZmb6W2Cp5v3WQIAI+tBRZ9SjhZh7fYIQ82sH7lk0Pjie4N3o+Rf1RycfTnQt9j/kvxqEHUCBAArzy5E4Q7Hj/jOb+UJYtgORCAEyKHm4A2DNMD55EmM4YCloCmJb80hZs5rrkeP/b36ixUyFawZEUAH9bzDy2KNaID6ahjndNSc0XPrecIgQHRDj+uheWocIpqQrO+oEaT1W02J3j9iltBMe5A7tabVq/28Tet/4t9aUz9iK8BQBuqeucC4zqlNDkRnAty3vBb1+9lEqDCSRYEny57Nc1hoe04z8KhRkiqfKKd7xANATnGm6ZW8ExYSB6Muqlg3ka3I6KxetZYPhQ== Original-Received: from AM9PR09MB4977.eurprd09.prod.outlook.com (2603:10a6:20b:304::20) by AM0PR09MB4291.eurprd09.prod.outlook.com (2603:10a6:20b:168::15) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4755.11; Mon, 6 Dec 2021 12:36:09 +0000 Original-Received: from AM9PR09MB4977.eurprd09.prod.outlook.com ([fe80::b012:5fd9:9447:d64a]) by AM9PR09MB4977.eurprd09.prod.outlook.com ([fe80::b012:5fd9:9447:d64a%4]) with mapi id 15.20.4755.021; Mon, 6 Dec 2021 12:36:10 +0000 In-Reply-To: <875ys2lyt0.fsf@yahoo.com> (Po Lu's message of "Mon, 06 Dec 2021 20:09:47 +0800") X-TMN: [1ALqohs9Qq3LfBQ/T1bTEjv9WQDubns+] X-ClientProxiedBy: GV3P280CA0067.SWEP280.PROD.OUTLOOK.COM (2603:10a6:150:a::32) To AM9PR09MB4977.eurprd09.prod.outlook.com (2603:10a6:20b:304::20) X-Microsoft-Original-Message-ID: <87h7blc3lz.fsf@live.com> X-MS-Exchange-MessageSentRepresentingType: 1 Original-Received: from pascal.homepc (81.232.177.30) by GV3P280CA0067.SWEP280.PROD.OUTLOOK.COM (2603:10a6:150:a::32) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4755.11 via Frontend Transport; Mon, 6 Dec 2021 12:36:09 +0000 X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id: b7641af6-9e0d-469d-7ce6-08d9b8b4fb2e X-MS-TrafficTypeDiagnostic: AM0PR09MB4291:EE_ X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: kZK35KXagB3tGIJzkt0Q4EXRyGzsAQT0q7nWfwuAGgjkTkPXHggDdsoW8lEVIF/RydTrLzczmrafCFHD49CWA3i4RK5mXK2gHlIdORydFF3EwjqwSl+BcsshLadtCc7azEZLGvJ8v0jBmDUe+2KP6ebMtgMEY+0BPKStf246Y31ZLm/0QTpM64SIGell1iHBSpx5FoUEUxE1OuFSjp8S+YSQZP+soibfIGiQETf1jD0N3tlR1KXRIJNlZAGlPzkyqfUTTxKfCfPMkbkkQEhQXYm/P9clxN5D48ehQcGJlUCDoO1FLSpcLMCM6eJpD7hgtyjLsG9yMDVfdZd8nMAIdOXEaf/Fl1Uu9CdIaTyqWUbYJcMDWzOO3dNRuE0+tMP8STlqAuLUMGva2ZS0S5Tgw7YOPtO2/P3ToOuW4qbpK04O002a2+N03M/1ht3/GuCcgBn/Y6RBxEQVoSHc0HfFfjM7Sbn6ku0TchFCZvWBO30JCJdHWnXU+EdtDnsipBWzkCoI+MbElRsaRD/bKD/QTjdHc3KPrWyLvS6WqlCGzTJQjFGFqbizcDCkKZ/0alo2obI4vCnidQyx9B4eyvFuyw== X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: =?utf-8?B?R2l2QldDYy9JR1locy9UWnVTWWRycEk0bWR1L0gxemVVS05aZENrakVQZDli?= =?utf-8?B?bU1YeGkzWEY3TDFSZVJ2RXpvdEJybFhya3RvNVR3d3hNTkJqT0R2dGhyT0Vz?= =?utf-8?B?ck9qMXk3UlRpNDJpQUpYUi9nYTFVZjZEckdZWFhOQmRlOTlQYUVaOGlld2Fo?= =?utf-8?B?SVRxSmhSYytEMndsZHNyUi9uNlAxVjhzeHVoQmsyaHVNaStIQWhRK3dRVWpR?= =?utf-8?B?cHBDQlYrYnphbzRxL3BhaHhPSlh5cDI1UmExS1loTXdiNHppRkpWaitWN3dj?= =?utf-8?B?Q2N5Ri84NUlTRXFobG0wVksrYVFkcGxGMUQ2elhoYXB0dE1JTC9yQ21ZZzVJ?= =?utf-8?B?MXVwcFE4RDdMWlhBREVhWGpIL25pVHdRU2plNFFLZ1pUYTFoYWtXWDFGNVRp?= =?utf-8?B?N3V6Vm16STdTWSt2dUpBK3VJaTI4QzQ5TS90L1Z2OGJuY2grOVRoZG1CcVVt?= =?utf-8?B?S0hSeFNXYWFNNEIrcUc0YWFnRUNMNTlkajg4WGdncmhSb0RhVHphRjBSM0hI?= =?utf-8?B?N0MxcWZjTVFKbzZHWm80V0FYenFUK0JsTk9oUTQxLy9hc1NYUzllRmRBZDBr?= =?utf-8?B?U2dhNlZoVjhFRk8ydDYwaW85N2VHSmN2WDBSS01RYzQ4RzFuRjdUdUYwMVpM?= =?utf-8?B?Y2V4R0NtZERTcjVlK09lYzhNU1JPbHBmY3B5Nk X-OriginatorOrg: sct-15-20-4755-11-msonline-outlook-64da6.templateTenant X-MS-Exchange-CrossTenant-Network-Message-Id: b7641af6-9e0d-469d-7ce6-08d9b8b4fb2e X-MS-Exchange-CrossTenant-AuthSource: AM9PR09MB4977.eurprd09.prod.outlook.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-OriginalArrivalTime: 06 Dec 2021 12:36:10.3636 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-CrossTenant-Id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: AM0PR09MB4291 Received-SPF: pass client-ip=40.92.89.36; envelope-from=arthur.miller@live.com; helo=EUR05-DB8-obe.outbound.protection.outlook.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, MSGID_FROM_MTA_HEADER=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_HELO_PASS=-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:281086 Archived-At: Po Lu writes: > Arthur Miller writes: > >> I would definitely like to see sqlite in core and avialable by >> default. I really love it and think it is a great as >> application/desktop database. I think it would open for some nice >> applications people could write. > > Regardless of whether or not this feature is implemented, I think it > should be optional, and fallbacks should be in place for systems where > SQLite is unavailable. Yes of course; I agree with you. compile-time option --with-sqlite ... > For example, I tried compiling the latest SQLite amalgamation release > with DJGPP, and it did not work. Apparently patches existed to make it > work, but they do not apply to the latest release anymore. > > Customize gaining a hard dependency on SQLite3 would be a disaster! > > Using a relational database for things like > > (setf (persistent-data :namespace "emoji" :key "favorites") > emoji--favorites) > > Is also overkill, IMO, while something like (g)dbm would be a perfect > match for this kind of task. I suggested hashmap serialzied to/from file. I used such approach myself fo= r 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 also think that everyone is uses sqlite for persisting user settings beca= use they don't have lisp and customize :). 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 settin= gs. I am thinking of desktop applications a l=C3=A1 Access/Excel and similar. Sql= ite is great for applications that need data to be portable/movable with applicati= on, or where database system like MySQL/Postgre etc are too much. I don't see i= t as just a "setting database" a l=C3=A1 Firefox.