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:23:53 +0100 Message-ID: <877dcaih7q.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> <83ee6jqsti.fsf@gnu.org> 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="38361"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) Cc: emacs-devel@gnu.org To: Eli Zaretskii Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Sun Dec 12 05:24:43 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 1mwGPj-0009p1-Ke for ged-emacs-devel@m.gmane-mx.org; Sun, 12 Dec 2021 05:24:43 +0100 Original-Received: from localhost ([::1]:52276 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1mwGPi-0000de-42 for ged-emacs-devel@m.gmane-mx.org; Sat, 11 Dec 2021 23:24:42 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:59988) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mwGP3-0008Oi-5t for emacs-devel@gnu.org; Sat, 11 Dec 2021 23:24:01 -0500 Original-Received: from [2a01:4f9:2b:f0f::2] (port=33978 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 1mwGP0-0003kF-VZ; Sat, 11 Dec 2021 23:24:00 -0500 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnus.org; s=20200322; h=Content-Transfer-Encoding:Content-Type:MIME-Version:Message-ID :In-Reply-To:Date:References:Subject:Cc:To:From:Sender:Reply-To: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=/pWa/gLR2/WgFKm4bMx8ulJ+IwHED0VE9eR2hlHw2kU=; b=okcZB1+P7tZN3Q6HuHa5xWDR0r 11WWZZgOaTGikXHREHErJyQHTL2n3mdXCcEPE3A/TAKS+XkXtCSbCS4vOL3eQf+FZeYaZuEvyYs10 KuNzl8BF2A/j0Dc6pH3V01VJd2rvCWgPearAiFqt9G/dhqBJQ/OMIMN6gfq6cOPd5FjE=; 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 1mwGOv-0001ap-Tz; Sun, 12 Dec 2021 05:23:56 +0100 X-Now-Playing: Shopping's _Consumer Complaints_: "Hard As Nails" In-Reply-To: <83ee6jqsti.fsf@gnu.org> (Eli Zaretskii's message of "Sat, 11 Dec 2021 13:33:45 +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:281736 Archived-At: Eli Zaretskii writes: > Probably. But is .sqlite3 indeed the extension to use? I don't have > even a single .sqlite3 file on my system here, but gobs of *.sqlite > files. Ah, I misremembered. I do have a handful of *.sqlite3 files here, but the vast majority are indeed called *.sqlite. > I won't recommend using file-name handlers for this, as it could be > problematic for local files. How about reading just the few first > bytes of the file and recognizing its magic signature instead? Well, a mechanism based on the name would be OK... but I think Stefan M had some suggestions, so I'll continue the discussion there. =F0=9F=98=80 --=20 (domestic pets only, the antidote for overdose, milk.) bloggy blog: http://lars.ingebrigtsen.no