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 Date: Sun, 12 Dec 2021 05:26:00 +0100 Message-ID: <8735myih47.fsf@gnus.org> References: <87tufmjyai.fsf@gnus.org> <877dcil2sj.fsf@ericabrahamsen.net> <87czm98qi1.fsf@gnu.org> <87o85tcwm0.fsf@ericabrahamsen.net> <874k7ljwkr.fsf@gnus.org> <87fsr5cuzq.fsf@ericabrahamsen.net> <878rwx8mdn.fsf@gnu.org> <87r1aphuei.fsf@gnus.org> <837dcex6ub.fsf@gnu.org> <83a6h9tu1c.fsf@gnu.org> <83mtl7r1c5.fsf@gnu.org> <87fsqzihsb.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="10519"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) Cc: Eli Zaretskii , emacs-devel@gnu.org To: Pip Cet Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Sun Dec 12 05:27:22 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 1mwGSI-0002Yz-1w for ged-emacs-devel@m.gmane-mx.org; Sun, 12 Dec 2021 05:27:22 +0100 Original-Received: from localhost ([::1]:54312 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1mwGSH-0002Au-2y for ged-emacs-devel@m.gmane-mx.org; Sat, 11 Dec 2021 23:27:21 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:60440) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mwGR6-0001RX-Em for emacs-devel@gnu.org; Sat, 11 Dec 2021 23:26:08 -0500 Original-Received: from [2a01:4f9:2b:f0f::2] (port=33996 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 1mwGR4-00041i-Sa; Sat, 11 Dec 2021 23:26:08 -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=3Yj1ayy8OLmBJZvMSOL4kSlWuVfC3CTEWQOxRnlL8iE=; b=fNLGKxY5dcNlP1FOsALWGSJa49 rAaymSxlK9DTedFEIxCfMFZHGnEgFZ129asTAXOgUcyTnPDdefH3X9cgDxDbYTkP7An7Bs6kHTpza MlI0wnTUYwfRGU+KqeqMC5GZQR/wvSoyH2oMTF9ZbpYAn7r2iYHK/kIBXCijmaSsujjc=; 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 1mwGR0-0001bV-3c; Sun, 12 Dec 2021 05:26:05 +0100 X-Now-Playing: Shopping's _Consumer Complaints_: "Long Way Home" In-Reply-To: (Pip Cet's message of "Sat, 11 Dec 2021 13:57:31 +0000") 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:281737 Archived-At: Pip Cet writes: > What about non-local files? Currently, IIUC, sqlite-mode just doesn't > work for them, handing all file names to the sqlite library which then > fails to open them. It would certainly be nice to work with non-local files, but I think it's a bit outside what we're going for here. The point is to have efficient local storage, and non-local sqlite files doesn't give us that. > I'm not volunteering, but maybe we could use the sqlite3 VFS interface > to back an sqlite3 database with an Emacs buffer (or several). That > would solve both the remote access issue and make C-x C-f behave more > like it does for other files. It's be fun to have something like that, but I don't think there's that much utility in it. -- (domestic pets only, the antidote for overdose, milk.) bloggy blog: http://lars.ingebrigtsen.no