Skip to content
AI News HubLIVE
Original source2 min read

datasette 1.0a43

Summary

Simon Willison shipped datasette 1.0a43, with the 1.0 milestone now 53% complete. The release adds streaming support for output renderers, switches built-in TSV and CSV exports to that mechanism, fixes a security issue that could expose the title and SQL of private stored queries, and introduces CSS cross-document view transitions that make the multi-page app feel like an SPA.

datasette 1.0a43
Report an error

The correction channel is not available yet. You can copy the article reference below for later.

Correction instructions
Read article

Release: datasette 1.0a43

Simon Willison’s Weblog

Newsletter

15th November 2026

Release

datasette 1.0a43 — An open source multi-tool for exploring and publishing data

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 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 duplicated to land in Firefox 162 on December 8th 2026 (seeing as they are no longer feature-flagged in Firefox Nightly.)

Recent articles

Locating the source of a mysterious beep with Claude - 9th November 2026

Hide your slop PR descriptions behind - 9th November 2026

Qwen 3.8 27B on my laptop can interpret model weights, too - 3rd November 2026

The U.S. Census Bureau and “Super Intelligence” - 2nd November 2026

This is a beat by Simon Willison, posted on 15th November 2026.

browsers 110

chrome 45

css 242

firefox 104

javascript 773

safari 70

security 645

datasette 1,565

annotated-release-notes 63

Monthly briefing

Sponsor me for $10/month and get a curated email digest of the month's most important LLM developments.

Pay me to send you less!

Sponsor & subscribe

Disclosures

Colophon

©

2002

2003

2004

2005

2006

2007

2008

2009

2010

2011

2012

2013

2014

2015

2016

2017

2018

2019

2020

2021

2022

2023

2024

2025

2026

Key points and analysis

Article intelligence

EngineersAdvanced

Key points

  • Streaming support for output renderers plus a new Response.stream() method lets plugins stream every row of a table in one go; built-in TSV and CSV exports now use it.
  • A security fix, covered by a GitHub advisory, addressed exposure of private stored query titles and SQL, though the query itself could not be executed.
  • CSS cross-document view transitions now work in Safari and Chrome, with Firefox support expected in Firefox 162 on December 8th 2026.
  • The row page JSON representation finally has a design suitable for 1.0, alongside a new copy-schema Web Component and DatasetteModal.confirm().

Highlights and analysis are generated automatically and may contain errors. Check the original source.