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, 07 Dec 2021 07:54:23 +0100 Message-ID: <871r2oj468.fsf@gnus.org> References: <87tufmjyai.fsf@gnus.org> <877dcgq5ns.fsf@iki.fi> Mime-Version: 1.0 Content-Type: text/plain Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="40259"; 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: Teemu Likonen Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Tue Dec 07 07:55:27 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 1muUNq-000AES-N9 for ged-emacs-devel@m.gmane-mx.org; Tue, 07 Dec 2021 07:55:26 +0100 Original-Received: from localhost ([::1]:60678 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1muUNp-0007Yd-Me for ged-emacs-devel@m.gmane-mx.org; Tue, 07 Dec 2021 01:55:25 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:46454) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1muUMx-0005Xm-B6 for emacs-devel@gnu.org; Tue, 07 Dec 2021 01:54:31 -0500 Original-Received: from [2a01:4f9:2b:f0f::2] (port=35362 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 1muUMv-0005aK-RN for emacs-devel@gnu.org; Tue, 07 Dec 2021 01:54:31 -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=JPmuLh+aVo+HTQFwA0zXMzbk8DWRONC+/JwdZNp/EqY=; b=thvKl0Jw7CCx0HvWD6TeUBZT/o R5ez7jJgSYwHxv76Gaz057YAacmKoZYtPNRgNZ0g0LmnWpvJjuRAsL2FXPq6qeT+7fa0LSwz72tbj R7QnbYgZdet0txPtg2ymLNZZGv9n+eWhLRdlcPQvV3jAY7m4bVJFQ4vvLQVw4BOnjGG0=; 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 1muUMp-0004Jl-L7; Tue, 07 Dec 2021 07:54:26 +0100 Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwBAMAAAClLOS0AAAABGdBTUEAALGPC/xhBQAAACBj SFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAAKlBMVEWoyNuz1e294vnB 5vuTrc1hcZZ9ksFGUI82O3U9RIWFnLF2iqNUX23///98aRmmAAAAAWJLR0QN9rRh9QAAAAd0SU1F B+UMBwY1OSvDwyUAAAGZSURBVDjLlZQ/T8JAGMavxEHj0msgrrahDOCiiSwygIY4wKLyBiL9AA4O SkKaxpk0Jq6GsDnIQhnQpAy2g8Z06d2HsvSPcKUl+g7X3v3uued9765FCHF4Jfiwy6+Oo9UZiOmt Au7fIGFMTANCGsCbQWAuiOESwhGryF94Te4U4/2WyIDyvTd5+wxj+TGzDnYWQBcSFN5SYlVMBljC KSCWbrknSZ655AULCncIofMaWh5PBHR1NBpqmqZqGQbk6zCZ38ADAcIqjqlLP1sKBeKwQKZf9O3b plPiiAwo1d3JS6cLBGDdXFP9YM1L1w3HbY5fTdPiGFAxnRNzrCBKlZhiShukab5bthWA6EYWAXRi K3O4BXap4jBwVocx82LWcD5gtksaCpvuAXUrFBRKniy2QNnoGpOxZZOucchmBe0BdPptfVl58Cg8 A6jQ7oPaj9VxtTw71qOHY/FnIEjBhqyB7GxRB0LRXsmXIdjTAwUfV+QGPuB+b0ktBHzVb9kPx4/o Je1z5tP+DDxKlnjj/j3muSg9f1fRhtj6AW4SoWhCnV2tAAAAJXRFWHRkYXRlOmNyZWF0ZQAyMDIx LTEyLTA3VDA2OjUzOjU3KzAwOjAwQFw/hgAAACV0RVh0ZGF0ZTptb2RpZnkAMjAyMS0xMi0wN1Qw Njo1Mzo1NyswMDowMDEBhzoAAAAASUVORK5CYII= X-Now-Playing: New Order's _Movement_: "Doubts Even Here" In-Reply-To: <877dcgq5ns.fsf@iki.fi> (Teemu Likonen's message of "Tue, 07 Dec 2021 08:40:23 +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:281214 Archived-At: Teemu Likonen writes: > I think Emacs users would want automatic VACUUM so that they never need > to worry about it. (1) One option for that is to set SQLite's > > PRAGMA auto_vacuum = FULL; > > before any tables are created in database. Thanks; that seems like an easy enough solution, so I've added it to sticky.el. -- (domestic pets only, the antidote for overdose, milk.) bloggy blog: http://lars.ingebrigtsen.no