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 20:36:10 +0100 Message-ID: References: <87tufmjyai.fsf@gnus.org> <875ys1n25x.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="21567"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) Cc: Stefan Kangas , emacs-devel@gnu.org To: Lars Ingebrigtsen Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Mon Dec 06 20:37:57 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 1muJo6-0005EA-AW for ged-emacs-devel@m.gmane-mx.org; Mon, 06 Dec 2021 20:37:52 +0100 Original-Received: from localhost ([::1]:50786 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1muJo5-0004xu-7E for ged-emacs-devel@m.gmane-mx.org; Mon, 06 Dec 2021 14:37:49 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:51672) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1muJmc-0004Gz-39 for emacs-devel@gnu.org; Mon, 06 Dec 2021 14:36:18 -0500 Original-Received: from mail-oln040092074021.outbound.protection.outlook.com ([40.92.74.21]:50085 helo=EUR04-DB3-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 1muJmY-000571-HD for emacs-devel@gnu.org; Mon, 06 Dec 2021 14:36:17 -0500 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=Yrdf872lwA5PxsduEdkwMu2p5I5vrX4MQBlld/wS7kV6AYuDDqTnBXWrT6gNgEANYyGqINs/+1LX8UaBjQaqdNuheJe3t5/0+fuEbAwRmuBi+u4S9L9xmHEh+UZ0e8Ng88fv6jL/DY3s2I9n2WHTvS9hj4FEqv/0mF0Z83pqik+bQEwlcUQtarzwOHDEwHCEfDVARqzZ3NhMde20EGqjCdE1DKeChNQboy0GKcEJF1B4pJpT/fbtiBvXMfttx2uJb1v+IBwVuf2W1DM8KS1kMM77bP0VJiTXfBV7VFT3ZC36Ya/li0QBu8HJw67Le68Ok016BcmjBvT1t41CgvnljA== 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=aSvi2hQC2kqdLiIb1wHnYLxo3wv8Z2CR3gtiPd3S10s=; b=jvt6ZqNNc0j2qrSzXnWcBtqG8BNd8KlFXDQ2xGzZfmmmzNf/3x/VGrOoFxEc6emgN1slHBJpk5W7+Jebr9oVcZ9kjPi9xPhUtckDP+YulscuV4s0OKVrO1IncruLCF4wL9qx4MEYhNnbAzr4HsRP6/BScPwRdKr1YQ/2VGZfiMgdUw95PVsXsdlvtWKjrzteGOM2aSde7PiJqnWUXDbp2S8YE7qktpZZCKaeDzSNF88AluTyaYc/AMw7QTBueROcssg5ewTu63RGBnal7tyCtRCR7b4f9TWl0v674GbTurwYwZwWbxn+toZ7aowh/pE4a+HJqplF5jBly7hKcs5a9A== 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=aSvi2hQC2kqdLiIb1wHnYLxo3wv8Z2CR3gtiPd3S10s=; b=NOL6G00yPnukHwGzHOmYC5KGz+Lq8jZCCiJhwYcCRP1T0Qp2tD8KZbpYze7p9inz3fs7S17Qi2a+CrST2UDAlaroJUpmEBt4JKSZWbsSbjgP3n8hNoykoA46o6+g6bfwDopo6rKKzjSV/0gD0l+F/qWr029WqQx5CuwtvpKf/blbmlsRvpQg6hsAVO7lxrm7w20VBFMBsw34zCwkUBycoWrLtszOJTn6J/ttXW0SZP1TKn+Vw0kAsrSeQ5zFmYAgd0KlW4FCEGtlGmP3UH4M4WUqroBzuNDNqp6qnbADbsL0ZirnxDzkTNtkeb5X54CLY3bv1hIKS3BO8UQ8FzaBow== Original-Received: from AM9PR09MB4977.eurprd09.prod.outlook.com (2603:10a6:20b:304::20) by AM9PR09MB5010.eurprd09.prod.outlook.com (2603:10a6:20b:306::12) 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 19:36:12 +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.022; Mon, 6 Dec 2021 19:36:12 +0000 In-Reply-To: <875ys1n25x.fsf@gnus.org> (Lars Ingebrigtsen's message of "Mon, 06 Dec 2021 17:11:54 +0100") X-TMN: [Xf5OhGTiok221uJ6avoTVdb+66FhVRjV] X-ClientProxiedBy: GV3P280CA0009.SWEP280.PROD.OUTLOOK.COM (2603:10a6:150:b::25) To AM9PR09MB4977.eurprd09.prod.outlook.com (2603:10a6:20b:304::20) X-Microsoft-Original-Message-ID: <877dchttjp.fsf@live.com> X-MS-Exchange-MessageSentRepresentingType: 1 Original-Received: from pascal.homepc (81.232.177.30) by GV3P280CA0009.SWEP280.PROD.OUTLOOK.COM (2603:10a6:150:b::25) 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 19:36:11 +0000 X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id: 3afcdbe6-70a3-416d-562d-08d9b8efa8c2 X-MS-TrafficTypeDiagnostic: AM9PR09MB5010:EE_ X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: hu4dg1QLY9lLl8PrmGAunAI7tnyYWPhjp1EC/VvwbAcND/uFTSEA/8bOXqeyIy5cT6HU5PYRXvwMDPvBgk3bTQ5CbKrvw3ZS/E7foNhp3sT/jQ4DHOiozEouSDnIGr4bAZYh83onqy6wg2ji72rvJKhLjd3eiXMORA+ZDRoN2TMhiFKI4KyrhihR9EQB2iBj5DlAn2mW4Zyhn7Xj/JGySed67iA1yWX8u9qXjKQrR6hHht0wPphvbFdKFDkSfIunT1EQUNdNS38AJAY4mmPvsO2AhGK6ghuJUBK+EC3qN/6djWKYpjT+XrJ7rHxc/t7u8HY38PBQzjIB92axePyuFLQRNh9QhEuE0wdksKKrkxdUlMI0VGwVnRbW1qRAr1yxF0j6YRaoKdGnw3BLA8JjFzJGgLvNfZPQZrfx3dy78EKj0jTYjnxlCv+rDHUtYqdhyCHkSOooh8gGX0Eu+3/yffdTA2pI2ug/x1dl5X+RthNMezGUNFUbemENHt4/3zK2neD/Xf6PKdv1MvM7zKKKOQ8IxsfLi7ayy19qNLkIBxU4g9By85npBeZqsnMts7KYfjvwM04LRYQ5h4e0/ub6eA== X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: =?us-ascii?Q?KoAdsmy4/v+Crwv+DOgaiaM7lOFKkH5N3geRNWwQGQR3aiG0OYhilXOj6orF?= =?us-ascii?Q?uGQJUpUQ3RlWyRl6ZRzo2uJRgB81wGTeuW1A8V3VoUk8H2Va7DQ+GqPtdhAd?= =?us-ascii?Q?LdrNjFYgjdBQmEWVn00S4qr6tdYu+ZVNBuXNgAd6ojx6HySrQu1uJr26hdef?= =?us-ascii?Q?t8mSQf2WP4M9vTkKWDkRT8I++r2k08It95UI4AsNCbG00MM6i66FFvs0Qd1N?= =?us-ascii?Q?kV2PzGiSOR6fRSGhhzVrV+35FZDito9LpJsCICPA/Yo6ZByJSTiXuTfG/1nK?= =?us-ascii?Q?sAa5+i+iS0Vu098IAiiFoaYmtA9VcjNqdS4O8ML4UB7NKjQq67E3Diz51nPX?= =?us-ascii?Q?QLlts6kX13unsPkcSDbtBgG4HWFMEnxUHZEvC2SUVitsw2+r+nVy41WhZC7M?= =?us-ascii?Q?5TwdutsBCvLaPTTyYud1h+A3cuF7abw0I+pAV8bCDuZXgoAdRiteCSqB9Hla?= =?us-ascii?Q?KlsPRNAPBpeQ4JuOO65G733PWcYI7SctupSYOzRCjY5TyLuivef1DYyzXHnA?= =?us-ascii?Q?Xwe89rhmOMQpKJLW6M+oLUfUIZfDnZZT1AbsGjfxJufBiQWcL+fbfc6Pnz9Y?= =?us-ascii?Q?jeIp7lEuBsWhm7F0C1K+eC37FBEn8JnuaLIYaSXzjstgf29dth12M1ybN4Y/?= =?us-ascii?Q?3m X-OriginatorOrg: sct-15-20-4755-11-msonline-outlook-64da6.templateTenant X-MS-Exchange-CrossTenant-Network-Message-Id: 3afcdbe6-70a3-416d-562d-08d9b8efa8c2 X-MS-Exchange-CrossTenant-AuthSource: AM9PR09MB4977.eurprd09.prod.outlook.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-OriginalArrivalTime: 06 Dec 2021 19:36:12.4024 (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: AM9PR09MB5010 Received-SPF: pass client-ip=40.92.74.21; envelope-from=arthur.miller@live.com; helo=EUR04-DB3-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:281153 Archived-At: Lars Ingebrigtsen writes: > Stefan Kangas writes: > >> Another question we should perhaps make explicit: Will we use one large >> sqlite3 file for all user data, or many small ones (e.g. per package)? > > I was thinking one large file for the basic key/value storage. But > packages would be free to make their own files if they want to. Why do you need global storage? How much settings for any application have so it need to resort to sql instead of customize? I see sqlite in core as opportunity to easier work with data produced by other applications, or to create applications that read in larger sets of data to work with. But what you suggest means that now there will be two parallel systems for storing settings. Are you planing on using sqlite as a backend for customize, or to remove customize?