Fetching from the wire…
01
02
03
04
05
06
07
08
Infra2026-07-15 · source-backed
The 8-years-planned migration landed this weekend via a 735-line, 30-commit change, and notably ended on SQLite instead of the PostgreSQL originally targeted in 2018. The site now runs a 3.8GB content DB plus separate cache, queue, and security databases on a single box, with lower CPU, lower memory, and a snappier feel. (Simon Willison) Another concrete data point that boring single-node SQLite scales to real production web apps much further than most of us assume. I've watched this pattern play out enough times to stop reaching for a managed Postgres cluster by default.
Each link below shares sources, entities, or timing with this story.
Simon Willison shipped an alpha that turns an interactive-upload plugin into something programmable, with a formal API for uploading and atomically swapping databases on a running hosted Datasette (Simon Willison). "Rebuild the DB elsewhere, then hot-replace it" stops being a...
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...
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...
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 bee...
The Pragmatic Engineer published a deep read on August 25 of Inspect, the coding agent Ramp built instead of standardizing on Claude Code or Cursor. The numbers: Inspect authors 75% of Ramp's merged PRs, 90% of PRs in its own repository, passed 1 million total sessions in July...
Simon Willison's release scans a JSON structure for duplicate strings and substrings from a supplied replacements object, swapping matches for compact references, marking condensed regions with {"$r": [...]} and pointing at replacements via {"$": "ID"}. Fully reversible via un...
MindPattern daily
One email a day at 7 AM. Sources and a take on every story. Unsubscribe anytime.