AI
Running the full server-side Datasette Python app in the browser with service workers and Pyodide
Publication: Simon Willison's Weblog
Author: Not available in collected metadata
Source published: 17/11/2026, 16:48:33 UTC
Briefing created: 17/11/2026, 17:23:20 UTC
Based on a feed excerpt; full article content has not been acquired. Source evidence retrieved 17/11/2026, 16:57:24 UTC.
Briefings
Datasette Lite is a browser-based port of the Python application using service workers to load SQLite databases and plugins from URLs. It supports over 100 SQLite versions, plugin installation, and features like the maplibre plugin for visualizing country boundaries. The project launched in 2022 as a joke but quickly gained value, with a recent fix addressing pagination bugs. The service worker architecture uses session IDs to isolate different demo instances within a shared domain.
Key points
- Datasette Lite allows users to load SQLite databases, JSON files, and SQL scripts directly from URLs without a full server.
- The service worker architecture uses session IDs to isolate different demo instances within a shared domain, preventing shared state across tabs.
Context
Datasette Lite is a port of the Python application running directly in the browser using WebAssembly and Pyodide. It supports loading over 100 SQLite versions and plugins, making it ideal for linking to demos without spinning up a full server. The project launched in 2022 as a joke but quickly proved its value for development workflows.
Limitations
The evidence covers the core functionality of Datasette Lite, including database loading, plugin installation, and the service worker architecture. Specific details about the maplibre plugin's data source and the exact session ID generation mechanism are not fully detailed in the provided text.
Generated by Bittrees-hosted qwen35-2b sha256:aaf42c8b7c3c on 17/11/2026, 17:23:20 UTC. Based on publisher-provided feed evidence; may not cover the full original article. Check the source for details.
View archived briefing on IPFS
bafybeif54dneiqxbcut5skjzdlwgszdupegr4t3bxkzalhflsn53iroekq