Datasette 1.0a31 发布,新增执行写查询和保存存储查询的功能。用户需拥有相应权限,可对数据库执行插入、更新、删除操作,并保存查询供其他用户使用。博客文章已详细介绍新特性。
Release: datasette 1.0a31
Another significant alpha release, with two new headline features.
Datasette now offers users with the necessary permissions the ability to both execute write queries against their database and to save stored queries (renamed from "canned queries") both privately and for use by other members of their Datasette instance.
There's more detail in SQL write queries and stored queries in Datasette 1.0a31 on the Datasette blog, which now has three posts introducing new features since the blog launched two weeks ago.
Here's an animated demo from the blog post showing how the new execute query interface lets people get started with templated insert/update/delete queries from tables they have permission to edit:
Tags: projects, sql, sqlite, datasette, annotated-release-notes