Fetching from the wire…
Tools2026-06-22 · source-backed
The first major version bump of his widely-used Python/CLI SQLite toolkit lands built-in schema migrations and savepoint-based nested transactions on June 21. If you lean on sqlite-utils as glue in data or LLM pipelines, migrations kill the hand-rolled ALTER scripts you've been maintaining. It ships the same week as his Datasette Apps work, continuing the push to make SQLite a first-class substrate for agent-built tools.
Each link below shares sources, entities, or timing with this story.
Willison launched datasette-apps (0.1a2) on June 18, hosting self-contained HTML+JS apps in a sandboxed iframe that run SQL against your data, read-only by default. He frames it as "Claude Artifacts reimagined for Datasette," artifacts backed by a JSON API to a relational data...
Simon Willison shipped 1.0a35 on June 23 with in-browser "Create table" and "Alter table" interfaces backed by stable JSON schema APIs, plus template context promoted to a stable public API. It pushes Datasette from read-only publishing toward an editable, scriptable database...
His conclusion is DuckDB matches or beats SQLite's safety for untrusted queries, but only with enable_external_access=false, lock_configuration=true, and a watchdog thread, since DuckDB lacks SQLite's opcode-based query timeouts. He ships a safe_duckdb.py helper and a Datasett...
Satya Nadella said companies routing everything through a single proprietary lab may not survive. His argument: you hand that lab your most sensitive business context, and the lab can turn it against you as a competitor. His prescription is an orchestration layer — keep the ha...
Prompted by Julia Evans admitting on July 17 that she still can't read query plans, Willison had Fable build a tool that runs arbitrary SQL against a SQLite database and renders both EXPLAIN QUERY PLAN and the lower-level EXPLAIN bytecode with per-line plain-English annotation...
TERMy was posted September 4 pointing at gioblu/NPC-Forge, a Python framework for conversational agents that run on the CPU with no machine learning or LLMs. The repo is small, created July 18. Placing that high against release-day frontier-model coverage is a real signal abou...
MindPattern daily
One email a day at 7 AM. Sources and a take on every story. Unsubscribe anytime.