Datasette
AdoptTools
An open source tool for exploring and publishing SQLite databases.
Why it's here
Placed in Adopt: 16 article(s) of evidence from 1 source(s), led by open-source activity, with 6 in the last 30 days. Confidence 57%.
Evidence (16)
- 7Simon Willison·8/6/2026securityDatasette 1.0a38 fixes SQL injection issue
Datasette 1.0a38 addresses a SQL injection security issue affecting instances that expose both public and private tables in the same database with permissions-based access control. The fix prevents users with access to a public table from using raw SQL queries to reach private table data; the same fix is also available in Datasette 0.65.3.
- 4Simon Willison·8/1/2026framework_updateDatasette Apps 0.2a0 adds agent debugging and app listing tools
Datasette Apps 0.2a0 adds a new app_debug() tool that lets Datasette Agent open an app invisibly in an iframe and test it with JavaScript. It also adds app_list() so the agent can find apps the user can edit, enabling more direct edit-and-test workflows.
- 7Simon Willison·7/31/2026framework_updateStateless MCP renews interest in the protocol
Simon Willison describes the new stateless MCP 2.0 specification as a major simplification over the older session-based design. He also highlights building new tools, including mcp-explorer, to probe MCP servers more easily.
- 3Simon Willison·7/14/2026framework_updateDatasette 1.0a37 released
Simon Willison released Datasette 1.0a37, a minor update to the open source tool for exploring and publishing data. The release includes performance and documentation improvements to the permissions system, and reverts a cosmetic API change that had broken many existing plugin test suites.
- 4Simon Willison·7/13/2026open_sourceDOOM built on SQLite
Peter Gostev created DOOMQL, a small Doom-like game where SQLite and SQL handle movement, collision, enemies, combat, progression, and even per-pixel rendering. The project is implemented as a Python terminal script and can be explored through a Datasette app that reads the game state from the SQLite database.
- 2Simon Willison·7/13/2026open_sourceDatasette code frequency chart on GitHub
Simon Willison shared a GitHub code-frequency chart for his Datasette open source project to illustrate changes in his coding output over time. He noted that a recent spike in activity appears to line up with use of newer AI coding models and agents such as Opus 4.8, GPT-5.5, Fable 5, and GPT-5.6 Sol.
- 6Simon Willison·7/3/2026open_sourceCurrent AI launches open source AI Gap Map
Current AI has released its Gap Map v0.1, an indexed view of the open source AI ecosystem covering models, tools, datasets, and hardware. The project also published the underlying MIT-licensed data and scripts on GitHub, including thousands of tracked repositories that can be explored programmatically.
- 2Simon Willison·7/3/2026product_launchSimon Willison releases June 2026 sponsor newsletter
Simon Willison announced that the June 2026 sponsors-only newsletter is now available to paying subscribers. The issue highlights Claude Fable 5, GPT-5.6, US export restrictions, GLM-5.2, and several projects across Datasette, sqlite-utils, shot-scraper, and related WASM work.
- 4Simon Willison·7/2/2026researchUsing DSPy to improve Datasette Agent SQL prompts
Simon Willison describes using DSPy to evaluate and refine the system prompts behind Datasette Agent's read-only SQL feature. An initial pass found that prompt wording around schema guidance could lead to column-name guessing and error-retry loops, suggesting prompt changes or adding column names to the schema listing.
- 5Simon Willison·6/30/2026framework_updateshot-scraper adds storyboard-based video recording for web demos
shot-scraper 1.10 introduces a new `video` command that uses a YAML storyboard and Playwright to record scripted interactions with a web application. The post shows it being used to capture a demo of Datasette features, including bulk inserting rows and creating a table from pasted data.
- 2Simon Willison·6/25/2026framework_updatedatasette-export-database 0.3a2 fixes dependency pin
Simon Willison released datasette-export-database 0.3a2, a small update for exporting a copy of a mutable SQLite database on demand. The release fixes an accidental strict pin to datasette==1.0a27 by changing it to datasette>=1.0a27, restoring compatibility with other Datasette versions.
- 4Simon Willison·6/24/2026open_sourceBrowser compatibility data converted into a SQLite database
Simon Willison created a SQLite version of Mozilla's mdn/browser-compat-data repository, making browser compatibility data easier to query and explore. The database is published on GitHub in a way that supports open CORS headers, enabling direct use in tools like Datasette Lite.
- 7Simon Willison·6/23/2026open_sourceDatasette 1.0a35 adds create and alter table tools
Datasette 1.0a35 is a major release that introduces new database actions for creating and altering tables, including support for columns, keys, constraints, defaults, and foreign keys. It also adds documented template context variables for core pages, treated as a stable API for custom templates until Datasette 2.0.
- 3Simon Willison·6/23/2026product_launchOPFS and Pyodide test harness
Simon Willison shared an interactive test harness for the Origin Private File System (OPFS) powered by Pyodide. The tool lets users create, read, delete, and query SQLite files in OPFS, while checking persistence and browser capabilities across desktop and mobile browsers.
- 3Simon Willison·6/18/2026framework_updatedatasette-acl 0.6a0 expands permissions management
Simon Willison announced datasette-acl 0.6a0, a new release that extends the plugin beyond table-level permissions toward broader resource sharing in Datasette. The update is aimed at multi-user Datasette instances that need finer-grained control over access to internal resources.
- 4Simon Willison·6/16/2026open_sourcedatasette-tailscale 0.1a0 lets Datasette run on a Tailscale network
Simon Willison announced an experimental alpha plugin, datasette-tailscale 0.1a0, that starts a local Datasette server and connects it to a Tailscale Tailnet. The setup makes the instance available through a Tailscale hostname, using Python bindings for the experimental tailscale-rs library.