SQLite Release 3.53.0
4 hours ago
- #Release Notes
- #SQLite
- #Database
- Fixed WAL-reset database corruption bug.
- Added Query Result Formatter (QRF) for human-readable query results, integrated with CLI and TCL.
- Enhanced ALTER TABLE to add/remove NOT NULL and CHECK constraints.
- Introduced REINDEX EXPRESSIONS to rebuild expression indexes.
- Allowed TEMP triggers to modify/query tables in main schema.
- Improved VACUUM INTO with URI filename reserve parameter support.
- Added new SQL functions json_array_insert() and jsonb_array_insert().
- Enhanced CLI with major improvements to .mode command and result formatting via QRF.
- New C-language interfaces including sqlite3_str_truncate() and sqlite3changegroup APIs.
- Query planner improvements for EXCEPT/INTERSECT/UNION and join optimizations.
- Enhanced floating-point to text conversions with default 17 significant digits.
- Added self-healing index feature for stale expression indexes.
- Added "-p|--port" option to sqlite3_rsync.
- Discontinued support for Windows RT.
- Introduced "opfs-wl" VFS for JavaScript/WASM with Web Locks.