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: Tue, 14 Dec 2021 11:28:57 +0100 Message-ID: <87czlzqy3a.fsf@gnus.org> References: <87tufmjyai.fsf@gnus.org> <87lf0nr2b4.fsf@gnus.org> <87ee6f5wmy.fsf@telefonica.net> 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="10341"; 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: =?utf-8?Q?=C3=93scar?= Fuentes Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Tue Dec 14 11:30:30 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 1mx54n-0002SF-Of for ged-emacs-devel@m.gmane-mx.org; Tue, 14 Dec 2021 11:30:29 +0100 Original-Received: from localhost ([::1]:49548 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1mx54m-0005sh-Nz for ged-emacs-devel@m.gmane-mx.org; Tue, 14 Dec 2021 05:30:28 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:42348) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mx53V-0004we-5P for emacs-devel@gnu.org; Tue, 14 Dec 2021 05:29:09 -0500 Original-Received: from [2a01:4f9:2b:f0f::2] (port=57254 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 1mx53Q-0002n1-OR for emacs-devel@gnu.org; Tue, 14 Dec 2021 05:29:08 -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=dL2YGUK7jJ71kJljVBgwYG7EMOB93P7WY7pj0a5LSLM=; b=jUO+D+lGRjgGz7lgYfu8xZtlnw 8FgCZcXp3nRLE+Jn3gG9c9t4qmm9V1wlyZPr6ZXTpEfY18AAkfS0Nd5pHQCgNO4S+x8wodSJc2uTy lSLGS9wvHZftBAjDXIi5fKkPGytC8YhrgFI453kdkrLugHI+FQxLNzpWPTPp8NtLk/ws=; 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 1mx53M-00088M-I3; Tue, 14 Dec 2021 11:29:03 +0100 Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwBAMAAAClLOS0AAAABGdBTUEAALGPC/xhBQAAACBj SFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAAG1BMVEX48tr+/e68qJlS eVVDPSuoWkLDnVLRn1v///+6XTF/AAAAAWJLR0QIht6VegAAAAd0SU1FB+UMDgoaFuYccP8AAAGy SURBVDjLzZTBctsgEIatzPQu2hdINwbdTRLfK/ICqhfd5QB3edh9/S6KJMtNPNNj/wMD8+2/u0jA breqrnbVbis1q8yrZVFv5hNU1RqkvlJ9D6i/Mv0DqAU82U/6VUC1f8OTQ4zxhOice5NxBh6yj2nU iNgHNIM+rUD73owGsUMeoUOcgNpj0hgzIGgdxAh6BRgwGegAwL2MutuA6H0jQINzBeu5BiIEikOQ ZPEdB4Bvq0OiOAJEMBf0i2MCemjiKJhyL1FrDQAzAEuOQCRjAaoAMTcjJAbIzIaujtLIGPl8AM2R ieilAFWAhozeHhviRMRs51QDYBcQnxNnTiw6L2Aou0VMLNGSjC8zSDHiIEDy+CZ75nEGrxyx08HT QGNDv6/Avkb5DbnPPRkfbSxgatdaCuhzEjBgaNu1uDgMpsChpxTQHtnO+7CHEJFDwj4R4/lIAsp5 27egO6CRsZPvwhc4L4728IBgWHBDkezhaQHOPcuxca1bVYor9QCf9Dg5rud1e1yv4MP4Bbi9XurO 9bitcXtBtlGPd8CPm642i+8/7/Wu/hvw8ebU1bSj65tT/wGcQLm6HwaWWwAAACV0RVh0ZGF0ZTpj cmVhdGUAMjAyMS0xMi0xNFQxMDoyNjoyMiswMDowMEQ3huUAAAAldEVYdGRhdGU6bW9kaWZ5ADIw MjEtMTItMTRUMTA6MjY6MjIrMDA6MDA1aj5ZAAAAAElFTkSuQmCC X-Now-Playing: Frankie Goes To Hollywood's _Welcome To The Pleasuredome_: "Ferry (Go)" In-Reply-To: <87ee6f5wmy.fsf@telefonica.net> (=?utf-8?Q?=22=C3=93scar?= Fuentes"'s message of "Tue, 14 Dec 2021 11:05:57 +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:281887 Archived-At: =C3=93scar Fuentes writes: > Forgot to mention that modern databases usually offer several strategies > for persisting data. A quick look at SQLite documentation shows that it > can be configured to use a write ahead log, which is faster than the > default rollback journal: > > https://sqlite.org/wal.html Yes, I used the WAL in my tests. (The implementation is still on the scratch/sqlite branch, for those who are curious.) --=20 (domestic pets only, the antidote for overdose, milk.) bloggy blog: http://lars.ingebrigtsen.no