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:42:18 +0100 Message-ID: References: <87tufmjyai.fsf@gnus.org> <0CE6937B-62E5-4C15-8B8C-1DDC0166ACF5@mit.edu> 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="26845"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) Cc: "larsi@gnus.org" , "emacs-devel@gnu.org" , Stefan Kangas , Stefan Monnier To: Qiantan Hong Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Mon Dec 06 13:52:15 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 1muDTZ-0006dG-68 for ged-emacs-devel@m.gmane-mx.org; Mon, 06 Dec 2021 13:52:13 +0100 Original-Received: from localhost ([::1]:39618 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1muDTX-0006TZ-Pw for ged-emacs-devel@m.gmane-mx.org; Mon, 06 Dec 2021 07:52:11 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:51070) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1muDK7-0007aZ-Up for emacs-devel@gnu.org; Mon, 06 Dec 2021 07:42:27 -0500 Original-Received: from mail-oln040092064078.outbound.protection.outlook.com ([40.92.64.78]:29358 helo=EUR01-DB5-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 1muDK3-00071N-CT for emacs-devel@gnu.org; Mon, 06 Dec 2021 07:42:25 -0500 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=F2dez6EBbmPUhJ65dt062AwVEeuBKwfacaY33+JuKA1oOmuFz9fhCvja11doP3CiJ3i/oHNSx1AZWL0hLykYfFFriNo001qTbe9lNqKWJhXoyP/zuM4GZ1Fy26gN6rzv55IijEmqEtMV69dg3F4SoyCk70L58cNZZfAuwttJcMHurV324wU1o80vY0NODg2gxDtyMJL0YJteA0Duc8Lw7Yu0sN5gw6RaQr5qJ0rUV9La/BszOn+1a7dEBUIL83guil+tKvD3aY3Ihfv3rTWbFM9/jJ3cvJ31QaMt6/7Q0xSrOze4p936VIOBurITCukBE0CoT/qku2QDTO4tjshjgQ== 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=FvALTdEo9cHUFFzq6rFeRkgxX4Mqs9z3wjlW5WQjSto=; b=lMTXJa8zws+HQZ78H9JubjMr5KL+0JVqzAPP4/Wet9fAFIgab5rpPm/dPwKhyAmkGnyCcnUUE8Sd24r4UZozltP9O6Yua3aWTPFOfx1QPKrEDLLsgsc+tGZkrSDdslN7mQUtlFSxpJXYD9mNRirrK+d+AM/LGgsWaURDs1Rl158sJUh7kZpxuP0z+d3z8ZKWq0tMbWV+CIZB8wZJpSvyUWYSkIyOnig5l9gNxFYRQZp+SeFxPuzDxbcP26aLORseS6QIib9tBdmxGLnSOThVuBstSoT1SNnDW6lNHMm/y3xS0+63jPaFG93D94rgCE4t8MuScF7AlFD0lMGWgNkIhg== 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=FvALTdEo9cHUFFzq6rFeRkgxX4Mqs9z3wjlW5WQjSto=; b=LNqeMcxl3Wz3JVEN4BeaHy1MmiyuWy6MWm0HrcOXKg0lFofUgHITCbCEClU2z1It0qjY1q1QP7t1y7oS3ZrnyM3SCxnLpGH3cpHb7u2jHqTK+dDaJY+YFbrZVsFr2Pkae4Y6Dt2lh/IC8OMk3cSwtSuL7q4+BGWmVogagvW3zg3VL241THQZgumcBMYh4nggjxLXrnW7NAU5/InADa6k0fdpMHR7+Wq5CMafynb/j3ewvsPzJChy9j1i6Rub2dzauqw1Y0az1tVz8lsuYrShMt0o/M10N4IdI+zNdaZtfWlnABCt/A6hhb7EQZ5JTdLkPS5F0xaqiJYIJSkazxv+Yw== Original-Received: from AM9PR09MB4977.eurprd09.prod.outlook.com (2603:10a6:20b:304::20) by AM0PR09MB4499.eurprd09.prod.outlook.com (2603:10a6:208:17d::16) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4755.20; Mon, 6 Dec 2021 12:42:20 +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:42:20 +0000 In-Reply-To: <0CE6937B-62E5-4C15-8B8C-1DDC0166ACF5@mit.edu> (Qiantan Hong's message of "Mon, 6 Dec 2021 11:58:32 +0000") X-TMN: [aUQNrnWyfbpo0TmPPPsD4oYYWpfpC/Ey] X-ClientProxiedBy: GV3P280CA0004.SWEP280.PROD.OUTLOOK.COM (2603:10a6:150:b::18) To AM9PR09MB4977.eurprd09.prod.outlook.com (2603:10a6:20b:304::20) X-Microsoft-Original-Message-ID: <87czm9c3bp.fsf@live.com> X-MS-Exchange-MessageSentRepresentingType: 1 Original-Received: from pascal.homepc (81.232.177.30) by GV3P280CA0004.SWEP280.PROD.OUTLOOK.COM (2603:10a6:150:b::18) 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:42:20 +0000 X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id: d75f9bcc-982b-49d4-8f9b-08d9b8b5d825 X-MS-TrafficTypeDiagnostic: AM0PR09MB4499:EE_ X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: N93ooqk+kyB2EV7KOzOLYCbEQNzXvxeLA6maeOX/ZL6Sp6LNGSnZUFDCZuiYjxdO5d0kB5WyHkd5rUxISYUPinsoFh0ztl2Yq6I0qvKdhP/PgkPLIylenlnCHdSfArPjxmh5IB3eGZUJSzuxgSxHQv0aWR/DM+Ca3gCEhUZrRi0mDua0/Xb31dZYu8/yxnsdynzr2OyIixAqaV+w1lnvUrNx5n5hC6FQ2fS4CtSGw4jbtZ45xdFVysKeAQCapegO7NKrAsZWYWrUmmd65T0Cc+tcqinagbwyHNbo4G+gDRG0STRvNpL4l/6DW+BDCtNazNVuBY8onLEwfy7ZsnLFJPXEsjAyWW249MFlNa8d2+Vf8NLNv5dXpRvWqxq9ZEolE0vVaNm3oqAn2/w1qvTTzYcH2+QUVrqVvEpgnzOcKu1BtUlXvf4WUMeoMsqnMsj6kGtX9RgRNcOxEAdFjLE5XOLTmaKcbEQuooOe7x+/KXmM03+2EWbVJFuXV9XvtMdoWz7pg22bk1suzH/bRBPKDtGbnDs6B1O6xtU5JLb62Fj+yGJ+ddzHF9sW/4k+/S9DQOOSz/u9CpAx/qcaKI2V2g== X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: =?utf-8?B?aXEvb1gzcEVIOHY1YmViTDZiSmpjZW9DM2tPQkF3YTV6d1NTQkhZMHE5eEE3?= =?utf-8?B?WjdNUFFpZnpOV1A1VXkxaGx0dTRsZFB1cXVCb2FQeDlQeUordDBuQUVWZVZl?= =?utf-8?B?a2lyRjkwNnN0ak80N045TU45VjlkYjNFTzhhMUxVK3dDdGhjc1Iza3NCZCtx?= =?utf-8?B?QUhmOTRZYit2aTZ1THpiMnFyS29MWWZIWCtVQldaSGZSd3cxNTVjb3lQMlBo?= =?utf-8?B?cXJZL3JwQ1pPNlFleWQzVjZ4WVltOTJKZXZDYUlpTWMvdFhjcXhKOGpzQmtn?= =?utf-8?B?YUpMQ2xiMUFkNXNXRGdUVE5yVThjYWtpMExHS0k3RDZ0OEhuUnhsSHltSFNY?= =?utf-8?B?Yit1NFpkNksrZXFHZG5wZUFQb25YbzR1V1JpYzM0T1FTT3hwUk5TVnV0K3Jp?= =?utf-8?B?TWZCSGdNVjFPRjg2NnNJRysvVzlaUkhyUDhXVHQ4dW41Y2RJZ0FJVjB5VDVY?= =?utf-8?B?VUpSN3dMeXZNRFFWNkpTcG9iTTlBWDdHS2QwNHVWNGFER296UXJQM2F0WmpS?= =?utf-8?B?TThZN05ldU9qQlh0WkVpdkZSdi9rdlZXQ2pIWmdscjdpRGVEWnYwOWJNa1I0?= =?utf-8?B?bjg3aDRXRW9HeEhVV2JmR2FYYkkxeDNHSnRZNksybjhHbzlMUlA3bytLUjht?= =?utf-8?B?eGh2bTBtSUFqcHh5Zlk1VVBiU1h2dktsUG9qaF X-OriginatorOrg: sct-15-20-4755-11-msonline-outlook-64da6.templateTenant X-MS-Exchange-CrossTenant-Network-Message-Id: d75f9bcc-982b-49d4-8f9b-08d9b8b5d825 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:42:20.8472 (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: AM0PR09MB4499 Received-SPF: pass client-ip=40.92.64.78; envelope-from=arthur.miller@live.com; helo=EUR01-DB5-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:281089 Archived-At: Qiantan Hong writes: >>> My only remark is that sqlite is usually used for exactly same purpose = as what >>> Emacs already has: customize. Your example: >>>=20 >>>> (setf (persistent-data :namespace "emoji" :key "favorites") emoji--fav= orites) >>>=20 >>> looks to me like something one would use customize for. >>=20 >> Is this historic use of customize not just a result of the lack >> something like sqlite3? > Or it could be the other way around. The prominent use of sqlite3 > is that other environments (especially the more =E2=80=9Cstatic=E2=80=9D = ones) lack > customize, or the ability to configure the environment within itself > in general, thus relying on a central external store. You are on same thoughts as me. Other applications don't have Lisp. What ma= kes Lisp special is the homoiconicity, which makes serializing to files relativ= ely easy, in terms of not having to implement a dsl for the file format (init f= iles, csv, json, xml etc) and having to implement a query language to de-serializ= e that format into lisp objects.