SQLite 3.53 just came out a couple of months ago. Among its features is "Enhance ALTER TABLE to permit adding and removing NOT NULL and CHECK constraints," which is very nice to have for some use cases. Other use cases might find the new json_array_insert and jsonb_array_insert functions useful.
It would be nice to update the embedded SQLite in the repo so that fewer people will need to run jpm run update-sqlite3 to have access to the new ALTER TABLE functionality (and many other features).
SQLite 3.53 just came out a couple of months ago. Among its features is "Enhance ALTER TABLE to permit adding and removing NOT NULL and CHECK constraints," which is very nice to have for some use cases. Other use cases might find the new
json_array_insertandjsonb_array_insertfunctions useful.It would be nice to update the embedded SQLite in the repo so that fewer people will need to run
jpm run update-sqlite3to have access to the new ALTER TABLE functionality (and many other features).