r/sqlite • u/fdelux6 • Oct 10 '26
SQLite 3.54.0 released
Release log: https://sqlite.org/releaselog/3_54_0.html
Some items that stood out to me:
About 4% faster on speedtest1, and about 7.5% faster than 3.51.0 from a year ago
CLI now shows column headers by default even when a query returns no rows
.diskusedis now built into the CLI, and sqlite3_analyzer is deprecatedNew %j and %J conversions in printf() and format() for JSON string literals
UPDATE skips expression indexes when the indexed value is unchanged
65
Upvotes
3
10
u/jhulc Oct 10 '26 edited Oct 11 '26
This version also contains a LOT of (mostly very obscure) bug fixes, driven by AI agents. If you look through the commit log, you can see that the SQLite devs have been landing a handful of patches every day prompted by people using AI tools to make reports in the bug forum. These are almost all fixes for incredibly unlikely scenarios, but the volume of them is quite surprising given SQLite's reputation for code quality and testing.