Back to Daily Feed 
OPFS + Pyodide Test Harness: Persistent SQLite in the Browser
Must Read
Originally published on Simon Willison's Weblog by Simon Willison
View Original Article
Share this article:
Summary & Key Takeaways
- The article introduces a test harness for exploring OPFS with Pyodide.
- The goal is to enable Datasette Lite to edit persistent SQLite files in the browser.
- OPFS provides a mechanism for web applications to store private files on the user's system.
- The project leverages Pyodide to run Python applications, including SQLite, within the browser via WebAssembly.
- Claude Code for web assisted in building the playground UI for cross-browser testing.
Our Commentary
Simon Willison is always at the forefront of exploring what's possible on the web, and this OPFS + Pyodide harness is a prime example. Persistent SQLite in the browser? That's a huge step for local-first applications and data management. It really pushes the boundaries of what we expect from web apps. I'm genuinely excited about the implications for tools like Datasette Lite. This is the kind of innovation that makes me love the web platform.
View Original Article
Share this article: