datasette 1.0a33

2026-06-11 · Source: Simon Willison's Weblog · Field: Technology & Digital — Data Science & Analytics, Software Development & Engineering · Depth: Intermediate, quick

Summary

Datasette 1.0a33, released on June 11th, 2026, is a significant alpha update for the open-source multi-tool designed for exploring and publishing data. This version extends the "?_extra=" pattern, previously introduced in 1.0a3, to now cover queries and rows, in addition to tables. The expanded functionality, which allows for richer JSON responses, is now fully documented. To demonstrate this new feature, a custom API explorer was developed using AI tools, specifically Claude Fable 5 for the plan and GPT-5.5 xhigh for the implementation. This explorer helps users visualize and interact with the enhanced API capabilities.

Key takeaway

For data engineers or developers building data APIs, Datasette 1.0a33 offers enhanced flexibility for data publishing and exploration. You should investigate the extended "?_extra=" pattern to provide richer, more customizable JSON responses from your Datasette instances, reducing the need for multiple API calls. Consider using the new custom extras API explorer to understand its capabilities and streamline your data exposure strategies.

Key insights

Datasette's "?_extra=" pattern now enriches API responses for queries and rows, enhancing data exploration.

Principles

• Extend API patterns for richer data.
• AI tools accelerate development.
• Provide interactive feature demos.

Method

An API explorer was built using Claude Fable 5 for planning and GPT-5.5 xhigh for implementation, demonstrating AI-assisted development for feature showcasing.

In practice

• Use "?_extra=" for detailed API responses.
• Explore the custom API explorer.
• Consider AI for rapid tool building.

Topics

• Datasette
• Data Publishing
• API Design
• JSON API
• AI Development
• Data Exploration

Code references

• simonw/datasette

Best for: Data Scientist, Data Engineer, Software Engineer

Related on AIssential

• datasette-files 0.1a2 — Datasette-files 0.1a2 enhances Datasette with direct file uploads, CSV/TSV import, and image thumbnail generation.
• datasette-llm-accountant 0.1a4 — datasette-llm-accountant 0.1a4 fixes a bug in tracking LLM response chains for Datasette.
• Building Your First Streamlit App: Uploads, Charts, and Filters (Part 2) — Streamlit enables rapid development of interactive data apps with uploads, visualizations, filtering, and export.
• Introducing Dataset Q&A: Expanding natural language querying for structured datasets in Amazon Quick — Amazon Quick's Dataset Q&A enables direct natural language querying of full datasets, enhancing BI agility and transparency.
• Optimizing Your IDE for Metadata-Driven Data Engineering — Fragmented data engineering tooling reduces productivity, especially in MDDE, necessitating an integrated IDE solution.
• TOON: Beyond JSON for LLMs — TOON offers a token-efficient structured data format specifically designed to optimize LLM context window usage over traditional JSON.

Open in AIssential →

Editorial summary, takeaway, and curation by AIssential. Original article published by Simon Willison's Weblog.