SQLite 3.53.0 ships with a critical WAL-reset database corruption bug fix, new SQL language features including ALTER TABLE support for adding/removing NOT NULL and CHECK constraints, REINDEX EXPRESSIONS, and new json_array_insert()/jsonb_array_insert() functions. The CLI gets a major overhaul with Unicode box-drawing output, improved .mode command, and QRF (Query Result Formatter) integration. Query planner improvements include better join order selection for star schemas and enhanced EXISTS-to-JOIN optimization. New C-language interfaces are added, floating-point to text conversion now defaults to 17 significant digits (up from 15), a self-healing index feature addresses stale expression indexes, and a new WASM 'opfs-wl' VFS using Web Locks is introduced. Windows RT support is discontinued.
Sort: