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: Mon, 06 Dec 2021 17:10:59 +0100 Message-ID: <87a6hdn27g.fsf@gnus.org> References: <87tufmjyai.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="2217"; 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: Stefan Kangas Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Mon Dec 06 17:12:19 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 1muGbD-0000My-Dy for ged-emacs-devel@m.gmane-mx.org; Mon, 06 Dec 2021 17:12:19 +0100 Original-Received: from localhost ([::1]:40712 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1muGbC-0007t3-DE for ged-emacs-devel@m.gmane-mx.org; Mon, 06 Dec 2021 11:12:18 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:53026) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1muGaA-0005wd-9v for emacs-devel@gnu.org; Mon, 06 Dec 2021 11:11:14 -0500 Original-Received: from [2a01:4f9:2b:f0f::2] (port=56380 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 1muGa7-0002Fn-8x for emacs-devel@gnu.org; Mon, 06 Dec 2021 11:11:12 -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=kv4gFPp3WvV67W3pkSY9j9OlIcaxzMIRNDuDotKVH10=; b=RdxY0pzaUXiYWCedRn1sovSIJO jZ4zAt3CVgDNLE/rMeFozdbu+ud1zQVo9GgD4vte0FCBv3uHE3b16bAW43QCQj7hu964jqtCeQyI4 YcLqbyyDAVv2a1DnM3hnJnhjIWAACvjDZ6cLzrtuEXPF5ZdjQSDqwIl40x1C9R7hEXv4=; 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 1muGZw-0006y9-H8; Mon, 06 Dec 2021 17:11:03 +0100 Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwBAMAAAClLOS0AAAABGdBTUEAALGPC/xhBQAAACBj SFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAAFVBMVEU5bJxudmpRd6e0 upPw7LL18sv///8E9EeWAAAAAWJLR0QGYWa4fQAAAAd0SU1FB+UMBhAIKfyLI1gAAAGVSURBVDjL jZJhksIgDIWxJ1iK/m+7J0DoARzDAZwm97/KvqSwxdWdMWOR8vFeEqhz7+PkhsENy2tMhpcD+Q5g dV5GPBhCiosf8VPQO6SUMM4zFEMPZoCxWg3DJ2DpQVfKsnxbjgYmfxA/dsB34GhwUEHb9wRm/w9w Rt4AdfJfn4B5rId4qlZzX/Hk8hU5RgN7Cfuuya0imE62Mho+QIphu9atrXgDkghDNOCfQMAjmz+i B5ywkCi9ACEK9q87xgrOYl6XO14KK7s2wAZkRaZYdNdDAe+AL3sJVBpQKzKFyB0VlD+KBkIDxGcm xHZhI6nmKKwKomIKJMG0/AIxhYGIaeGHy8QUqpWBpHOAlZh7wFkVogoCULLZAfCqTg2gMgXFgGiH CsoW7Ayr1Yo9HShcy+UL85OCq0JWqQ2SNKt9yYIOxXOQdo4E9XULheyiMu3HbimwFv055ZglhnQz hVjnRF5CDLgQfA7RWaMFuQvd/XrTr8tnIK0Kl5AwzfGsNxs4C0cADCqHv4drJKl97J9eSmZ+RPwB v5reFfx5noYAAAAldEVYdGRhdGU6Y3JlYXRlADIwMjEtMTItMDZUMTY6MDg6NDErMDA6MDBV9i1w AAAAJXRFWHRkYXRlOm1vZGlmeQAyMDIxLTEyLTA2VDE2OjA4OjQxKzAwOjAwJKuVzAAAAABJRU5E rkJggg== X-Now-Playing: The Cure's _Boys Don't Cry_: "Boys Don't Cry" In-Reply-To: (Stefan Kangas's message of "Mon, 6 Dec 2021 13:04:00 +0100") 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:281130 Archived-At: Stefan Kangas writes: > One concern is how to synchronize this between different machines, or > indeed if recommended use should be to do that at all. I think the sqlite format is portable across OS-es and endianness and stuff? Let's see... https://sqlite.org/different.html ---- The SQLite file format is cross-platform. A database file written on one machine can be copied to and used on a different machine with a different architecture. Big-endian or little-endian, 32-bit or 64-bit does not matter. All machines use the same file format. Furthermore, the developers have pledged to keep the file format stable and backwards compatible, so newer versions of SQLite can read and write older database files. ---- -- (domestic pets only, the antidote for overdose, milk.) bloggy blog: http://lars.ingebrigtsen.no