Skip to content

Releases: simonw/datasette-edit-schema

0.8a3

03 Sep 16:35
Compare
Choose a tag to compare
0.8a3 Pre-release
Pre-release
  • Fixed CSS for compatibility with upcoming Datasette 1.0 alpha. datasette#2417

0.8a2

24 Apr 04:07
a24a963
Compare
Choose a tag to compare
0.8a2 Pre-release
Pre-release
  • 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

0.8a1

14 Mar 02:31
Compare
Choose a tag to compare
0.8a1 Pre-release
Pre-release
  • 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.

0.8a0

18 Feb 22:20
Compare
Choose a tag to compare
0.8a0 Pre-release
Pre-release

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

0.7.1

04 Nov 21:22
Compare
Choose a tag to compare
  • Fixed a bug where editing a schema raised a 500 error if any of the table column names included a single quote. #43

0.7

26 Oct 00:49
Compare
Choose a tag to compare
0.7
  • Ability to add an index (or a unique index) to a column on a table. #27
  • Ability to drop an index from a table.

0.6

09 Sep 00:20
Compare
Choose a tag to compare
0.6

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

0.6a2

07 Sep 15:54
Compare
Choose a tag to compare
0.6a2 Pre-release
Pre-release
  • Ability to create a new table. #5

0.6a1

06 Sep 23:26
Compare
Choose a tag to compare
0.6a1 Pre-release
Pre-release
  • Ability to set or update a table's primary key. #1

0.6a0

06 Sep 22:30
Compare
Choose a tag to compare
0.6a0 Pre-release
Pre-release
  • Preview of add and edit foreign keys. #7