Datasette 1.0a43 adds streaming output renderers and view transitions

Simon Willison has published a new Datasette release, titled 1.0a43, in a post dated 15 November 2026. He says he has 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 the release is streaming support for output renderers. The built-in TSV and CSV export mechanisms now use it, and plugins can register themselves as capable of streaming every row in a table in one go through the new Response.stream() method.

There are a couple of security fixes. Willison deemed one of them worth a GitHub advisory: private stored queries could be exposed, which granted access to the title and SQL of the query, though not the ability to execute it.

The release also carries dozens of smaller improvements. The row page JSON representation now has a design suitable for 1.0. A new Web Component provides copy-schema in various places. JSON in columns on the row page can be pretty-printed. There is a new DatasetteModal.confirm() JavaScript utility method. Dozens of bug fixes are included too, with contributions by Zihan Dai, Peter Olkhovets, Ilya Khalafi and Ankita Advitot.

The feature Willison says he is most excited about is a tiny one: CSS multi-page view transitions. The CSS enables cross-document view transitions with an @view-transition rule set to navigation: auto, wrapped in a prefers-reduced-motion: no-preference media query, so only users who have not asked for reduced motion see them. Two elements are given transition names so they morph from their old position to the new one: the .facet-results block and a .table-wrapper that contains a table with the rows-and-columns class.

With that in place, navigation within Datasette, which Willison calls still staunchly a multi-page application, feels more like an SPA. It works in Safari and Chrome at the moment. Willison believes Firefox support is due to land in Firefox 162 on December 8th 2026, since view transitions are no longer feature-flagged in Firefox Nightly.

Key facts

  • Streaming support for output renderers is the biggest 1.0 item in the release; the built-in TSV and CSV exports now use it, and plugins can opt in through the new Response.stream() method to stream every row of a table in one go.
  • There are a couple of security fixes. One got a GitHub advisory: private stored queries could be exposed, revealing the query's title and SQL but not letting it be executed.
  • CSS multi-page view transitions make navigation in Datasette feel more like an SPA. They work on Safari and Chrome now; Willison believes Firefox 162 on December 8th 2026 will add support.
  • Smaller changes include a redesigned row page JSON representation, a Web Component, pretty-printed JSON in row page columns and a DatasetteModal.confirm() utility.
  • Willison says the 1.0 milestone is now 53% complete and that he has leaned hard on Claude Fable 5.2 to move it forward.

Why it matters

This release moves Datasette further toward 1.0, and the author puts the milestone at 53% complete. The headline item is streaming for output renderers, which lets plugins send every row of a table in one go; the built-in TSV and CSV export already runs on it. The row page JSON representation also now has a design the author considers suitable for 1.0. The small view-transition change is the one the author is most excited about, because it makes a multi-page application feel closer to a single-page one.

Who it affects

People who run Datasette instances, especially any with private stored queries, are affected by the security fixes. Plugin authors can use the new Response.stream() method to make their renderers streaming. Anyone who exports tables as TSV or CSV gets the streaming path through the built-in exporters. Users who browse Datasette in Safari or Chrome get the new page transitions. Four contributors, Zihan Dai, Peter Olkhovets, Ilya Khalafi and Ankita Advitot, are credited with bug fixes.

How to use it

Plugins can register as capable of streaming every row in a table by using the new Response.stream() method. The view transitions need no setup: the CSS switches them on for anyone without a prefers-reduced-motion setting, and it names the facet results and the rows table so they morph between pages. Front-end work can use the new Web Component for copy-schema and the DatasetteModal.confirm() JavaScript utility method. JSON in columns on the row page can be pretty-printed.

How solid is it

This is the author's own release announcement, and the title marks it as an alpha (1.0a43). The post names concrete mechanisms and shows the key CSS, but it gives no performance figures for streaming output renderers. It does not say how many of the 1.0 items remain, or when 1.0 is expected to ship. The Firefox claim is a belief, not a confirmed date: the author thinks support lands in Firefox 162 on December 8th 2026.

Risks and caveats

The security issue was real: private stored queries could be exposed, giving access to the title and SQL of the query, though the query could not be executed. The post gives no CVE number or severity rating for the security fixes, and it does not say whether the exposure was exploited in the wild. It does not describe the second security fix. Until Firefox ships support, view transitions only work on Safari and Chrome, and users with a reduced-motion preference do not get them. The post does not say which parts of the code Claude Fable 5.2 wrote, or how much of the work it did.

“The feature I'm most excited about is a pretty tiny one: I've added CSS multi-page view transitions to Datasette!”

— Simon Willison