*** DRAFT ***

SQLite Release 3.54.0 On 2026-10-15

  1. Drop support for WindowsXP and earlier Windows versions, including WindowsCE. SQLite now requires Windows Vista or later.
    1. 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.
    2. Use the -DSQLITE_UWP=1 compile-time option for UWP and WebUI applications.
  2. Add the diskused() SQL function as an optional extension.
  3. CLI enhancements:
    1. Use the new diskused() extension to implement the ".diskused" dot-command. The replaces the separate sqlite3_analyzer utility program, which is now deprecated.
    2. 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.
    3. The default CLI prompt has been enhanced to take advantage of the new escape sequences described in the previous.
    4. On unix, the CLI preserves zero bytes when outputing unformatted BLOB values.
    5. The -csv command-line option automatically disables display limits, for legacy compatibility.
  4. Added the %J and %j conversions used to render JSON string literals to the built-in printf() and the format() SQL function.
  5. Use O_TMPFILE when generating temporary files, on systems that support that feature.
  6. Query planner improvements:
    1. When doing an UPDATE on a table that has expression indexes, do not change the expression index if the value being indexed is unchanged.
  7. Performance enhancements in the substr() and length() SQL functions.

    Hashes:

  8. SQLITE_SOURCE_ID: pending
  9. 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.

*** DRAFT ***