OPFS + Pyodide Test Harness Enables Persistent SQLite Editing in Browser
Use OPFS with Pyodide to enable persistent SQLite editing in the browser.
Implement OPFS access in your Pyodide application to allow users to open and edit SQLite files locally.
Summary
Simon built an OPFS + Pyodide test harness to explore editing persistent SQLite files in the browser. The harness uses the Origin Private File System API to allow Datasette Lite to access local files, and provides a playground UI across browsers built with Claude Code. The project demonstrates that Pyodide can interact with OPFS, enabling local SQLite persistence in the browser.
This proof‑of‑concept shows the potential for browser‑based data editing tools and paves the way for future features that allow users to open and edit SQLite databases directly in the browser without server‑side components.
Key changes
- Developed OPFS + Pyodide test harness for persistent SQLite editing
- Utilizes Origin Private File System API
- Provides playground UI across browsers
- Demonstrates Pyodide's ability to access OPFS
- Enables local SQLite persistence in browser
- Shows potential for browser-based data tools
- Uses Claude Code to build UI
- Serves as proof of concept for future features