CVS commit: pkgsrc

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Mon Oct 12 11:44:54 UTC 2026

Modified Files:
        pkgsrc/databases/sqlite3: Makefile.common distinfo
        pkgsrc/databases/sqlite3-diff: distinfo
        pkgsrc/databases/sqlite3-docs: PLIST distinfo
        pkgsrc/databases/sqlite3-tcl: distinfo
        pkgsrc/devel/lemon: distinfo

Log Message:
sqlite3: updated to 3.54.0

3.54.0

CLI enhancements:
CLI prompt strings may contain escape sequences that expand to show state information. The initial CLI prompt is now be initialized the values of the SQLITE_PS1 and SQLITE_PS2 environment variables, 
if those variables exist.
The default CLI prompt has been enhanced to take advantage of the new escape sequences described in the previous.
For columnar output modes, the CLI now shows the column name header by default even if the query returns no rows.
Use the new diskused() extension to implement the ".diskused" dot-command. The replaces the separate sqlite3_analyzer utility program, which is now deprecated.
On unix, the CLI preserves zero bytes when outputing unformatted BLOB values.
Enhance the .mode command with new options "--rowcount on" and "--titles always". The "--titles always" is now the default behavior (see item 3a above). Legacy behavior can be restored using "-titles 
on".
Enhance the .mode command with the new --ifmt option and --fpfmt option that allow the rendering of integer and floating-point values to be more precisely controlled using a printf-style format 
string.
The -csv command-line option automatically disables display limits, for legacy compatibility.
The default CLI prompt honors the NO_COLOR environment variable.
The ability to end an SQL command using the line that contains just "go" or "/" (for compatibility with SQL Server and Oracle, respectively) is discontinued, unless the CLI is compiled with option 
-DSQLITE_SHELL_LEGACY_COMMAND_TERMINATOR.
Query planner improvements:
When doing an UPDATE on a table that has expression indexes, do not change the expression index if the value being indexed is unchanged.
Improved optimization of "expr OR TRUE" and "expr OR FALSE".
Ignore DISTINCT in the SELECT statement on the right-hand side of an IN operator.
UNION queries with a LIMIT of exactly 1 are now handled faster and with less memory.
The ALTER TABLE command raises an error on any attempt to add, drop, or rename columns with the special names "ROWID", "_ROWID_", or "OID".
Add the diskused() SQL function as an optional extension.
Added the %J and %j conversions used to render JSON string literals to the built-in printf() and the format() SQL function.
Add the sqlite3_result_str() interface and use it internally to simplify the code.
Add the sqlite3_incomplete() interface and use it as part of the newly enhanced CLI prompt string management.
Enhancements to date/time functions:
Added the "weekday -N" form of the weekday modifier.
Added the end of modifier.
Use O_TMPFILE when generating temporary files, on systems that support that feature.
Drop support for WindowsXP and earlier Windows versions, including WindowsCE. SQLite for Windows now requires Windows Vista (circa 2007) or later.
Improve performance by using Slim Reader/Writer Locks (SRWLs) to implement non-recursive mutexes, instead of CriticalSection, since all supported Windows platforms now provide SRWLs.
Use the -DSQLITE_UWP=1 compile-time option for UWP and WebUI applications.
To be clear: This changes above only affects SQLite on Windows. Builds for Linux, Mac, BSD, and other unix variants are unaffected.
The authorizer callback is now invoked for SQL functions found in the DEFAULT clauses of CREATE TABLE statements. This happens both when the CREATE TABLE statement is first issued and when the 
DEFAULT value is actually used, but not when reading the schema while opening a database.
Added SQLITE_LIMIT_SCHEMA and SQLITE_LIMIT_TRIGGER_STEPS to the sqlite3_limit() interface.
About 4% faster, as measured by counting CPU cycles in the speedtest1 preformance benchmark using valgrind on Linux x64. About 7.5% faster compared to one year ago (version 3.51.0). Your mileage may 
vary depending on workload, build options, CPU, compiler, and operating system.


To generate a diff of this commit:
cvs rdiff -u -r1.134 -r1.135 pkgsrc/databases/sqlite3/Makefile.common
cvs rdiff -u -r1.226 -r1.227 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.14 -r1.15 pkgsrc/databases/sqlite3-diff/distinfo
cvs rdiff -u -r1.154 -r1.155 pkgsrc/databases/sqlite3-docs/PLIST
cvs rdiff -u -r1.157 -r1.158 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.171 -r1.172 pkgsrc/databases/sqlite3-tcl/distinfo
cvs rdiff -u -r1.98 -r1.99 pkgsrc/devel/lemon/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/sqlite3/Makefile.common
diff -u pkgsrc/databases/sqlite3/Makefile.common:1.134 pkgsrc/databases/sqlite3/Makefile.common:1.135
--- pkgsrc/databases/sqlite3/Makefile.common:1.134      Sat Aug  1 13:45:51 2026
+++ pkgsrc/databases/sqlite3/Makefile.common    Mon Oct 12 11:44:53 2026
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.134 2026/08/01 13:45:51 adam Exp $
+# $NetBSD: Makefile.common,v 1.135 2026/10/12 11:44:53 adam Exp $
 #
 # used by databases/sqlite3/Makefile
 # used by databases/sqlite3-diff/Makefile -- please `bmake makesum` there
@@ -6,8 +6,8 @@
 # used by databases/sqlite3-tcl/Makefile
 # used by devel/lemon/Makefile
 
-SQLITE3_DISTVERSION=   3530400
-SQLITE3_VERSION=       3.53.4
+SQLITE3_DISTVERSION=   3540000
+SQLITE3_VERSION=       3.54.0
 
 MASTER_SITES=  https://www.sqlite.org/2026/
 

Index: pkgsrc/databases/sqlite3/distinfo
diff -u pkgsrc/databases/sqlite3/distinfo:1.226 pkgsrc/databases/sqlite3/distinfo:1.227
--- pkgsrc/databases/sqlite3/distinfo:1.226     Sat Aug  1 13:45:51 2026
+++ pkgsrc/databases/sqlite3/distinfo   Mon Oct 12 11:44:53 2026
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.226 2026/08/01 13:45:51 adam Exp $
+$NetBSD: distinfo,v 1.227 2026/10/12 11:44:53 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3530400.tar.gz) = 649b9187e7cb2e64a54ce51dc1c4111c4f493d3523dd87e9008e090309b0da9d
-SHA512 (sqlite-autoconf-3530400.tar.gz) = c24374e9393a943157f533f96e89e6c5743e5f5aad169d8393cff3088ca5ccbe5cc0561681ace49c349d0fe402298ee2624d319f422967247ce0792e3b3aa01e
-Size (sqlite-autoconf-3530400.tar.gz) = 3283177 bytes
+BLAKE2s (sqlite-autoconf-3540000.tar.gz) = 71e0e2dc513a2a1e3728d2eed1d4d1507bce71883e436f45aed2aaf534fc3b52
+SHA512 (sqlite-autoconf-3540000.tar.gz) = b54e6329627990ad567d948c9a29abbc8178c4dfd6c1aa3923684827aa0830df2cef06b94ddfd0496293b0c503d981ef0b62fd2044abbee887012107d405c366
+Size (sqlite-autoconf-3540000.tar.gz) = 3332512 bytes
 SHA1 (patch-autosetup_proj.tcl) = b0e8241e57e82a1dadd721a64128f62e7409f600

Index: pkgsrc/databases/sqlite3-diff/distinfo
diff -u pkgsrc/databases/sqlite3-diff/distinfo:1.14 pkgsrc/databases/sqlite3-diff/distinfo:1.15
--- pkgsrc/databases/sqlite3-diff/distinfo:1.14 Sat Aug  1 13:45:51 2026
+++ pkgsrc/databases/sqlite3-diff/distinfo      Mon Oct 12 11:44:54 2026
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.14 2026/08/01 13:45:51 adam Exp $
+$NetBSD: distinfo,v 1.15 2026/10/12 11:44:54 adam Exp $
 
-BLAKE2s (sqlite-src-3530400.zip) = d88aa5d755b5c8c809574bc7f3e7acdcb715948557191b1a8e8e609bdd5f5477
-SHA512 (sqlite-src-3530400.zip) = 4530f39a68e4e32460fc2656bc3ad9d8d73394390cb5c6668ff0755cb50d39219035677994d65078ad45ad126256c8c4e6a91afc5fcbc321883c805b11e7754e
-Size (sqlite-src-3530400.zip) = 14557315 bytes
+BLAKE2s (sqlite-src-3540000.zip) = 83430f0ea7fc2943efb70defdb34fe34227e9f0e65372364a437c0c041d90eaa
+SHA512 (sqlite-src-3540000.zip) = f0eb165c62481e661c5d8c90d4f992544022cf5711d5428a9ada11fa889112ba75b59a6fea3d973200b9ce078ae94a528787fba0523f1060e7133fb398c1ac46
+Size (sqlite-src-3540000.zip) = 14881448 bytes

Index: pkgsrc/databases/sqlite3-docs/PLIST
diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.154 pkgsrc/databases/sqlite3-docs/PLIST:1.155
--- pkgsrc/databases/sqlite3-docs/PLIST:1.154   Sat Aug  1 13:45:51 2026
+++ pkgsrc/databases/sqlite3-docs/PLIST Mon Oct 12 11:44:54 2026
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.154 2026/08/01 13:45:51 adam Exp $
+@comment $NetBSD: PLIST,v 1.155 2026/10/12 11:44:54 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -47,6 +47,7 @@ share/doc/sqlite3/c3ref/c_blob.html
 share/doc/sqlite3/c3ref/c_carray_blob.html
 share/doc/sqlite3/c3ref/c_checkpoint_full.html
 share/doc/sqlite3/c3ref/c_config_covering_index_scan.html
+share/doc/sqlite3/c3ref/c_copy.html
 share/doc/sqlite3/c3ref/c_dbconfig_defensive.html
 share/doc/sqlite3/c3ref/c_dbstatus_options.html
 share/doc/sqlite3/c3ref/c_deny.html
@@ -170,6 +171,7 @@ share/doc/sqlite3/c3ref/release_memory.h
 share/doc/sqlite3/c3ref/reset.html
 share/doc/sqlite3/c3ref/reset_auto_extension.html
 share/doc/sqlite3/c3ref/result_blob.html
+share/doc/sqlite3/c3ref/result_str.html
 share/doc/sqlite3/c3ref/result_subtype.html
 share/doc/sqlite3/c3ref/serialize.html
 share/doc/sqlite3/c3ref/set_authorizer.html
@@ -247,6 +249,7 @@ share/doc/sqlite3/cintro.html
 share/doc/sqlite3/cksumvfs.html
 share/doc/sqlite3/cli.html
 share/doc/sqlite3/climode.html
+share/doc/sqlite3/cliprompt.html
 share/doc/sqlite3/codeofconduct.html
 share/doc/sqlite3/codeofethics.html
 share/doc/sqlite3/compile.html
@@ -271,6 +274,7 @@ share/doc/sqlite3/dbstat.html
 share/doc/sqlite3/debugging.html
 share/doc/sqlite3/deterministic.html
 share/doc/sqlite3/different.html
+share/doc/sqlite3/diskusedfunc.html
 share/doc/sqlite3/doc_backlink_crossref.html
 share/doc/sqlite3/doc_keyword_crossref.html
 share/doc/sqlite3/doc_pagelink_crossref.html
@@ -414,14 +418,13 @@ share/doc/sqlite3/images/foreignlogos/or
 share/doc/sqlite3/images/foreignlogos/philips.gif
 share/doc/sqlite3/images/foreignlogos/php.gif
 share/doc/sqlite3/images/foreignlogos/python.gif
+share/doc/sqlite3/images/foreignlogos/reportr.png
 share/doc/sqlite3/images/foreignlogos/rpm_logo.png
 share/doc/sqlite3/images/foreignlogos/skype.gif
 share/doc/sqlite3/images/foreignlogos/sony.gif
 share/doc/sqlite3/images/foreignlogos/sunmicro.gif
 share/doc/sqlite3/images/foreignlogos/symbian.gif
 share/doc/sqlite3/images/foreignlogos/tcl.gif
-share/doc/sqlite3/images/foreignlogos/visualdb-txt.png
-share/doc/sqlite3/images/foreignlogos/visualdb.png
 share/doc/sqlite3/images/foreignlogos/xojo.png
 share/doc/sqlite3/images/fts3_doclist.png
 share/doc/sqlite3/images/fts3_doclist.svg
@@ -730,6 +733,7 @@ share/doc/sqlite3/releaselog/3_53_1.html
 share/doc/sqlite3/releaselog/3_53_2.html
 share/doc/sqlite3/releaselog/3_53_3.html
 share/doc/sqlite3/releaselog/3_53_4.html
+share/doc/sqlite3/releaselog/3_54_0.html
 share/doc/sqlite3/releaselog/3_5_0.html
 share/doc/sqlite3/releaselog/3_5_1.html
 share/doc/sqlite3/releaselog/3_5_2.html
@@ -1011,6 +1015,10 @@ share/doc/sqlite3/unlock_notify.html
 share/doc/sqlite3/uri.html
 share/doc/sqlite3/useovernet.html
 share/doc/sqlite3/vdbe.html
+share/doc/sqlite3/vec1.html
+share/doc/sqlite3/vec1bench.html
+share/doc/sqlite3/vec1doc.html
+share/doc/sqlite3/vec1ref.html
 share/doc/sqlite3/version3.html
 share/doc/sqlite3/versionnumbers.html
 share/doc/sqlite3/vfs.html

Index: pkgsrc/databases/sqlite3-docs/distinfo
diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.157 pkgsrc/databases/sqlite3-docs/distinfo:1.158
--- pkgsrc/databases/sqlite3-docs/distinfo:1.157        Sat Aug  1 13:45:51 2026
+++ pkgsrc/databases/sqlite3-docs/distinfo      Mon Oct 12 11:44:54 2026
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.157 2026/08/01 13:45:51 adam Exp $
+$NetBSD: distinfo,v 1.158 2026/10/12 11:44:54 adam Exp $
 
-BLAKE2s (sqlite-doc-3530400.zip) = 99f700be5b86b9360bbf95ff3911e26f76b58c263d4b7fcd6d85d459ec8a179e
-SHA512 (sqlite-doc-3530400.zip) = b0a07be9b7110f141ebf87c6ded540b61e8bc734dd953d94fd363e79f60460f754ed8dbaa0daa8ec81315dcab6edc7b4c253139627af33092eae49cc8f9cf058
-Size (sqlite-doc-3530400.zip) = 11820412 bytes
+BLAKE2s (sqlite-doc-3540000.zip) = ab4e7c62f47ddf99891bcecdb021bcd2dd2f5e8f376a42fe174527bbd68b19d6
+SHA512 (sqlite-doc-3540000.zip) = 391e5edb9186d16588bada3eb2fbb2d78841db1080aad80cfe83d89fb53aa582b7b7c62b178bc907b51acba5c36f0d76608f473a143a3933ef106d61c1837a8f
+Size (sqlite-doc-3540000.zip) = 11954925 bytes

Index: pkgsrc/databases/sqlite3-tcl/distinfo
diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.171 pkgsrc/databases/sqlite3-tcl/distinfo:1.172
--- pkgsrc/databases/sqlite3-tcl/distinfo:1.171 Sat Aug  1 13:45:51 2026
+++ pkgsrc/databases/sqlite3-tcl/distinfo       Mon Oct 12 11:44:54 2026
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.171 2026/08/01 13:45:51 adam Exp $
+$NetBSD: distinfo,v 1.172 2026/10/12 11:44:54 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3530400.tar.gz) = 649b9187e7cb2e64a54ce51dc1c4111c4f493d3523dd87e9008e090309b0da9d
-SHA512 (sqlite-autoconf-3530400.tar.gz) = c24374e9393a943157f533f96e89e6c5743e5f5aad169d8393cff3088ca5ccbe5cc0561681ace49c349d0fe402298ee2624d319f422967247ce0792e3b3aa01e
-Size (sqlite-autoconf-3530400.tar.gz) = 3283177 bytes
+BLAKE2s (sqlite-autoconf-3540000.tar.gz) = 71e0e2dc513a2a1e3728d2eed1d4d1507bce71883e436f45aed2aaf534fc3b52
+SHA512 (sqlite-autoconf-3540000.tar.gz) = b54e6329627990ad567d948c9a29abbc8178c4dfd6c1aa3923684827aa0830df2cef06b94ddfd0496293b0c503d981ef0b62fd2044abbee887012107d405c366
+Size (sqlite-autoconf-3540000.tar.gz) = 3332512 bytes

Index: pkgsrc/devel/lemon/distinfo
diff -u pkgsrc/devel/lemon/distinfo:1.98 pkgsrc/devel/lemon/distinfo:1.99
--- pkgsrc/devel/lemon/distinfo:1.98    Sat Aug  1 13:45:51 2026
+++ pkgsrc/devel/lemon/distinfo Mon Oct 12 11:44:54 2026
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.98 2026/08/01 13:45:51 adam Exp $
+$NetBSD: distinfo,v 1.99 2026/10/12 11:44:54 adam Exp $
 
-BLAKE2s (sqlite-src-3530400.zip) = d88aa5d755b5c8c809574bc7f3e7acdcb715948557191b1a8e8e609bdd5f5477
-SHA512 (sqlite-src-3530400.zip) = 4530f39a68e4e32460fc2656bc3ad9d8d73394390cb5c6668ff0755cb50d39219035677994d65078ad45ad126256c8c4e6a91afc5fcbc321883c805b11e7754e
-Size (sqlite-src-3530400.zip) = 14557315 bytes
+BLAKE2s (sqlite-src-3540000.zip) = 83430f0ea7fc2943efb70defdb34fe34227e9f0e65372364a437c0c041d90eaa
+SHA512 (sqlite-src-3540000.zip) = f0eb165c62481e661c5d8c90d4f992544022cf5711d5428a9ada11fa889112ba75b59a6fea3d973200b9ce078ae94a528787fba0523f1060e7133fb398c1ac46
+Size (sqlite-src-3540000.zip) = 14881448 bytes