datasette-edit-schema

• Fixed CSS for compatibility with upcoming Datasette 1.0 alpha. datasette#2417

• Table names are now tilde-encoded, ensuring tables with unconventional characters like / and . in their names can still be linked to correctly. #61
• Fixed a bug where tables with unconventional names could not be configured as foreign keys. #62

• To rename a table users must now have drop-table permission for the old name and create-table permission for the new name. #60
• Action menu items now have descriptions in addition to labels.

This release introduces support for finely grained per-database and per-table permissions, plus integration with the new Datasette Events mechanism added in Datasette 1.0a8.

• This release requires Datasette 1.0a9 or higher.
• Finely grained permissions: the edit-schema permission is still supported, but you can also control access to this plugin using the create-table, drop-table and alter-table permissions from Datasette core. These can be used to control access on a per-table and per-database level. #22, #55
• Now tracks create-table, alter-table and drop-table events using the new Datasette Events system introduced in Datasette 1.0a8. #50
• Primary keys can now also be set as foreign keys, useful for many-to-many relationship tables. #52
• Now runs VACUUM using db.execute_isolated_fn() to avoid being caught out by any connection permission handlers. #47
• Tightened up display on mobile screens. #45
• Fixed a bug where the SQL schema for a table was not shown correctly on the edit schema page. #49
• Fixed a 500 error if a table only consists of primary keys. #51

• Fixed a bug where editing a schema raised a 500 error if any of the table column names included a single quote. #43

• Ability to add an index (or a unique index) to a column on a table. #27
• Ability to drop an index from a table.

New features:

• Create a new table, setting the name of the primary key and adding multiple columns of different types. #5
• Set or change the primary key for a table. #1
• Add and edit foreign key relationships for a table. #7
• When altering a table, each column now shows a small sample of example values to help you decide the column's new name and type. #28
• Delete table button now asks for confirmation. #41

• Ability to create a new table. #5

• Ability to set or update a table's primary key. #1

• Preview of add and edit foreign keys. #7

• Fix for an error that occurs if you try to drop a column from a table that is part of a SQL view. #35

• Improved breadcrumbs for compatibility with Datasette 0.63+.

• Fixed error trying to add new floating point columns to a table. #34

• More human-friendly labels for column types. #29
• edit-schema permission check now considers the database name. #32
• Now depends on datasette>=0.59 #30 and sqlite-utils>=3.10. #33

• Registers a table action using the new table_actions() plugin hook in Datasette 0.51. #26

• Registers a table action using the new table_actions() plugin hook. #26

• First non-alpha release.
• Ability to rename a table. #19
• Improved ability to add a column. #4

• Renamed to datasette-edit-schema. #20
• Now controlled by edit-schema permission. #9
• Improved /-/edit-schema/databasename page. #15
• Now ships with a copy of Draggable.js. #16
• Interface links back to table page. #18

• Fix bug with editing column types. #17

• First prototype of transform table interface. #11