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

Video + notes on upgrading a Datasette plugin for the latest 1.0 alpha, with help from uv and OpenAI Codex CLI

Visit Video + notes on upgrading a Datasette plugin for the latest 1.0 alpha, with help from uv and OpenAI Codex CLI

I’m upgrading various plugins for compatibility with the new Datasette 1.0a20 alpha release and I decided to record a video of the process. This post accompanies that video with detailed additional notes.

[... 1,094 words]

Release datasette-checkbox 0.1a4 — Add interactive checkboxes to columns in Datasette
Release datasette-enrichments 0.6a0 — Tools for running enrichments against data stored in Datasette

Open redirect endpoint in Datasette prior to 0.65.2 and 1.0a21. This GitHub security advisory covers two new releases of Datasette that I shipped today, both addressing the same open redirect issue with a fix by James Jefferies.

Datasette 0.65.2 fixes the bug and also adds Python 3.14 support and a datasette publish cloudrun fix.

Datasette 1.0a21 also has that Cloud Run fix and two other small new features:

  • New datasette --get /path --headers option for inspecting the headers returned by a path. (#2578)
  • New datasette.client.get(..., skip_permission_checks=True) parameter to bypass permission checks when making requests using the internal client. (#2583)

I decided to include the Cloud Run deployment fix so anyone with Datasette instances deployed to Cloud Run can update them with the new patched versions.

# 5th November 2025, 11:11 pm / annotated-release-notes, security, datasette, cloudrun

Release datasette 1.0a21 — An open source multi-tool for exploring and publishing data
Release datasette 0.65.2 — An open source multi-tool for exploring and publishing data

A new SQL-powered permissions system in Datasette 1.0a20

Visit A new SQL-powered permissions system in Datasette 1.0a20

Datasette 1.0a20 is out with the biggest breaking API change on the road to 1.0, improving how Datasette’s permissions system works by migrating permission logic to SQL running in SQLite. This release involved 163 commits, with 10,660 additions and 1,825 deletions, most of which was written with the help of Claude Code.

[... 2,750 words]

Release datasette-acl 0.5a0 — Advanced permission management for Datasette
Release datasette-allow-permissions-debug 0.2a0 — Always allow access to /-/permissions, for debugging
Release datasette-events-forward 0.1a3 — Forward Datasette analytical events on to another Datasette instance
Release datasette-search-all 1.1.5a0 — Datasette plugin for searching all searchable tables at once
Release datasette 1.0a20 — An open source multi-tool for exploring and publishing data
Release datasette-events-forward 0.1a2 — Forward Datasette analytical events on to another Datasette instance
Release datasette-debug-actors-from-ids 0.1a2 — Datasette plugin for trying out the actors_from_ids hook
Release datasette-visible-internal-db 0.1.1a1 — Datasette plugin for making the internal database visible for debugging
Release datasette-create-view 0.1a1 — Create a SQL view from a query
Release datasette-studio 0.1a5 — Datasette pre-configured with useful plugins. Experimental alpha.
Release datasette-load 0.1a4 — API and UI for bulk loading data into Datasette from a URL
Release datasette-import 0.1a6 — Tools for importing data into Datasette
Release datasette-events-db 0.1a1 — Log Datasette events to a database table
Release datasette-public 0.3a4 — Make selected Datasette databases and tables visible to the public
Release datasette-edit-schema 0.8a4 — Datasette plugin for modifying table schemas
Release datasette-remote-actors 0.1a6 — Datasette plugin for fetching details of actors from a remote endpoint
Release datasette-extract 0.1a11 — Import unstructured data (text and images) into structured tables
Release datasette-pins 0.1a5 — Pin databases, tables, and other items to the Datasette homepage
Release datasette-checkbox 0.1a3 — Add interactive checkboxes to columns in Datasette
Release datasette-column-sum 0.1a1 — Sum the values in numeric Datasette columns
Release datasette-remove-database 0.1a1 — Remove a database from Datasette
Release datasette-queries 0.1.2a1 — Save SQL queries in Datasette