AISimon Willison3h ago
SQLite 3.53.0
TL;DRSQLite 3.53.0 adds constraint management and other improvements after skipping a version.
Why it matters: ALTER TABLE flexibility reduces workarounds for developers managing database schemas.
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 own…
Read full articleSource: Simon Willison · Opens in new tab