Simon Willison’s Weblog

Subscribe
Atom feed for datasette Random

1,469 posts tagged “datasette”

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

2025

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

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