🗄️ SQLite 3.53.0 Just Dropped — The World's Most-Used Database Gets a Major Upgrade

The database running on every phone, laptop, and app you use daily just got its biggest update in months.

SQLite 3.53.0 is here — and because version 3.52.0 was withdrawn, this release packs a massive amount of accumulated improvements into one drop.

Here's what matters:

• **ALTER TABLE finally does more** — You can now add and remove NOT NULL and CHECK constraints directly. No more creating a new table, copying data, and renaming. What used to take multiple careful steps is now a single command.

• **New JSON functions** — json_array_insert() and its jsonb equivalent make working with document data inside SQLite far more practical.

• **Beautiful CLI output** — A brand-new Query Results Formatter library completely overhauls how results look in the command line. Simon Willison even compiled it to WebAssembly and built an interactive playground to try it out.

Why it matters: SQLite isn't just a developer tool — it's embedded in billions of devices worldwide. Every improvement ripples across mobile apps, IoT devices, desktop software, and edge computing.

The ALTER TABLE change alone removes one of the longest-standing friction points for developers managing schema migrations in production SQLite databases.

The tiny database that powers everything just got significantly more powerful.