From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: X-Spam-Checker-Version: SpamAssassin 3.4.2 (2018-09-13) on dcvr.yhbt.net X-Spam-Level: X-Spam-Status: No, score=-4.0 required=3.0 tests=ALL_TRUSTED,BAYES_00 shortcircuit=no autolearn=ham autolearn_force=no version=3.4.2 Received: from localhost (dcvr.yhbt.net [127.0.0.1]) by dcvr.yhbt.net (Postfix) with ESMTP id 31ED51F66E for ; Tue, 25 Aug 2020 03:02:47 +0000 (UTC) From: Eric Wong To: meta@public-inbox.org Subject: [PATCH 0/3] SQLite-related things Date: Tue, 25 Aug 2020 03:02:44 +0000 Message-Id: <20200825030247.12307-1-e@yhbt.net> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit List-Id: While I'm considering options for dealing with SQLite locking problems , some obvious cleanups and improvements can be made, here. We'll now support WAL if (and only if) a user chooses to enable it; since we can't do it by default (see 3/3 for explanation). Eric Wong (3): over: skip nodatacow on the journal msgmap: use "CREATE TABLE IF NOT EXISTS" over+msgmap: respect WAL journal_mode if set lib/PublicInbox/Msgmap.pm | 29 ++++++++++++++--------------- lib/PublicInbox/Over.pm | 26 ++++++++++++++++++++++---- lib/PublicInbox/OverIdx.pm | 5 ----- t/over.t | 10 ++++++++++ 4 files changed, 46 insertions(+), 24 deletions(-)