SQLite 3.53.0

# SQLite 3.53.0 Source: https://simonwillison.net/2026/Apr/11/sqlite/ 11th April 2026 \- Link Blog **SQLite 3\.53\.0 (https://sqlite.org/releaselog/3_53_0.html)**\(via (https://lobste.rs/s/sqsb24/sqlite_3_53_0)\) SQLite 3\.52\.0 was withdrawn so this is a pretty big release with a whole lot of accumulated user\-facing and internal improvements\. Some that stood out to me: - `ALTER TABLE`can now add and remove`NOT NULL`and`CHECK`constraints \- I've previously used my ownsqlite\-utils transform\(\) method (https://sqlite-utils.datasette.io/en/stable/python-api.html#changing-not-null-status)for this\. - Newjson\_array\_insert\(\) function (https://sqlite.org/json1.html#jarrayins)and its`jsonb`equivalent\. - Significant improvements toCLI mode (https://sqlite.org/climode.html), including result formatting\. The result formatting improvements come from a new library, theQuery Results Formatter (https://sqlite.org/src/file/ext/qrf)\. Ihad Claude Code (https://github.com/simonw/tools/pull/266)\(on my phone\) compile that to WebAssembly and buildthis playground interface (https://tools.simonwillison.net/sqlite-qrf)for trying that out\. Posted11th April 2026 (https://simonwillison.net/2026/Apr/11/)at 7:56 pm ## Recent articles - Changes in the system prompt between Claude Opus 4\.6 and 4\.7 (https://simonwillison.net/2026/Apr/18/opus-system-prompt/)\- 18th April 2026 - Join us at PyCon US 2026 in Long Beach \- we have new AI and security tracks this year (https://simonwillison.net/2026/Apr/17/pycon-us-2026/)\- 17th April 2026 - Qwen3\.6\-35B\-A3B on my laptop drew me a better pelican than Claude Opus 4\.7 (https://simonwillison.net/2026/Apr/16/qwen-beats-opus/)\- 16th April 2026 This is a**link post**by Simon Willison, posted on11th April 2026 (https://simonwillison.net/2026/Apr/11/)\. sql112 (https://simonwillison.net/tags/sql/)sqlite459 (https://simonwillison.net/tags/sqlite/) ### Monthly briefing Sponsor me for**$10/month**and get a curated email digest of the month's most important LLM developments\. Pay me to send you less\! Sponsor & subscribe (https://github.com/sponsors/simonw/)