SQLite formally refuses agentic code contributions and created a separate AI bug report forum
“SQLite does not accept agentic code. However the project will accept agentic bug reports that include a reproducible test case.”
sqlite
10 tracked signals on sqlite.
Simon Willison used Claude Code (Opus 4.8) and Codex (GPT-5.5) to convert MDN's browser-compat-data into a CDN-hosted SQLite database.
“I decided to try converting their comprehensive mdn/browser-compat-data repository full of browser compatibility data into a SQLite database.”
A new project called Turso is rewriting SQLite from scratch in Rust to make it fully open source and concurrent.
“If someone told you they were rewriting SQLite in Rust, I think you'd have trouble figuring out if they were one of the smartest people you ever met or one of the dumbest.”
Compressed JSON arrays reduce 20MB of SQLite revision history to 80KB
“1,000 simulated revisions to a document resulted in 20.4 MB of raw revision text that compressed to 80.3 KB as Zstandard-compressed JSON array.”
Simon Willison used Claude Code (Opus 4.8) to find methods mapping SQLite result columns back to their source table.column.
“I decided to set Claude Code (Opus 4.8, since Fable is currently banned by the US government) on the problem.”
Simon Willison used Claude Fable to build a browser-based SQLite query plan explainer.
“Maybe one day I'll learn to read a query plan.”
Datasette 1.0a31 adds write query execution and stored queries for permissioned users.
“Datasette now offers users with the necessary permissions the ability to both execute write queries against their database and to save stored queries (renamed from "canned queries") both privately and for use by other members of their Datasette instance.”
datasette-explain 0.2.2 adds explain plan support on read-only stored-query pages.
“Explain plans now work on read-only stored-query pages.”
Linux executables can be structured as SQLite databases using ELF format tables
sqlite-utils 4.2 improves table.transform() with better schema preservation