Skip to content
TopicTracker
From simonwillison.netView original
TranslationTranslation

datasette 1.0a35

Datasette 1.0a35 has been released, introducing a new "Create table" interface and JSON API, an "Alter table" feature with table modification capabilities, and official documentation for template context variables as a stable API for custom templates until version 2.0.

Background

- Datasette is an open-source tool (by Simon Willison) that lets you explore and publish data from SQLite databases as a web interface, without needing to write code. - This release (1.0a35) is significant because it adds the ability to create and alter database tables through the web UI and JSON API — previously Datasette was read-only for table structure. - "Template context" is the set of variables that Datasette injects into its HTML templates; documenting them as a stable API means people who build custom templates can rely on them not breaking until the next major version (2.0).

Related stories

  • HtmlUnit 5.0.0 has been released, now requiring JDK 17 as the minimum version. Key updates include major JavaScript engine improvements, full Web Crypto API support, WebSocket improvements, Web Speech API support, and updated browser profiles for Firefox 150 and Chrome/Edge 148.

  • JsPlumb, the JavaScript library for building visual connectivity interfaces, has released a major update with a modernized API and new diagram/2D chart engines. The project is now free for non-commercial use, with packages available for React, Angular, Vue, Svelte, and vanilla JS on the public NPM registry.

  • Datasette-apps is a new system that allows users to bundle and install full applications within Datasette, turning it into a platform for data-driven apps. It enables developers to create self-contained packages combining SQLite databases, metadata, plugins, templates, and assets.