CVS commit: pkgsrc/databases/py-apsw

["Adam Ciarcinski" <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Thu Nov  6 16:15:46 UTC 2025

Modified Files:
        pkgsrc/databases/py-apsw: Makefile PLIST distinfo

Log Message:
py-apsw: updated to 3.51.0.0

3.51.0.0

JSON can be used as though it is a native type of SQLite, with automatic conversion of Python objects on writing and reading. (example)

Connection.convert_binding (and Cursor.convert_binding) callback to allow conversion of bindings when executing SQL.

Connection.convert_jsonb (and Cursor.convert_jsonb) callback to allow conversion of JSONB when reading query results. (JSONB is SQLite’s binary internal parsed format for quick operations on JSON.)

3 functions for working directly with JSONB allowing direct conversion between Python objects and JSONB, without having to go through the intermediate JSON text format.

Added apsw.ext.Function() for calling SQL functions directly from Python.

When using with (Connection context manager) you can set the outer transaction mode to DEFERRED (default) / IMMEDIATE / EXCLUSIVE. (APSW issue 578)

Changeset.apply() now takes filter_change parameter for allowing filtering on individual change level, taking advantage of sqlite3changeset_apply_v3

Updated Connection.status() to use 64 bit API, and apsw.ext.ShowResourceUsage() to show TEMPBUF_SPILL. (pragma cache_size controls the amount of temp/cache memory available.)

The percentile extension is enabled when enabling all extensions, which is standard for pypi downloads. It enables several percentile, median, and related SQL functions.

The carray extension is enabled when enabling all extensions, which is standard for pypi downloads. apsw.carray() allows binding bulk numbers, strings, and blobs to a query. See the example.

SQLITE_SCM_ constants (BRANCH, TAGS, DATETIME) are available on the module if built with the amalgamation.

apsw.ext.generate_series_sqlite() updated to exactly match SQLite’s behaviour. apsw.ext.generate_series() is recommended as it matches other databases.

Updated apsw.unicode to support Unicode 17.0 which adds 4,803 new codepoints, and updated line breaking, along with other small tweaks.

The Geopoly extension (GeoJSON access to RTree) is enabled when --enable-all-extensions is used with setup.py. This includes pypi builds.

This is the final release supporting Python 3.9.


To generate a diff of this commit:
cvs rdiff -u -r1.86 -r1.87 pkgsrc/databases/py-apsw/Makefile
cvs rdiff -u -r1.10 -r1.11 pkgsrc/databases/py-apsw/PLIST
cvs rdiff -u -r1.55 -r1.56 pkgsrc/databases/py-apsw/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/databases/py-apsw/Makefile
diff -u pkgsrc/databases/py-apsw/Makefile:1.86 pkgsrc/databases/py-apsw/Makefile:1.87
--- pkgsrc/databases/py-apsw/Makefile:1.86      Sat Aug  2 09:39:43 2025
+++ pkgsrc/databases/py-apsw/Makefile   Thu Nov  6 16:15:46 2025
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.86 2025/08/02 09:39:43 adam Exp $
+# $NetBSD: Makefile,v 1.87 2025/11/06 16:15:46 adam Exp $
 
-DISTNAME=      apsw-3.50.4.0
+DISTNAME=      apsw-3.51.0.0
 PKGNAME=       ${PYPKGPREFIX}-${DISTNAME:S/-r1//}
 CATEGORIES=    databases python
 MASTER_SITES=  ${MASTER_SITE_GITHUB:=rogerbinns/}

Index: pkgsrc/databases/py-apsw/PLIST
diff -u pkgsrc/databases/py-apsw/PLIST:1.10 pkgsrc/databases/py-apsw/PLIST:1.11
--- pkgsrc/databases/py-apsw/PLIST:1.10 Mon Jun 30 18:41:56 2025
+++ pkgsrc/databases/py-apsw/PLIST      Thu Nov  6 16:15:46 2025
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.10 2025/06/30 18:41:56 adam Exp $
+@comment $NetBSD: PLIST,v 1.11 2025/11/06 16:15:46 adam Exp $
 bin/apsw-${PYVERSSUFFIX}
 ${PYSITELIB}/${WHEEL_INFODIR}/METADATA
 ${PYSITELIB}/${WHEEL_INFODIR}/RECORD
@@ -38,9 +38,15 @@ ${PYSITELIB}/apsw/speedtest.pyo
 ${PYSITELIB}/apsw/tests/__main__.py
 ${PYSITELIB}/apsw/tests/__main__.pyc
 ${PYSITELIB}/apsw/tests/__main__.pyo
+${PYSITELIB}/apsw/tests/carray.py
+${PYSITELIB}/apsw/tests/carray.pyc
+${PYSITELIB}/apsw/tests/carray.pyo
 ${PYSITELIB}/apsw/tests/ftstests.py
 ${PYSITELIB}/apsw/tests/ftstests.pyc
 ${PYSITELIB}/apsw/tests/ftstests.pyo
+${PYSITELIB}/apsw/tests/jsonb.py
+${PYSITELIB}/apsw/tests/jsonb.pyc
+${PYSITELIB}/apsw/tests/jsonb.pyo
 ${PYSITELIB}/apsw/tests/sessiontests.py
 ${PYSITELIB}/apsw/tests/sessiontests.pyc
 ${PYSITELIB}/apsw/tests/sessiontests.pyo

Index: pkgsrc/databases/py-apsw/distinfo
diff -u pkgsrc/databases/py-apsw/distinfo:1.55 pkgsrc/databases/py-apsw/distinfo:1.56
--- pkgsrc/databases/py-apsw/distinfo:1.55      Sat Aug  2 09:39:43 2025
+++ pkgsrc/databases/py-apsw/distinfo   Thu Nov  6 16:15:46 2025
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.55 2025/08/02 09:39:43 adam Exp $
+$NetBSD: distinfo,v 1.56 2025/11/06 16:15:46 adam Exp $
 
-BLAKE2s (apsw-3.50.4.0.zip) = ce85e52d6fc93e64087fe43803f3c800313b4d5ec0cac32edc638f36071361b5
-SHA512 (apsw-3.50.4.0.zip) = 71db63b0a7f550c9a5d3f112d47c24953472cc6555f0b57198428997d5cf5acf73629f2da8d5d53a2473067ba19d4b655cce467a5e2267e5bd6e8cf0d9883579
-Size (apsw-3.50.4.0.zip) = 2551631 bytes
+BLAKE2s (apsw-3.51.0.0.zip) = 15f600656a024347d3a84c14dc6335abf9147ef4bc67744f9e4e1d3d0f1777e2
+SHA512 (apsw-3.51.0.0.zip) = 9860f804ed57222920d21dff83fdc7a5e51a0e462e6ca15fd9a9d548f3d4d29adaa36470c91652159fbc3ce5ab6a24ee6776a3c6d4131703863e61395bfb0a47
+Size (apsw-3.51.0.0.zip) = 2669479 bytes