OPFS + Pyodide test harness

2026-06-23 · Source: Simon Willison's Weblog · Field: Technology & Digital — Software Development & Engineering, Emerging Technologies & Innovation · Depth: Intermediate, quick

Summary

The OPFS + Pyodide test harness, released on June 23rd, 2026, is a playground user interface designed to explore the feasibility of Datasette Lite editing persistent SQLite files directly within a user's web browser. This tool specifically investigates the capabilities of the Origin Private File System (OPFS) for enabling such functionality. Datasette Lite, a Python application, runs entirely in the browser leveraging Pyodide and WebAssembly. The harness, built with Claude Code for web, allows developers to test how OPFS interacts with Pyodide-based applications across different browsers, aiming to determine if browser-stored SQLite files can be reliably edited and maintained locally.

Key takeaway

For web developers exploring client-side data persistence for Python applications, this OPFS + Pyodide test harness demonstrates a concrete approach. You should investigate this tool to understand how Origin Private File System (OPFS) can enable browser-based Python applications, like Datasette Lite, to directly edit and store SQLite files on a user's computer. Evaluate its cross-browser compatibility and performance implications for your specific project needs.

Key insights

The core idea is to validate browser-based persistent storage for Python applications using OPFS and Pyodide.

Principles

• OPFS enables persistent browser storage.
• Pyodide allows Python apps in browser.

Method

A playground UI was built to test OPFS integration with Pyodide for editing SQLite files in various browsers.

In practice

• Datasette Lite can edit local SQLite files.
• Test OPFS compatibility across browsers.

Topics

• OPFS
• Pyodide
• WebAssembly
• Datasette Lite
• SQLite
• Browser Storage

Best for: Software Engineer, Research Scientist

Related on AIssential

• Running Python ASGI apps in the browser via Pyodide + a service worker — Python ASGI web apps can run serverless in browsers via Pyodide and service workers.
• Syntaqlite Playground — Syntaqlite Playground offers browser-based SQLite SQL query analysis via WebAssembly and Pyodide.
• Shift Left Your PySpark: How Unit Tests, Local Spark, and CI/CD Turn “It Runs” into “It Works” — Shift left PySpark testing with unit tests and local Spark saves costs and improves code quality.
• run-llama / liteparse — LiteParse offers fast, local, and flexible document parsing with spatial text and OCR capabilities across multiple platforms.
• ByteDance Data Engineering Interview Questions — ByteDance data engineering interviews combine SQL for data manipulation and Python for algorithmic problem-solving.
• Understanding Parquet Format for beginners — Parquet is a columnar storage format that provides significant efficiency and performance gains, often underlying the benefits attributed to open table formats like Iceberg and Delta, primarily throug…

Open in AIssential →

Editorial summary, takeaway, and curation by AIssential. Original article published by Simon Willison's Weblog.