OPFS + Pyodide Test Tool: Edit Persistent SQLite Files in Browser
Decision Brief
What changedSimon Willison's test tool explores using the browser's Origin Private File System to edit local SQLite files via Datasette Lite.
Why it mattersDemonstrates integrating Python apps with browser file systems, a key infrastructure experiment for AI builders.
Who should careAI coding tool users
Affected stackClaude Code
Builder actionEvaluate
Source confidenceMedium · Reliable media or first-hand reporting
Simon Willison pondered if Datasette Lite (a Python Datasette app running entirely in-browser via Pyodide and WebAssembly) could edit persistent SQLite files on the user's computer. He used Claude Code for web to build this test UI, leveraging the Origin Private File System (OPFS), to trial in different browsers.
Summary basis: official / RSS sourceUnless it says 'full article read', this summary is based only on publicly available content — it never pretends to have read restricted originals.
Sources
- Simon Willison:Blog
Hands-on notes on LLM tools, local models, and practical AI engineering.
- Simon Willison:Blog