SQLite 3.54.0 is now out for the ubiquitous embedded SQL engine that powers everything from browsers to IoT gateways. This release focuses on a stronger command-line interface, better query planning, and finally drops Windows XP support.
What’s new in SQLite 3.54.0
According to the official release notes, the biggest changes are around the sqlite3 CLI:
- Significant enhancements to the command-line interface (
sqlite3/sqlite3.exe) - A new
.diskusedmeta-command to analyze database disk usage - The standalone
sqlite3_analyzerutility is now deprecated and included here for the last time - Various query planner improvements and performance tweaks
- “Countless” fixes for AI-discovered bugs in the engine
For embedded and desktop developers, the new .diskused command means you can inspect how tables and indexes occupy storage directly from the CLI, without shipping an extra analyzer binary alongside your firmware or application.
End of Windows XP support
Starting with 3.54.0, SQLite will no longer compile on Windows versions prior to Vista. The project has switched to Slim Reader/Writer Locks (SRWLs) for better synchronization performance, but these APIs simply don’t exist on Windows XP and older.
If you still maintain legacy systems on XP, you’ll need to stay on an older SQLite branch or upgrade the OS. For everyone else, 3.54.0 is a straightforward drop-in upgrade with better performance and tooling, while keeping the same lightweight footprint that makes SQLite so popular in embedded projects.
