Skip to content

1.0a35

Pre-release
Pre-release

Choose a tag to compare

View all tags
@simonw simonw released this 23 Jun 21:34
· 1 commit to main since this release
1.0a35
488c9cf

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 NULL constraints, literal defaults, expression defaults and single-column foreign keys. (#2787)
  • New "Alter table" table action and /<database>/<table>/-/alter JSON 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-targets and /<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 and datasette.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_truncated template 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=pk resulted in duplicate primary key columns in the response. Thanks, Ritesh Kewlani. (#1975)
Assets 2
Loading