Simon Willison’s Weblog

Subscribe
Atom feed for datasette Random

1,455 posts tagged “datasette”

Datasette is an open source tool for exploring and publishing data.

2025

Release datasette-auth-github 0.14 — Datasette plugin that authenticates users against GitHub

Datasette 1.0a22. New Datasette 1.0 alpha, adding some small features we needed to properly integrate the new permissions system with Datasette Cloud:

Plus a developer experience improvement for plugin authors:

# 13th November 2025, 11:04 pm / projects, datasette-cloud, annotated-release-notes, datasette

Release datasette 1.0a22 — An open source multi-tool for exploring and publishing data
Release datasette-public 0.3a5 — Make selected Datasette databases and tables visible to the public

I've been upgrading a ton of Datasette plugins recently for compatibility with the Datasette 1.0a20 release from last week - 35 so far.

A lot of the work is very repetitive so I've been outsourcing it to Codex CLI. Here's the recipe I've landed on:

codex exec --dangerously-bypass-approvals-and-sandbox \
'Run the command tadd and look at the errors and then
read ~/dev/datasette/docs/upgrade-1.0a20.md and apply
fixes and run the tests again and get them to pass.

Also delete the .github directory entirely and replace
it by running this:

cp -r ~/dev/ecosystem/datasette-os-info/.github .

Run a git diff against that to make sure it looks OK
- if there are any notable differences e.g. switching
from Twine to the PyPI uploader or deleting code that
does a special deploy or configures something like 
playwright include that in your final report.

If the project still uses setup.py then edit that new
test.yml and publish.yaml to mention setup.py not pyproject.toml

If this project has pyproject.toml make sure the license
line in that looks like this:

license = "Apache-2.0"

And remove any license thing from the classifiers= array

Update the Datasette dependency in pyproject.toml or
setup.py to "datasette>=1.0a21"

And make sure requires-python is >=3.10'

I featured a simpler version of this prompt in my Datasette plugin upgrade video, but I've expanded it quite a bit since then.

At one point I had six terminal windows open running this same prompt against six different repos - probably my most extreme case of parallel agents yet.

Animated GIF demo. Six terminal windows are arranged in a 3x2 grid, each one of them is running the above prompt and working its way through making modifications to one of six different projects: datasette-extract, datasette-create-view, datasette-write, datasette-secrets, datasette-public, and datasette-write-ui.

Here are the six resulting commits from those six coding agent sessions:

# 11th November 2025, 10:52 pm / ai, llms, codex-cli, prompt-engineering, coding-agents, ai-assisted-programming, datasette, generative-ai, parallel-agents

Release datasette-pins 0.1a6 — Pin databases, tables, and other items to the Datasette homepage
Release datasette-ripgrep 0.9a0 — Web interface for searching your code using ripgrep, built as a Datasette plugin
Release datasette-queries 0.1.3a0 — Save SQL queries in Datasette
Release datasette-extract 0.1a12 — Import unstructured data (text and images) into structured tables
Release datasette-secrets 0.3a0 — Manage secrets such as API keys for use with other Datasette plugins
Release datasette-create-view 0.2a0 — Create a SQL view from a query
Release datasette-write 0.5a0 — Datasette plugin providing a UI for executing SQL writes against the database
Release datasette-export-database 0.3a0 — Export a copy of a mutable SQLite database on demand
Release datasette-events-forward 0.1a4 — Forward Datasette analytical events on to another Datasette instance
Release datasette-edit-schema 0.8a5 — Datasette plugin for modifying table schemas
Release datasette-auth-tokens 0.4a11 — Datasette plugin for authenticating access using API tokens
Release datasette-upload-dbs 0.4a0 — Upload SQLite database files to Datasette
Release datasette-configure-fts 1.2a0 — Datasette plugin for enabling full-text search against selected table columns
Release datasette-edit-templates 0.5a0 — Plugin allowing Datasette templates to be edited within Datasette
Release datasette-upload-csvs 0.10a0 — Datasette plugin for uploading CSV files and converting them to database tables
Release datasette-ephemeral-tables 0.2.3 — Provide tables that expire after a time limit
Release datasette-llm-usage 0.1a2 — Track usage of LLM tokens in a SQLite table
Release datasette-enrichments-llm 0.1a2 — Enrich data by prompting LLMs
Release datasette-load 0.1a5 — API and UI for bulk loading data into Datasette from a URL
Release datasette-events-db 0.1a2 — Log Datasette events to a database table
Release datasette-remote-actors 0.1a7 — Datasette plugin for fetching details of actors from a remote endpoint
Release datasette-remove-database 0.1a2 — Remove a database from Datasette
Release datasette-debug-events 0.1a2 — Print Datasette events to standard error
Release datasette-debug-actors-from-ids 0.1a3 — Datasette plugin for trying out the actors_from_ids hook