Log message:
sqlite3: updated to 3.33.0

SQLite Release 3.33.0

Support for UPDATE FROM following the PostgreSQL syntax.
Increase the maximum size of database files to 281 TB.
Extended the PRAGMA integrity_check statement so that it can optionally be \ 
limited to verifying just a single table and its indexes, rather than the entire \ 
database file.
Added the decimal extension for doing arbitrary-precision decimal arithmetic.
Enhancements to the ieee754 extension for working with IEEE 754 binary64 numbers.
CLI enhancements:
Added four new output modes: "box", "json", \ 
"markdown", and "table".
The "column" output mode automatically expands columns to contain the \ 
longest output row and automatically turns ".header" on if it has not \ 
been previously set.
The "quote" output mode honors ".separator"
The decimal extension and the ieee754 extension are built-in to the CLI
Query planner improvements:
Add the ability to find a full-index-scan query plan for queries using INDEXED \ 
BY which previously would fail with "no query solution".
Do a better job of detecting missing, incomplete, and/or dodgy sqlite_stat1 data \ 
and generates good query plans in spite of the misinformation.
Improved performance of queries like "SELECT min(x) FROM t WHERE y IN \ 
(?,?,?)" assuming an index on t(x,y).
In WAL mode, if a writer crashes and leaves the shm file in an inconsistent \ 
state, subsequent transactions are now able to recover the shm file even if \ 
there are active read transactions. Before this enhancement, shm file recovery \ 
that scenario would result in an SQLITE_PROTOCOL error.

Log message:
sqlite3: updated to 3.32.3

3.32.3:
Various minor bug fixes

Log message:
sqlite3: updated to 3.32.2

3.32.2:
Fix a long-standing bug in the byte-code engine that can cause a COMMIT command \ 
report as success when in fact it failed to commit.

Log message:
sqlite3: updated to 3.32.1

Changes in version 3.32.1:

Fix two long-standing bugs that allow malicious SQL statements to crash the \ 
process that is running SQLite. These bugs were announced by a third-party \ 
approximately 24 hours after the 3.32.0 release but are not specific to the \ 
3.32.0 release.

Other minor compiler-warning fixes and whatnot.

Log message:
sqlite3: updated to 3.32.0

SQLite Release 3.32.0:

Added support for approximate ANALYZE using the PRAGMA analysis_limit command.
Added the bytecode virtual table.
Add the checksum VFS shim to the set of run-time loadable extensions included in \ 
the source tree.
Added the iif() SQL function.
INSERT and UPDATE statements now always apply column affinity before computing \ 
CHECK constraints. This bug fix could, in theory, cause problems for legacy \ 
databases with unorthodox CHECK constraints the require the input type for an \ 
INSERT is different from the declared column type. See ticket 86ba67afafded936 \ 
for more information.
Added the sqlite3_create_filename(), sqlite3_free_filename(), and \ 
sqlite3_database_file_object() interfaces to better support of VFS shim \ 
implementations.
Increase the default upper bound on the number of parameters from 999 to 32766.
Added code for the UINT collating sequence as an optional loadable extension.
Enhancements to the CLI:
Add options to the .import command: --csv, --ascii, --skip
The .dump command now accepts multiple LIKE-pattern arguments and outputs the \ 
union of all matching tables.
Add the .oom command in debugging builds
Add the --bom option to the .excel, .output, and .once commands.
Enhance the .filectrl command to support the --schema option.
The UINT collating sequence extension is automatically loaded
The ESCAPE clause of a LIKE operator now overrides wildcard characters, so that \ 
the behavior now matches what PostgreSQL does.

Log message:
devel/lemon: fix typo in SUBST_FILES

Log message:
sqlite3: updated to 3.31.1

SQLite Release 3.31.1:

Revert the data layout for an internal-use-only SQLite data structure. \ 
Applications that use SQLite should never reference internal SQLite data \ 
structures, but some do anyhow, and a change to one such data structure in \ 
3.30.0 broke a popular and widely-deployed application. Reverting that change in \ 
SQLite, at least temporarily, gives developers of misbehaving applications time \ 
to fix their code.
Fix a typos in the sqlite3ext.h header file that prevented the \ 
sqlite3_stmt_isexplain() and sqlite3_value_frombind() interfaces from being \ 
called from run-time loadable extensions.

Log message:
all: migrate homepages from http to https

pkglint -r --network --only "migrate"

As a side-effect of migrating the homepages, pkglint also fixed a few
indentations in unrelated lines. These and the new homepages have been
checked manually.

Log message:
sqlite3: updated to 3.31.0

SQLite Release 3.31.0:

Add support for generated columns.
Add the sqlite3_hard_heap_limit64() interface and the corresponding PRAGMA \ 
hard_heap_limit command.
Enhance the function_list pragma to show the number of arguments on each \ 
function, the type of function (scalar, aggregate, window), and the function \ 
property flags SQLITE_DETERMINISTIC, SQLITE_DIRECTONLY, SQLITE_INNOCUOUS, and/or \ 
SQLITE_SUBTYPE.
Add the aggregated mode feature to the DBSTAT virtual table.
Add the SQLITE_OPEN_NOFOLLOW option to sqlite3_open_v2() that prevents SQLite \ 
from opening symbolic links.
Added the "#-N" array notation for JSON function path arguments.
Added the SQLITE_DBCONFIG_TRUSTED_SCHEMA connection setting which is also \ 
controllable via the new trusted_schema pragma and at compile-time using the \ 
-DSQLITE_TRUSTED_SCHEMA compile-time option.
Added APIs sqlite3_filename_database(), sqlite3_filename_journal(), and \ 
sqlite3_filename_wal() which are useful for specialized extensions.
Add the sqlite3_uri_key() interface.
Upgraded the sqlite3_uri_parameter() function so that it works with the rollback \ 
journal or WAL filename in addition to the database filename.
Provide the ability to tag application-defined SQL functions with new properties \ 
SQLITE_INNOCUOUS or SQLITE_DIRECTONLY.
Add new verbs to sqlite3_vtab_config() so that the xConnect method of virtual \ 
tables can declare the virtual table as SQLITE_VTAB_INNOCUOUS or \ 
SQLITE_VTAB_DIRECTONLY.
Faster response to sqlite3_interrupt().
Added the uuid.c extension module implementing functions for processing RFC-4122 \ 
UUIDs.
The lookaside memory allocator is enhanced to support two separate memory pools \ 
with different sized allocations in each pool. This allows more memory \ 
allocations to be covered by lookaside while at the same time reducing the heap \ 
memory usage to 48KB per connection, down from 120KB.
The legacy_file_format pragma is deactivated. It is now a no-op. In its place, \ 
the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config() is \ 
provided. The legacy_file_format pragma is deactivated because (1) it is rarely \ 
useful and (2) it is incompatible with VACUUM in schemas that have tables with \ 
both generated columns and descending indexes.

Log message:
sqlite3: updated to 3.30.1

SQLite Release 3.30.1:
Fix a bug in the query flattener that might cause a segfault for nested queries \ 
that use the new FILTER clause on aggregate functions.
Cherrypick fixes for other obscure problems found since the 3.30.0 release.