I will write extra about this one quickly, nevertheless it’s a giant launch. Three highlights from the discharge notes:
New “Create desk” interface within the database actions menu, backed by the //-/create JSON API. It may possibly outline columns, main keys, customized column sorts, NOT NULL constraints, literal defaults, expression defaults and single-column international keys. (#2787)
New “Alter desk” desk motion and ///-/alter JSON API for altering current tables: add, rename, reorder and drop columns; change column sorts, defaults, NOT NULLconstraints, main keys and international keys; and rename the desk. The alter desk dialog additionally features a “Drop desk” button. (#2788)
New Template context documentation itemizing the variables obtainable to customized templates for Datasette’s core pages. Variables documented there are handled as a steady API for customized templates till Datasette 2.0. The documentation is generated from dataclass definitions subsequent to the view code, with exams that evaluate the documented fields towards the precise contexts rendered by the database, desk, question and row pages. (#1510, #2127, #1477, #2803)This is a tough video demo I made from the brand new create/alter desk characteristic as a part of reviewing the PR:
