tusken icon indicating copy to clipboard operation
tusken copied to clipboard

Published 20 hours ago • verified publisher icon alloc

Migration generator

Open aleclarson opened this issue 3 years ago • 1 comments

Create a plugin package that adds triggers to system tables. These triggers will be used to track added/updated/renamed/deleted columns and such. This event data is used to generate migration scripts (written in TypeScript with Tusken 😄 ). Those migration scripts are used by tusken migrate to generate SQL for graphile-migrate.

For column type changes that require a handwritten expression, you can edit a migration script directly or add a blank one (should we recommend a VS Code plugin that can create a blank migration script from a pre-defined template?).

aleclarson avatar Sep 10 '22 04:09 aleclarson

Possibly worth taking inspiration from pg-differ

aleclarson avatar Sep 11 '22 19:09 aleclarson