SQLite Release 3.52.0
12 hours ago
- #Database
- #Release
- #SQLite
- SQLite Release 3.52.0 fixes the WAL-reset database corruption bug.
- Enhancements to ALTER TABLE allow adding and removing NOT NULL and CHECK constraints.
- Introduction of the Query Result Formatter (QRF) library for improved readability of SQL query results.
- New built-in SQL functions: json_array_insert() and jsonb_array_insert().
- Major CLI renovations including enhanced .mode command and improved result formatting with QRF.
- New C-language interfaces and SQLITE_PREPARE_FROM_DDL option for safer SQL statement preparation.
- Query planner improvements for better performance in EXCEPT, INTERSECT, UNION operations and join order selection.
- Floating-point to text conversions now round to 17 significant digits by default.
- TEMP triggers can now modify and query tables in the main schema.
- Discontinuation of support for Windows RT.