SQLite 3.53.0
📰 Simon Willison's Blog
Learn about the new features in SQLite 3.53.0, including improved ALTER TABLE functionality and new JSON functions, and how to apply them in your projects
Action Steps
- Update to SQLite 3.53.0 to access new features
- Use the improved ALTER TABLE functionality to add and remove NOT NULL and CHECK constraints
- Explore the new json_array_insert() function and its jsonb equivalent
- Try out the improved CLI mode and result formatting
- Test the new Query Results Formatter library and its WebAssembly compilation
Who Needs to Know This
Developers and database administrators who work with SQLite can benefit from this update, as it provides new features and improvements to existing functionality, making their work more efficient
Key Insight
💡 SQLite 3.53.0 introduces significant improvements and new features, making it a worthwhile update for developers and database administrators
Share This
🚀 SQLite 3.53.0 is out! 🚀 Improved ALTER TABLE, new JSON functions, and more! 💻
Key Takeaways
Learn about the new features in SQLite 3.53.0, including improved ALTER TABLE functionality and new JSON functions, and how to apply them in your projects
Full Article
Title: SQLite 3.53.0
URL Source: https://simonwillison.net/2026/Apr/11/sqlite/
Published Time: Sat, 11 Apr 2026 20:00:35 GMT
Markdown Content:
# SQLite 3.53.0
# [Simon Willison’s Weblog](https://simonwillison.net/)
[Subscribe](https://simonwillison.net/about/#subscribe)
**Sponsored by:** Teleport — Connect agents to your infra in seconds with Teleport Beams. Built-in identity. Zero secrets. [Get early access](https://fandf.co/4tq0sbV)
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 "Lobste.rs")) 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 own [sqlite-utils transform() method](https://sqlite-utils.datasette.io/en/stable/python-api.html#changing-not-null-status) for this.
* New [json_array_insert() function](https://sqlite.org/json1.html#jarrayins) and its `jsonb` equivalent.
* Significant improvements to [CLI mode](https://sqlite.org/climode.html), including result formatting.
The result formatting improvements come from a new library, the [Query Results Formatter](https://sqlite.org/src/file/ext/qrf). I [had Claude Code](https://github.com/simonw/tools/pull/266) (on my phone) compile that to WebAssembly and build [this playground interface](https://tools.simonwillison.net/sqlite-qrf) for trying that out.
Posted [11th April 2026](https://simonwillison.net/2026/Apr/11/) at 7:56 pm
## Recent articles
* [Meta's new model is Muse Spark, and meta.ai chat has some interesting tools](https://simonwillison.net/2026/Apr/8/muse-spark/) - 8th April 2026
* [Anthropic's Project Glasswing - restricting Claude Mythos to security researchers - sounds necessary to me](https://simonwillison.net/2026/Apr/7/project-glasswing/) - 7th April 2026
* [The Axios supply chain attack used individually targeted social engineering](https://simonwillison.net/2026/Apr/3/supply-chain-social-engineering/) - 3rd April 2026
This is a **link post** by Simon Willison, posted on [11th April 2026](https://simonwillison.net/2026/Apr/11/).
[sql 112](https://simonwillison.net/tags/sql/)[sqlite 459](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/)
* [Disclosures](https://simonwillison.net/about/#disclosures)
* [Colophon](https://simonwillison.net/about/#about-site)
* ©
* [2002](https://simonwillison.net/2002/)
* [2003](https://simonwillison.net/2003/)
* [2004](https://simonwillison.net/2004/)
* [2005](https://simonwillison.net/2005/)
* [2006](https://simonwillison.net/2006/)
* [2007](https://simonwillison.net/2007/)
* [2008](https://simonwillison.net/2008/)
* [2009](https://simonwillison.net/2009/)
* [2010](https://simonwillison.net/2010/)
* [2011](https://simonwillison.net/2011/)
* [2012](https://simonwillison.net/2012/)
* [2013](https://simonwillison.net/2013/)
* [2014](https://simonwillison.net/2014/)
* [2015](https://simonwillison.net/2015/)
* [2016](https://simonwillison.net/2016/)
* [2017](https://simonwillison.net/2017/)
* [2018](https://simonwillison.net/2018/)
* [2019](https://simonwillison.net/2019/)
* [2020](https://simonwillison.net/2020/)
* [2021](https://simonwillison.net/2021/)
* [2022](https://simonwillison.net/2022/)
* [2023](https://simonwillison.net/2023/)
* [2024](https://simonwillison.net/2024/)
* [2025](https://simonwillison.net/2025/)
* [2026](https://simonwillison.net/2026/)
URL Source: https://simonwillison.net/2026/Apr/11/sqlite/
Published Time: Sat, 11 Apr 2026 20:00:35 GMT
Markdown Content:
# SQLite 3.53.0
# [Simon Willison’s Weblog](https://simonwillison.net/)
[Subscribe](https://simonwillison.net/about/#subscribe)
**Sponsored by:** Teleport — Connect agents to your infra in seconds with Teleport Beams. Built-in identity. Zero secrets. [Get early access](https://fandf.co/4tq0sbV)
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 "Lobste.rs")) 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 own [sqlite-utils transform() method](https://sqlite-utils.datasette.io/en/stable/python-api.html#changing-not-null-status) for this.
* New [json_array_insert() function](https://sqlite.org/json1.html#jarrayins) and its `jsonb` equivalent.
* Significant improvements to [CLI mode](https://sqlite.org/climode.html), including result formatting.
The result formatting improvements come from a new library, the [Query Results Formatter](https://sqlite.org/src/file/ext/qrf). I [had Claude Code](https://github.com/simonw/tools/pull/266) (on my phone) compile that to WebAssembly and build [this playground interface](https://tools.simonwillison.net/sqlite-qrf) for trying that out.
Posted [11th April 2026](https://simonwillison.net/2026/Apr/11/) at 7:56 pm
## Recent articles
* [Meta's new model is Muse Spark, and meta.ai chat has some interesting tools](https://simonwillison.net/2026/Apr/8/muse-spark/) - 8th April 2026
* [Anthropic's Project Glasswing - restricting Claude Mythos to security researchers - sounds necessary to me](https://simonwillison.net/2026/Apr/7/project-glasswing/) - 7th April 2026
* [The Axios supply chain attack used individually targeted social engineering](https://simonwillison.net/2026/Apr/3/supply-chain-social-engineering/) - 3rd April 2026
This is a **link post** by Simon Willison, posted on [11th April 2026](https://simonwillison.net/2026/Apr/11/).
[sql 112](https://simonwillison.net/tags/sql/)[sqlite 459](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/)
* [Disclosures](https://simonwillison.net/about/#disclosures)
* [Colophon](https://simonwillison.net/about/#about-site)
* ©
* [2002](https://simonwillison.net/2002/)
* [2003](https://simonwillison.net/2003/)
* [2004](https://simonwillison.net/2004/)
* [2005](https://simonwillison.net/2005/)
* [2006](https://simonwillison.net/2006/)
* [2007](https://simonwillison.net/2007/)
* [2008](https://simonwillison.net/2008/)
* [2009](https://simonwillison.net/2009/)
* [2010](https://simonwillison.net/2010/)
* [2011](https://simonwillison.net/2011/)
* [2012](https://simonwillison.net/2012/)
* [2013](https://simonwillison.net/2013/)
* [2014](https://simonwillison.net/2014/)
* [2015](https://simonwillison.net/2015/)
* [2016](https://simonwillison.net/2016/)
* [2017](https://simonwillison.net/2017/)
* [2018](https://simonwillison.net/2018/)
* [2019](https://simonwillison.net/2019/)
* [2020](https://simonwillison.net/2020/)
* [2021](https://simonwillison.net/2021/)
* [2022](https://simonwillison.net/2022/)
* [2023](https://simonwillison.net/2023/)
* [2024](https://simonwillison.net/2024/)
* [2025](https://simonwillison.net/2025/)
* [2026](https://simonwillison.net/2026/)
DeepCamp AI