SQLite Launch 3.44.0 On 2023-11-01

Small. Quick. Dependable.
Select any three.

SQLite Launch 3.44.0 On 2023-11-01

1. Aggregate functions can now embody an ORDER BY clause after their final
   parameter. The arguments to the operate are processed within the order
   specified. This may be vital for capabilities like
   string_agg() and json_group_array().
2. Add help for the concat() and concat_ws() scalar SQL capabilities,
   appropriate with PostgreSQL, SQLServer, and MySQL.
3. Add help for the string_agg() combination SQL operate, appropriate
   with PostgreSQL and SQLServer.
4. New conversion letters on the strftime() SQL function: %e %F %I %okay %l %p %P %R %T %u
5. Add new C-language APIs: sqlite3_get_clientdata() and sqlite3_set_clientdata().
6. Many errors related to CREATE TABLE at the moment are raised when the CREATE TABLE assertion
   itself is run, moderately than being deferred till the primary time the desk is definitely
   used.
7. The PRAGMA integrity_check command now verifies the consistency of the
   content material in varied built-in virtual tables utilizing the brand new xIntegrity method.
   This works for the FTS3, FTS4, FTS5, RTREE, and GEOPOLY extensions.
8. The SQLITE_DBCONFIG_DEFENSIVE setting now prevents PRAGMA writable_schema
   from being turned on. Beforehand writable_schema may very well be turned on, however would
   not truly enable the schema to be writable. Now it merely can’t be turned on.
9. Tag the built-in FTS3, FTS4, FTS5, RTREE, and GEOPOLY digital tables as
   SQLITE_VTAB_INNOCUOUS in order that they can be utilized within triggers in
   high-security deployments.
10. The PRAGMA case_sensitive_like assertion is deprecated, as its use when the
    schema comprises LIKE operators can result in stories of database corruption
    by PRAGMA integrity_check.
11. SQLITE_USE_SEH (Structured Exception Dealing with) is now enabled by default every time
    SQLite is constructed utilizing the Microsoft C compiler. It may be disabled utilizing
    -DSQLITE_USE_SEH=0
12. Question planner optimizations:
    1. In partial index scans, if the WHERE clause implies a continuing worth for a desk
       column, substitute occurrences of that desk column with the fixed. This
       will increase the chance of the partial index being a masking index.
    2. Disable the view-scan optimization (added in version 3.42.0 – merchandise 1c)
       because it was inflicting a number of efficiency regressions. As a substitute, scale back
       the estimated row rely for DISTINCT subqueries by an element of 8.
13. SQLite now performs run-time detection of whether or not or not the underlying {hardware}
    helps “lengthy double” with precision higher than “double” and makes use of acceptable
    floating-point routines relying on what it found.
14. The CLI for Home windows now defaults to utilizing UTF-8 for each enter
    and output on platforms that help it. The –no-utf8 choice is on the market
    to disable UTF8 help.

    Hashes:

15. SQLITE_SOURCE_ID: 2023-11-01 11:23:50 17129ba1ff7f0daf37100ee82d507aef7827cf38de1866e2633096ae6ad8130
16. SHA3-256 for sqlite3.c: d9e6530096136067644b1cb2057b3b0fa51070df99ec61971f73c9ba6aa9a36e

A complete list of SQLite releases
in a single web page and a chronology are each additionally accessible.
An in depth historical past of each
check-in is on the market at

SQLite version control site.