From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Lars Ingebrigtsen Newsgroups: gmane.emacs.devel Subject: Re: sqlite3 usage for multisession variable storage Date: Wed, 15 Dec 2021 14:18:58 +0100 Message-ID: <87r1aej9a5.fsf@gnus.org> References: <87tufmjyai.fsf@gnus.org> <87lf0nr2b4.fsf@gnus.org> <87ee6f5wmy.fsf@telefonica.net> <87czlzqy3a.fsf@gnus.org> <874k7bqptr.fsf@gnus.org> <922b09b2-24b1-6f3f-ce5b-7b07675d3637@dasyatidae.com> <875yrqodm4.fsf@gnus.org> <835yrqj9ow.fsf@gnu.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="39014"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) Cc: rtt@dasyatidae.com, emacs-devel@gnu.org To: Eli Zaretskii Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Wed Dec 15 15:01:52 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 1mxUqt-0009st-IR for ged-emacs-devel@m.gmane-mx.org; Wed, 15 Dec 2021 15:01:51 +0100 Original-Received: from localhost ([::1]:37844 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1mxUqo-0007e8-Cc for ged-emacs-devel@m.gmane-mx.org; Wed, 15 Dec 2021 09:01:46 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:60184) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mxUBZ-0004sX-DB for emacs-devel@gnu.org; Wed, 15 Dec 2021 08:19:09 -0500 Original-Received: from [2a01:4f9:2b:f0f::2] (port=42372 helo=quimby.gnus.org) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mxUBX-0005NZ-Pd; Wed, 15 Dec 2021 08:19:09 -0500 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnus.org; s=20200322; h=Content-Type:MIME-Version:Message-ID:In-Reply-To:Date: References:Subject:Cc:To:From:Sender:Reply-To:Content-Transfer-Encoding: Content-ID:Content-Description:Resent-Date:Resent-From:Resent-Sender: Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=cz6S9S5x9QT02LEpzFYdzNS9IjvZhwRn9kAdLofNIGE=; b=R4Qv3+z0QXDXGoHSkK5lhcvJs9 b26ye3paPksfDhxG2JJzjzNhEg9pwpU42KaAef7joFWe3V/FCyIckwDhhDi0dTYq7xytUItLAx2RN js7QEEaTPf1rtM7NKtom5dtJswMgnCqFUcXcyA9VkfijZPk+DEop1uY2vtYGi30+Mlwk=; Original-Received: from [84.212.220.105] (helo=xo) by quimby.gnus.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mxUBQ-0005AZ-2Y; Wed, 15 Dec 2021 14:19:02 +0100 Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwAgMAAAAqbBEUAAAABGdBTUEAALGPC/xhBQAAACBj SFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAADFBMVEVzh4uuvrxBUFX/ //8ut8HHAAAAAWJLR0QDEQxM8gAAAAd0SU1FB+UMDws4HvYLs78AAAF9SURBVCjPPdJBa4MwFAfw tJhSPHWl2WEnHStUv4VlHc6TSp4MT9vYofRT2GJ28DjWnasQiO9TLia2gpAf/5eX8JQQWjAYniJd EQ2hlx9Q3sDaEVwA/w5YbgA0S7y54BZ+/qNmEiyivEQ8Q+oMgDSc4jmzCZStF8q3dGFwOAlXZimx cNhWXsuSih36aGyAE0j6V7unQP32WcoHrFAYOBYMCpXZMtcAbOtQ36VQOwPmnijkY0KTTtzK6OFL wsMIP3458qS3CF4/q2wbjNiHRz8cE7qfV/7UYsXiqG7vLO5ZOZdy0lrQsiPtY1/oqxGHlsT5fWxz A8Enu/NUlKabKJRXd1fkuD+hHtUAmSpnicKMiq0BvxYNs/jg6P00zJzDIo6X2TB4vdbf0PNyDeDE VQze3/8almBFEHs4+Pd4RlQW8g8FXhRRJlk0EpXF/qluxAWvyfO87oY9KoDNmm47ZRpsAL1qurFQ gN0yDlRosFJ+QoLhHP3vLI/r+FnxmPwDfgizGO14aqQAAAAldEVYdGRhdGU6Y3JlYXRlADIwMjEt MTItMTVUMTE6NTY6MzArMDA6MDBFx8rFAAAAJXRFWHRkYXRlOm1vZGlmeQAyMDIxLTEyLTE1VDEx OjU2OjMwKzAwOjAwNJpyeQAAAABJRU5ErkJggg== X-Now-Playing: Propaganda's _A Secret Wish_: "p:Machinery" In-Reply-To: <835yrqj9ow.fsf@gnu.org> (Eli Zaretskii's message of "Wed, 15 Dec 2021 15:10:07 +0200") X-Host-Lookup-Failed: Reverse DNS lookup failed for 2a01:4f9:2b:f0f::2 (failed) Received-SPF: pass client-ip=2a01:4f9:2b:f0f::2; envelope-from=larsi@gnus.org; helo=quimby.gnus.org X-Spam_score_int: -35 X-Spam_score: -3.6 X-Spam_bar: --- X-Spam_report: (-3.6 / 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, RCVD_IN_DNSWL_MED=-2.3, RDNS_NONE=0.793, 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:282038 Archived-At: Eli Zaretskii writes: >> It's the "restore from backup" thing that's not acceptable, which makes >> MEMORY unworkable here, I think. > > Maybe this aspect should be left to the application level (with some > reasonable default in place)? It sounds like it's a judgment call > that can only be resolved with a specific application in mind. Yup. But this was with the multisession storage in mind -- if lots of different Emacs things are saving application state to the same .sqlite file, then we want to ensure pretty good reliability for that file. Other packages using SQLite should make the decision themselves (by issuing the pragmas they prefer to have for those .sqlite databases). -- (domestic pets only, the antidote for overdose, milk.) bloggy blog: http://lars.ingebrigtsen.no