SQLite 3.53.4

SQLite 3.53.4 ships today — a maintenance release fixing regressions introduced in 3.53.0 and its subsequent patches.

Critical Bug Fix

WAL-reset database corruption bug squashed. This release fixes a corruption issue that could occur when the Write-Ahead Log is reset under certain conditions. All users on SQLite 3.53.x should upgrade immediately.

Key Changes in 3.53.4

• Fixes for problems in 3.53.0, 3.53.1, 3.53.2, and 3.53.3 — mostly coming from AI-generated bug reports
• WAL-reset corruption fix is the marquee stability improvement
• Various documentation and makefile corrections

What Was New in the 3.53 Series

For context, the 3.53.x branch introduced several major features earlier this year:

• Query Result Formatter (QRF) — A new library for formatting SQL query results for human readability on fixed-pitch displays
• Enhanced ALTER TABLE — Adding and removing NOT NULL and CHECK constraints is now supported
• CLI improvements — Default output mode now uses Unicode box-drawing characters via QRF. Numeric values are right-justified. Bare semicolons at the end of dot-commands are silently ignored.
• New C APIs — sqlite3_str_truncate(), sqlite3_str_free(), sqlite3_carray_bind_v2(), SQLITE_PREPARE_FROM_DDL, and more
• Query planner upgrades — Better join order selection on star schemas, improved EXISTS-to-JOIN optimization
• Self-healing indexes — Automatic repair of stale expression indexes
• JavaScript/WASM — New "opfs-wl" VFS using Web Locks for fairer lock sharing

Upgrade Now

SQLite 3.53.4 is available at sqlite.org. Drop-in replacement for prior 3.53.x releases — no schema changes required.