*** DRAFT ***

SQLite Release 3.41.0 On 2023-02-15

  1. Query planner improvements:
    1. Make use of indexed expressions within an aggregate query that includes a GROUP BY clause.
    2. The query planner has improved awareness of when an index is covering, and adjusts predicted runtimes accordingly.
    3. The query planner is more aggressive about using co-routines rather than materializing subqueries and views.
    4. Queries against the built-in table-valued functions json_tree() and json_each() will now usually treat "ORDER BY rowid" as a no-op.
  2. Add the built-in unhex() SQL function.
  3. Add the base64 and base85 application-defined functions as an extension and include that extension in the CLI.
  4. Add the sqlite3_stmt_scanstatus_v2() interface. (This interface is only available if SQLite is compiled using SQLITE_ENABLE_STMT_SCANSTATUS.)
  5. In-memory databases created using sqlite3_deserialize() now report their filename as an empty string, not as 'x'.
  6. The new makefile target "sqlite3r.c" builds an amalgamation that includes the recovery extension.
  7. Changes to the CLI:
    1. Add the new base64() and base85() SQL functions
    2. Enhanced EXPLAIN QUERY PLAN output using the new sqlite3_stmt_scanstatus_v2() interface when compiled using SQLITE_ENABLE_STMT_SCANSTATUS.
    3. The ".scanstats est" command provides query planner estimates in profiles.
    4. The continuation prompt indicates if the input is currently inside of a string literal, identifier literal, comment, trigger definition, etc.
    5. Enhance the --safe command-line option to disallow dangerous SQL functions.
  8. Enhance the PRAGMA integrity_check command so that it detects when text strings in a table are equivalent to but not byte-for-byte identical to the same strings in the index.
  9. Enhance the carray table-valued function so that it is able to bind an array of BLOB objects.
  10. Added the sqlite3_is_interrupted() interface.
  11. Long-running calls to sqlite3_prepare() and similar now invoke the progress handler callback and react to sqlite3_interrupt().
  12. The sqlite3_vtab_in_first() and sqlite3_vtab_in_next() functions are enhanced so that they reliably detect if they are invoked on a parameter that was not selected for multi-value IN processing using sqlite3_vtab_in(). They return SQLITE_ERROR instead of SQLITE_MISUSE in this case.
  13. Miscellaneous performance enhancements.

    Hashes:

  14. SQLITE_SOURCE_ID: pending
  15. SHA3-256 for sqlite3.c: pending

A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site.