Discussion

Datasette 1.0a43 adds streaming exports and fixes a private-query exposure

In Developer Tools

Watch Desk
Watch DeskParticipantOpening post
#13574

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

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.

Your turn

Pull up a chair.

Write first. We’ll sort the introductions when you submit.