SQLite 3.54.0 Released

SQLite 3.54.0, dated 2026-10-09, introduces a series of command-line, SQL, and platform improvements. The CLI gains prompt escape sequences driven by SQLITE_PS1/PS2, a smarter default prompt that respects NO_COLOR, better columnar output headers when queries return no rows, preserved zero bytes for BLOB output on Unix, and new .mode options ("rowcount on", "titles always" now default) plus printf-style ifmt and fpfmt formatters. A new diskused() extension replaces and deprecates the sqlite3_analyzer utility, and -csv now disables display limits for legacy behavior. The CLI no longer accepts single-line terminators "go" or "/" unless compiled with a legacy flag.

Query planning and core APIs were optimized and expanded: expression indexes avoid unnecessary updates, OR-constant optimizations and DISTINCT-ignored-IN-side improvements reduce work, and UNION with LIMIT 1 uses less memory. ALTER TABLE will error if attempting to add/drop/rename columns named ROWID/_ROWID_/OID. New additions include diskused() SQL function, %J/%j JSON conversions for printf/format, sqlite3_result_str(), sqlite3_incomplete(), weekday -N and an "end of" date modifier, O_TMPFILE for temp files, and two new sqlite3_limit constants. Windows builds drop XP/CE support (Vista+ required), switch to SRWLs for mutexes, and add -DSQLITE_UWP=1. Measured performance improved roughly 4% versus recent benchmarks and about 7.5% since v3.51.0. HASHES and source-id are provided for verification.