Wed Sep 27 15:17:05 2023 UTC ()
py-apsw: updated to 3.43.1.0

3.43.1.0

All C code calling into Python and all C code called by Python uses vectorcall / fastcall (see PEP 590) which reduces the overhead of passing and receiving positional and keyword arguments. (APSW issue 477 APSW issue 446):

Conversion of arguments from Python values to C values drops generic PyArg_ParseTupleAndKeywords in favour of direct processing which is more efficient and allows better exception messages.
Running speedtest with a VFS that inherits all methods went from being 17% slower than pure SQLite to 2% slower.
A virtual table benchmark takes 35% less time. (Remember that benchmarks are best case!)
The shell JSON output modes have been fixed. Mode 'json' outputs a json array, while mode 'jsonl' does newline delimited json objects, aka json lines. (APSW issue 483)


(adam)
diff -r1.56 -r1.57 pkgsrc/databases/py-apsw/Makefile
diff -r1.33 -r1.34 pkgsrc/databases/py-apsw/distinfo

cvs diff -r1.56 -r1.57 pkgsrc/databases/py-apsw/Makefile (expand / switch to unified diff)

--- pkgsrc/databases/py-apsw/Makefile 2023/08/28 10:34:45 1.56
+++ pkgsrc/databases/py-apsw/Makefile 2023/09/27 15:17:05 1.57
@@ -1,16 +1,16 @@ @@ -1,16 +1,16 @@
1# $NetBSD: Makefile,v 1.56 2023/08/28 10:34:45 adam Exp $ 1# $NetBSD: Makefile,v 1.57 2023/09/27 15:17:05 adam Exp $
2 2
3DISTNAME= apsw-3.43.0.0 3DISTNAME= apsw-3.43.1.0
4PKGNAME= ${PYPKGPREFIX}-${DISTNAME:S/-r1//} 4PKGNAME= ${PYPKGPREFIX}-${DISTNAME:S/-r1//}
5CATEGORIES= databases python 5CATEGORIES= databases python
6MASTER_SITES= ${MASTER_SITE_GITHUB:=rogerbinns/} 6MASTER_SITES= ${MASTER_SITE_GITHUB:=rogerbinns/}
7EXTRACT_SUFX= .zip 7EXTRACT_SUFX= .zip
8GITHUB_PROJECT= apsw 8GITHUB_PROJECT= apsw
9GITHUB_RELEASE= ${PKGVERSION_NOREV} 9GITHUB_RELEASE= ${PKGVERSION_NOREV}
10 10
11MAINTAINER= rhialto@falu.nl 11MAINTAINER= rhialto@falu.nl
12HOMEPAGE= https://github.com/rogerbinns/apsw 12HOMEPAGE= https://github.com/rogerbinns/apsw
13COMMENT= Python wrapper for SQLite 13COMMENT= Python wrapper for SQLite
14LICENSE= zlib 14LICENSE= zlib
15 15
16PYSETUPBUILDARGS+= --enable=load_extension 16PYSETUPBUILDARGS+= --enable=load_extension

cvs diff -r1.33 -r1.34 pkgsrc/databases/py-apsw/distinfo (expand / switch to unified diff)

--- pkgsrc/databases/py-apsw/distinfo 2023/08/28 10:34:45 1.33
+++ pkgsrc/databases/py-apsw/distinfo 2023/09/27 15:17:05 1.34
@@ -1,5 +1,5 @@ @@ -1,5 +1,5 @@
1$NetBSD: distinfo,v 1.33 2023/08/28 10:34:45 adam Exp $ 1$NetBSD: distinfo,v 1.34 2023/09/27 15:17:05 adam Exp $
2 2
3BLAKE2s (apsw-3.43.0.0.zip) = 8fc8e1f0a15a75d7ce587cbfe6d8e932042ed7c8d28f5a3ffaef67a9c5488088 3BLAKE2s (apsw-3.43.1.0.zip) = 1f6a337315c25ba9590250d92568a6593af929d8a4f3b8e92dd29de900c925d3
4SHA512 (apsw-3.43.0.0.zip) = b2347302bcee5b2c595d1ae8e75e855f8a6be9c89a3db2293b3a40090412e26362ba85969abf70650c1dffb3e5b5d33499e0fa8d9f8d4910b9c68f4879956239 4SHA512 (apsw-3.43.1.0.zip) = 2ac78e2646490250352e39b32bf484264db6026c7b0152bd7f67e91745dc40631b09c53ac7ce7937198ac41e5d55981ef1b09190555c3569fc6319db4df87bd9
5Size (apsw-3.43.0.0.zip) = 4122382 bytes 5Size (apsw-3.43.1.0.zip) = 4136246 bytes