Simon Willison rewrites Datasette Lite with service workers, running the full Python app in-browser
Simon Willison · rss · 2026-11-18
Simon Willison ships a complete rewrite of Datasette Lite, running the full server-side Datasette Python app in the browser via Pyodide/WebAssembly—now nearly indistinguishable from the real server application.
New capabilities: crafted URLs to lite.datasette.io can load any SQLite DB/JSON/CSV/SQL script, pick a released Datasette version from PyPI, load specific GitHub commits/tags/branches, choose from 100+ SQLite versions, and install plugins from PyPI or wheel URLs—ideal for linking bug reproductions and demos without a server. Willison already uses it in Datasette's own dev process to demo pagination fixes in issues.
How it works: the 2022 version used a Pyodide web worker + innerHTML injection, breaking any JavaScript-based feature. The rewrite registers a service worker for the whole domain that intercepts HTTP requests and serves them from client-side code; a random session ID prefix routes each tab to its own dedicated Datasette instance. A web worker still hosts Pyodide since service-worker state dies after 30 seconds.
The project began as an AI research spike with Claude Opus 4.8 in May; only by November with Claude Fable 5.2 did Willison feel confident shipping it. Bonus: a new repo with WASM-compiled pysqlite3 wheels for 163 SQLite versions.
More from coding & agent
- Microsoft Ships MAI Code 2 and Code 2 Flash: Enterprise Coding Models at Fraction of Frontier Cost — jteevan · 2026-11-18
- One PowerShell cmdlet, New-AgentHarness, spins up an OpenAI-powered agent — dfinke · 2026-11-18
- Doodlestein Shares His Multi-Agent Coding Stack: agent-mail + beads + ntm — doodlestein · 2026-11-18
- The bitter lesson is coming for software engineering: let agents discover abstractions — tylerjdunn · 2026-11-18
- MCP Agent Mail: open-source shared inboxes and coordination for multiple AI coding agents — doodlestein · 2026-11-18
- FrontierCS 2: benchmark makes AI agents beat published CS research blind — arena · 2026-11-18