Simon Willison’s Weblog

Subscribe
Atom feed for datasette Random

1,478 posts tagged “datasette”

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

2025

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

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]