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:45:28 +0100 Message-ID: References: <87tufmjyai.fsf@gnus.org> <875ys2lyt0.fsf@yahoo.com> <897C2ADC-9F9D-4D3E-B427-773EC7CE561C@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="8260"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) Cc: Po Lu , "larsi@gnus.org" , Stefan Monnier , "emacs-devel@gnu.org" To: Qiantan Hong Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Mon Dec 06 20:50:17 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 1muK07-0001u2-2m for ged-emacs-devel@m.gmane-mx.org; Mon, 06 Dec 2021 20:50:16 +0100 Original-Received: from localhost ([::1]:44534 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1muK06-0002rF-2V for ged-emacs-devel@m.gmane-mx.org; Mon, 06 Dec 2021 14:50:14 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:53870) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1muJvh-0005dt-EO for emacs-devel@gnu.org; Mon, 06 Dec 2021 14:45:43 -0500 Original-Received: from mail-oln040092064095.outbound.protection.outlook.com ([40.92.64.95]:61927 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 1muJvb-0007nV-I4 for emacs-devel@gnu.org; Mon, 06 Dec 2021 14:45:39 -0500 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=Lw5Q4kDlrTU4NNpR3PrzFSzTnwL9wUMQz1kP8xhnE6Ga6cNAjuv9iO48RCy+ydQ3fuQGay/jNPyhtKsVv2vfTd0gxsqIdua7zfGJETu49K+tlOK6NontJ4pEIrclucMTL0uANi3oVAmF40I93P4A7gphBw2iLsK7YD670uTH0tP88oSPXID0089NJIgV2EVe4XJTcEMMYFuO/rJiL594iRl1HYyfy4lJCf+AtE3mXdcl56W8wyZikXy9iJQVa3GGUUul4dwFAP3hk+nG6xBV6cxc9ut2C+PsB7mMBx4NtTkT6YfC8MJ+JyHG0dl/g46XlwM5YQ6xOarpb1ecU+8UgA== 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=8HTo8+zan0HKyTfFDPlRLdXKSNfp1fn+xAWBebDIBlU=; b=hSld3H/kLJsQVAlYrkHurH+cg6s1NlxWtQsP9nODaHS3xlkURZHDzvxHBnQ9pTzowB6GNplKisvFp89FEv8YUN/y1gj9B5rv6lJ6XDSn6bTGCoyiA5zAGU3AIW2lcEe7pCL+EytAsAMdujq1omOmzMULWOZZjY2rioFySRmuAqPDkEa9NmHzity7bw39dREXObHUVtRcu0S81mGsBfeEzI7BwEBkuvCPI9iihE9Axs+quS8O0BqiIvrXaJmne9xEp1VSslUR3S11jE1Dmu907Lo/l9pPh59hw/E+pSt3MDYJS+HGHDv0KQEP46X3SOziJnQMGbBQ2zDq9GZLW9Coeg== 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=8HTo8+zan0HKyTfFDPlRLdXKSNfp1fn+xAWBebDIBlU=; b=ljhvtpQV2dUG70lA3l4keCfADLsxQtGxhfSB6BNUj6MHKTrZ0Z4dcBMHm8yNRxQMEuCPd+OOenathqZ06Xg7EWtd4fduP+AvYnMY1nw1lqX6RT1mJdqbRtXnG/ce+UD24dY7woX4W5AjDTyQ/nm0NjCfKPTUtMAzTToKD103XezvH1xbGWpONAtHB2dkXl1eLEOr1yQF2UDFOlj9ASJxKZARzE+XUAtocL4+9+DWKUIV7cOMeuAVFgPPN/q1VXklYS7fDQC6/PLudLUzbriHr+mn2rGgvmXLBmzzjVR30561ePLV2oSXgOO6bA8RYN0+hbJuwsleJqKr/OC0O+hlDg== Original-Received: from AM9PR09MB4977.eurprd09.prod.outlook.com (2603:10a6:20b:304::20) by AM0PR09MB2705.eurprd09.prod.outlook.com (2603:10a6:208:127::28) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4755.16; Mon, 6 Dec 2021 19:45:30 +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:45:30 +0000 In-Reply-To: <897C2ADC-9F9D-4D3E-B427-773EC7CE561C@mit.edu> (Qiantan Hong's message of "Mon, 6 Dec 2021 15:16:24 +0000") X-TMN: [wv2HDzIE62kQk5VYWcZMH/bIHaF4+zF0] X-ClientProxiedBy: GV3P280CA0094.SWEP280.PROD.OUTLOOK.COM (2603:10a6:150:8::7) To AM9PR09MB4977.eurprd09.prod.outlook.com (2603:10a6:20b:304::20) X-Microsoft-Original-Message-ID: <8735n5tt47.fsf@live.com> X-MS-Exchange-MessageSentRepresentingType: 1 Original-Received: from pascal.homepc (81.232.177.30) by GV3P280CA0094.SWEP280.PROD.OUTLOOK.COM (2603:10a6:150:8::7) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4755.17 via Frontend Transport; Mon, 6 Dec 2021 19:45:30 +0000 X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id: fe527184-2f6b-439f-a458-08d9b8f0f5b9 X-MS-TrafficTypeDiagnostic: AM0PR09MB2705:EE_ X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: d8Tce4a9ISpKlr+JG/m6Tnl9hClSDiJQ/iST51b/O20V5+tC2uVkuo0tmkjBvtqEThHyayk/5yZ6Fy91iqcGSlmg5ae41VQhsGHvX7CpUfxnRtyeYAkBBEHxHRiYYZ2mPi1fVEPkBM8TxCVhjIfucl0DXZN1Z/iPlFWiGpoCOAqkgB8zQa8e4YjN4BoxTZG2dNkubjLlP2IF+AobD1e75eHjaZ/KX4c0hUlWJHQSY/AqRYOeO7XhBT9CssJTnbyHLm6/MTrKbYemQw77PHvJ+TddcDQdOYVjbPG2JD5lSZqVgggjctlOjK0w9L09pchiPXR+hAnRxQsfRXGaYIucGD/5BI4gxwuh3LtovUeDjnCCQUjzbGCNWjqdPuxEAFgTXJI4Pec/Ln74iIJMH6cVcino3Oy5xbIkNuAYrJj1SI1RhSTloIPQ9bgAvI5xCzUwSqW3Y5e6gboT/2kMbmmljF+iXqXMW8bp4wOAVOkCn4teHQhXUQHJomG7GJupJZ9TPkg5H3JyLFh4AD4E+4G+ugPm1jltb2JMOHwDXTK942YCDse4WAgdnhpcHpp1VII7rQb8bm0uWifQ+Q+/H3ZiBQ== X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: =?utf-8?B?czVTbFdFcUNGeFF6Mmw5MGxDR0dMSStBUUc5Tk1RTExRMVVmTktoNXpSSkl4?= =?utf-8?B?SVdNa0tNZVdOKzJ0Q2lSTFN5RDdzWXRrejJkeXFQZTlpai81OW1RcCtualht?= =?utf-8?B?U1UxM1BmdUNRcW9kMjhWK3BGUUs3Y0RlNEo4ekZTN0YybjYvNVQwTU1tS01I?= =?utf-8?B?USsxb2tHbTFHMkRYOW1kS1E2d3o5UVJJVXl5K29oSmxJaWc4Z3lUNHJNT2xp?= =?utf-8?B?UmcrMmd3WGZsSlFZbTB5c0Zvd2M3K3g2bEtib0RzSFd1RENaUXVSMVJudGc5?= =?utf-8?B?emtMLzB4MzM3M0I0NEFDVXYvVUt0Y2N2MFZkUHJ1cXNCdTZWZ1JNakQ5dlh1?= =?utf-8?B?STlFQTJaQml4ZTdoeHJwR1JDOGJZNVB5cGFoZk1GdVhrRU5IU0h2NERHbDZ5?= =?utf-8?B?SVpDWDZqeU5SMXJURThCaXp0ZzZtWWt0dEpPQVRjMmF1VzAxQ2xuKzgyNkxk?= =?utf-8?B?ZDFNY1IwWDJqb0M5RGhoR2JGclY1RWhyUDJEdFR5YXFzejFLZS9ZanZoV0Y4?= =?utf-8?B?WXltcmw1S3V6SUsxd25LWFlFTFdIMmZRVEtTcHRiNEh0eVJEUmpaRUFUTU53?= =?utf-8?B?bEY2TzVDRmZMWENMNUs1aldqQWVPUUs4SGZSek5Dd0lMZ0lnc3RHYnY0ZjJF?= =?utf-8?B?SldRZE5HZ0VjdGtjRllKKzdwOVlkVTNzQWt1ZH X-OriginatorOrg: sct-15-20-4755-11-msonline-outlook-64da6.templateTenant X-MS-Exchange-CrossTenant-Network-Message-Id: fe527184-2f6b-439f-a458-08d9b8f0f5b9 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:45:30.6708 (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: AM0PR09MB2705 Received-SPF: pass client-ip=40.92.64.95; 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:281159 Archived-At: Qiantan Hong writes: >> By the way, after second thought; sqlite locks entire database. If I rem= ember >> well they advice against using sqlite db when concurrent write access is= needed. > Seems that its only use is as a persistent hash table then. Well, it is a relational database for working with structured data and usin= g SQL in desktop applications. You don't need to persist sqlite db to file at all. It works perfectly well wiht in-memory databases only. So it is muc= h more than just key-value database. You get SQL interpretter/byte-compiler so you can use SQL to work with your data. But Lars obviously, as I understand from last mails, is thinking of key-value settings a l=C3=A1 Firefox in Emacs, so I have no idea if he plan= s to expose SQL interface or not.