Datasette 1.0a43 brings streaming support for table exports, a handful of useful interface improvements and a security fix for private stored queries. The alpha release gives users and plugin developers a clearer look at what the project is building towards its 1.0 milestone, including one security issue with a specific limit: the exposed query details could not be used to run the query.
Watch Desk analysis
What happened
Simon Willison’s Datasette 1.0a43 release notes describe streaming support for output renderers. The built-in TSV and CSV exports now use it, and plugins can use a new Response.stream() method to stream table rows.
The release also fixes an issue that could expose the title and SQL of private stored queries, though the queries could not be executed. Other changes include a redesigned row-page JSON representation, a copy-schema button, formatted JSON on row pages and a new JavaScript confirmation utility. CSS multi-page view transitions make navigation feel more like a single-page app in Safari and Chrome; Firefox support is expected later, according to Willison.
Our top picks
- Streaming for exports and plugins
TSV and CSV exports can stream rows, and plugins can build on the new Response.stream() method. - A fix for private stored queries
The issue could reveal a query’s title and SQL, but not execute it. - Smoother page navigation
Multi-page view transitions are supported in Safari and Chrome, with Firefox support expected later. - A clearer row-page experience
JSON is now pretty-printed, and the row-page JSON representation has been redesigned for the 1.0 milestone. - Small tools with practical uses
A copy-schema button and a new confirmation method give users and developers a couple of handy additions.
Why it matters
Streaming can make a difference when a table is too large to handle as one lump of output, and the new plugin method lets developers build that behaviour into their own tools. The security fix is narrower than a query-execution vulnerability, but private SQL can still reveal information about how a database is structured or used.
Our read
This is a useful alpha, not a finished 1.0 promise. The standouts are the streaming support and a security fix that is candid about what was exposed, and what was not. If you use Datasette, read the release notes before upgrading, particularly if private stored queries matter to your setup.
What to watch
- Whether streaming support brings useful new capabilities to Datasette plugins.
- How the row-page and export changes develop as the 1.0 milestone progresses.
- Whether Firefox support for view transitions arrives as expected.
Discussion spark: For a data tool, which deserves priority in the run-up to 1.0: the performance gains from streaming, or tightening the handling of private query details?
Sources and evidence
- datasette 1.0a43 (15 November 2026, 23:20 UTC)
- Claude Status (15 November 2026, 23:20 UTC)
Watch Desk is operated by WittyWires as an independent cross-cutting AI news tracker. It does not speak for the organisations or people it covers.