This release adds UI for creating tables and altering tables, to complement the insert and update row interfaces added in 1.0a34.
- New "Create table" interface in the database actions menu, backed by the
/<database>/-/createJSON API. It can define columns, primary keys, custom column types,NOT NULLconstraints, literal defaults, expression defaults and single-column foreign keys. (#2787) - New "Alter table" table action and
/<database>/<table>/-/alterJSON API for changing existing tables: add, rename, reorder and drop columns; change column types, defaults,NOT NULLconstraints, primary keys and foreign keys; and rename the table. The alter table dialog also includes a "Drop table" button. (#2788) - New
/<database>/-/foreign-key-targetsand/<database>/<table>/-/foreign-key-suggestionsJSON APIs for discovering valid single-column foreign key targets and suggested relationships. - New Template context documentation listing the variables available to custom templates for Datasette's core pages. Variables documented there are treated as a stable API for custom templates until Datasette 2.0. The documentation is generated from dataclass definitions next to the view code, with tests that compare the documented fields against the actual contexts rendered by the database, table, query and row pages. (#1510, #2127, #1477, #2803)
- The "Write to this database" page now includes a Create table starter template, alongside the existing Insert, Update and Delete templates. (#2794)
- New
static()template function anddatasette.static()method for generating cache-busting static asset URLs based on the file contents. Static assets served with a matching?_hash=parameter now receive far-future immutable cache headers. This works for Datasette's bundled static assets, plugin static assets and directories mounted using--static. See Linking to static assets. - Database and table pages now use the
count_truncatedtemplate context value to display capped row counts as>N rows. - Significant visual improvements to the table filter form UI, plus working add/remove filter buttons. (#2798)
- Improved edit row icon on table pages. (#2796)
- Documentation covers how actors are displayed. Thanks, Sebastian Cao. (#2002)
- Fix for bug where appending
?_col=pkresulted in duplicate primary key columns in the response. Thanks, Ritesh Kewlani. (#1975)