From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: X-Spam-Checker-Version: SpamAssassin 3.4.6 (2021-04-09) on dcvr.yhbt.net X-Spam-Level: X-Spam-ASN: X-Spam-Status: No, score=-4.2 required=3.0 tests=ALL_TRUSTED,AWL,BAYES_00, DKIM_SIGNED,DKIM_VALID,DKIM_VALID_AU,DKIM_VALID_EF shortcircuit=no autolearn=ham autolearn_force=no version=3.4.6 Received: from localhost (dcvr.yhbt.net [127.0.0.1]) by dcvr.yhbt.net (Postfix) with ESMTP id ED55E1F4CC for ; Wed, 4 Dec 2024 19:39:14 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=80x24.org; s=selector1; t=1733341155; bh=EVBtSwbJJdUwJbq/n0BnqctiZVhGm8GrKVcH89PlcO8=; h=From:To:Subject:Date:From; b=t5FAgAPfSAkUv/Lh6vcHdnRIZvrLNPNU9ELXcDXa/FduOvaV0y3kLmmNgTTj/gyxU wE7A04ga//JF5YYhVzNx2wHcxloohyOnbsFIIi4n3X4Y1PSgetZly76XmeiMZ2bbSg e/8yThYG7ImN6wb/yvUO10DoPKKNC8+2M4nOz2qM= From: Eric Wong To: meta@public-inbox.org Subject: [PATCH 0/3] some SQLite-related things Date: Wed, 4 Dec 2024 19:39:11 +0000 Message-ID: <20241204193914.3227868-1-e@80x24.org> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit List-Id: The first two are a bit shocking :x, but seem to work alright forwards and backwards compatibility-wise for more correct code. 3/3 is straightforward, at least. Eric Wong (3): sqlite: avoid incorrect/deprecated `LIKE' use sqlite: use `BLOB' column type instead of `VARBINARY' SQLiteUtil: hoist out common create_db code MANIFEST | 2 ++ lib/PublicInbox/ExtSearchIdx.pm | 12 ++++---- lib/PublicInbox/IMAPTracker.pm | 5 ++-- lib/PublicInbox/LeiMailSync.pm | 28 ++++++------------- lib/PublicInbox/Over.pm | 9 ++---- lib/PublicInbox/OverIdx.pm | 4 +-- lib/PublicInbox/POP3D.pm | 12 +++----- lib/PublicInbox/SQLiteUtil.pm | 40 +++++++++++++++++++++++++++ lib/PublicInbox/SharedKV.pm | 33 ++++++++-------------- t/shared_kv.t | 5 ++++ t/sqlite_util.t | 49 +++++++++++++++++++++++++++++++++ 11 files changed, 134 insertions(+), 65 deletions(-) create mode 100644 lib/PublicInbox/SQLiteUtil.pm create mode 100644 t/sqlite_util.t