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.

Original post →

More from coding & agent

coding & agent channel →