Skip to content
Frontier Leaf FL markFLFrontierLeaf

A field journal of new AI developments.

Model updates

Datasette 1.0a43 adds streaming exports and fixes private query exposure

Simon Willison’s database tool gains row streaming, a security patch for stored queries and CSS view transitions in this release.

Depth
1 outlet · newest source 12h ago
Datasette 1.0a43 adds streaming exports and fixes private query exposure

Key points

  • Version 1.0a43 introduces streaming support for output renderers via a new Response.stream method.
  • A security fix addresses an issue where private stored queries could be exposed, granting access to titles and SQL.
  • The 1.0 milestone is reported as 53 per cent complete, with dozens of bug fixes and UI improvements included.

Datasette version 1.0a43 was detailed in a report by Simon Willison posted on 15 November 2026, introducing streaming capabilities for data exports and addressing a vulnerability in private stored queries. According to the report, this update moves the project closer to its 1.0 milestone, which is now 53 per cent complete.This update makes exporting large files faster and fixes a security hole where private query details could be seen.The 1.0a43 release implements Response.stream for renderer plugins and patches the exposure of private stored query metadata.

Evidence: reporteddatasette 1.0a43

aifleet-willison

Evidence: reporteddatasette 1.0a43

aifleet-willison

The evidence

The release notes published by Simon Willison detail that the built-in TSV and CSV export mechanisms now utilise streaming support. Plugins can register themselves to stream every row in a table in one go using the new Response.stream method. This feature represents the largest item towards the 1.0 milestone in this specific release.

Evidence: reporteddatasette 1.0a43

aifleet-willison

The decision

Willison deemed one security fix significant enough to warrant a GitHub advisory. Private stored queries could previously be exposed, granting access to the title and SQL of the query. The source notes that this exposure did not allow the query to be executed.

The takeaway

Beyond core functionality, the update includes dozens of smaller improvements and bug fixes. Contributors Zihan Dai, Peter Olkhovets, Ilya Khalafi and Ankita Advitot assisted with these repairs. The row page JSON representation has been redesigned to be suitable for the 1.0 standard, and JSON in columns can now be pretty-printed.

Evidence: reporteddatasette 1.0a43

aifleet-willison

Building on this

Developers can leverage the new Response.stream method to build plugins that handle large datasets more efficiently by streaming rows rather than loading them entirely. The addition of the DatasetteModal.confirm utility method allows for better user interaction handling in custom interfaces. Furthermore, the new datasette-copy-button Web Component enables schema copying in various places, streamlining developer workflows when inspecting database structures.

Why it matters

  • Enterprise IT buyers can now export large TSV and CSV datasets with improved performance through streaming, reducing memory overhead during data extraction tasks.
  • The security patch addresses the exposure of titles and SQL from private stored queries, preventing unauthorised access to this metadata.
  • The redesigned row page JSON representation provides a stable structure for 1.0, allowing developers to build integrations that rely on consistent data formatting.
  • CSS multi-page view transitions improve the user experience for internal tools, making navigation feel smoother and more like a single-page application on supported browsers.

Topics: database tools, data export, security patches, Simon Willison, Datasette

Updated

Then / now / next

Then

Datasette lacked streaming support for output renderers and had a vulnerability in private stored queries.

Now

Version 1.0a43 provides streaming via Response.stream and patches the query exposure issue.

Next

Firefox is expected to support CSS view transitions in version 162 on 8 December 2026.

Story timeline

  1. Then Datasette lacked streaming support for output renderers and had a vulnerability in private stored queries.
  2. 15 Nov 2026 datasette 1.0a43
  3. Now Version 1.0a43 provides streaming via Response.stream and patches the query exposure issue.
  4. Next Firefox is expected to support CSS view transitions in version 162 on 8 December 2026.

The strongest doubt

Counterpoint from the sources

The CSS multi-page view transitions currently only work on Safari and Chrome, with Firefox support pending until late 2026.

For readers

Developers

  • Use Response.stream to build plugins that stream table rows efficiently.
  • Utilise the new DatasetteModal.confirm utility for better interface interactions.

Business

  • Improved CSV/TSV streaming reduces resource usage during large data exports.
  • Security patch prevents unauthorised access to private stored query titles and SQL.

Researchers

  • Row page JSON is now designed for 1.0 stability, aiding data analysis tools.
  • Pretty-printed JSON in columns improves readability for complex data structures.

Try it

Use Response.stream() in a plugin

Good result: Plugins can now stream every row in a table in one go for efficient data handling.

Ask the article

Local keyword search of this article; no generated answers.

Did this article give you the evidence you needed?

No vote saved on this device.
Your choice stays on this device. No public tally.

Questions readers ask

Did the vulnerability allow execution of exposed private queries?

No, the source material states that the exposure granted access to titles and SQL but did not allow the query to be executed.

Which browsers support the new CSS view transitions?

Safari and Chrome currently support the feature, with Firefox support expected in version 162 on 8 December 2026.

Is Datasette 1.0 fully released yet?

No, the 1.0 milestone is reported as 53 per cent complete as of this 1.0a43 release.

Reading receipt

  • Version 1.0a43 introduces streaming support for output renderers via a new Response.stream method.
  • A security fix addresses an issue where private stored queries could be exposed, granting access to titles and SQL.
  • The 1.0 milestone is reported as 53 per cent complete, with dozens of bug fixes and UI improvements included.
Time spent: 0:00 · Depth: Full

Sources

  1. Simon Willison AI

Related stories

Background reading