cd /news/developer-tools/datasette-1-0a43 · home › topics › developer-tools › article
[ARTICLE · art-170191] src=simonwillison.net ↗ pub= topic=developer-tools verified=true sentiment=↑ positive

datasette 1.0a43

Datasette 1.0a43 shipped with streaming support for output renderers, including the built-in TSV and CSV export mechanisms, and a new Response.stream() method that lets plugins stream every row in a table in one go, according to release notes published by Datasette creator Simon Willison. The release also includes a security fix, covered by GitHub advisory GHSA-mw6v-83vp-7c4c, that had exposed the title and SQL of private stored queries without allowing their execution. Willison said the 1.0 milestone is now 53% complete and that he leaned heavily on Claude Fable 5.2 to help close it out; the release also adds CSS multi-page view transitions, a <datasette-copy-button> Web Component, and a redesigned row page JSON representation.

read2 min views1 publishedNov 15, 2026

Release: datasette 1.0a43

I've been leaning hard into Claude Fable 5.2 to help knock things off the 1.0 milestone, which is now 53% complete.

The biggest 1.0 item in this release is streaming support for output renderers - the built-in TSV and CSV export mechanisms now use this as well, and plugins can register themselves as capable of streaming every row in a table in one go via the new Response.stream() method.

There are a couple of security fixes, one of which I deemed deserving of a GitHub advisory: private stored queries could be exposed, granting access to the title and SQL of the query (but not allowing that query to be executed).

There are dozens of smaller improvements. The row page JSON representation finally has a design suitable for 1.0. A new <datasette-copy-button> Web Component provides copy-schema in various places. JSON in columns on the row page can be pretty-printed. There's a new DatasetteModal.confirm() JavaScript utility method. Plus dozens of bug fixes, including contributions by Zihan Dai, Peter Olkhovets, Ilya Khalafi, and Ankita Advitot.

The feature I'm most excited about is a pretty tiny one: I've added CSS multi-page view transitions to Datasette! Here's the commit - key CSS is as follows:

/* Enable cross-document view transitions,
   for anyone without prefers-reduced-motion */
@media (prefers-reduced-motion: no-preference) {
    @view-transition {
        navigation: auto;
    }
}
/* .facet-results should morph from old position to new */
html:active-view-transition .content > .facet-results {
    view-transition-name: facet-results;
}
/* So should a .table-wrapper, provided it contains .rows-and-columns */
html:active-view-transition .table-wrapper:has(> table.rows-and-columns) {
    view-transition-name: rows-table;
}

With that in place, navigations within Datasette - still staunchly a multi-page application - feel more like an SPA. This works on Safari and Chrome at the moment and I believe supports for Firefox is due to land in Firefox 162 on December 8th 2026 (seeing as they are no longer feature-flagged in Firefox Nightly.)

Tags: security, datasette, css, browsers, annotated-release-notes, firefox, javascript, safari, chrome

── more in #developer-tools 4 stories · sorted by recency
── more on @datasette 3 stories trending now
sponsored brought to you by zahid.host 4,200+ EU-deployed projects
reading about agents? ship yours in a single git push.

Run your AI side-project on zahid.host

EU-based hosting, git-push deploys, automatic HTTPS, no cold starts. Free tier with a custom domain — perfect for shipping the agent you just read about.

$git push zahid main
→ Live at https://your-agent.zahid.host ✓
Get free account → Pricing
from €0/mo · no card required
LIVE [news/datasette-1-0a43] indexed:0 read:2min 2026-11-15 · —