SQLite 3.53 fixes WAL-reset bug, adds QRF library, new SQL features, improved CLI and more

SQLite 3.53 has been released as the latest version of this free and open-source relational database engine. This update addresses a critical stability issue by fixing the longstanding database corruption bug related to Write-Ahead Logging (WAL) reset. This release also adds the Query Result Formatter library, allowing users to format SQL query output for better readability on fixed-pitch font screens.

Building on these improvements, the update introduces several SQL language enhancements, including new capabilities within ALTER TABLE, expanded use of REINDEX EXPRESSIONS, additional TEMP trigger support, and the VACUUM INTO option. Two new SQL functions, json_array_insert() and jsonb_array_insert(), advance the handling of JSON data inside the database. The command-line interface receives major enhancements, such as expanded functionality for the .mode command and better formatting of result sets.

In terms of developer tools and APIs, SQLite 3.53 provides new C-language interfaces, query planner updates, more granular control over session extension changes, and now supports improved conversions between floating-point numbers and text. While the self-healing index feature addresses stale expression index problems for better index reliability, platform compatibility changes include dropped support for Windows RT and the addition of a new port option to the sqlite3_rsync utility.

For JavaScript and WebAssembly applications, the introduction of the opfs-wl virtual file system leverages Web Locks for fairer lock management, requiring modern browser support for Atomics.waitAsync().