3 ms·
> db engineers approve the generated migration script yeah - this is definitely the intended flow here. We won't be recommending anyone blindly applying genera
by kiwicopple 2y ago
> db engineers approve the generated migration script
yeah - this is definitely the intended flow here. We won't be recommending anyone blindly applying generated migrations.
As you mention, it is expected that you generate & review on your local development machine, check into source control, push & merge. We've also been using this internally for ~2 years now and it works great
- pounderstanding 2y agoDo you keep the history of applied migrations? (Just in case subtle issue need to be investigated later)
- kiwicopple 2y agoyeah, migrations are generated from the Declarative files. For example, the steps are for adding a new column: 1/ Add a new column to the declarative file 2/ Generate a new migration: `supabase db diff -f my_new_migration` 3/ Review/edit the generated migration, check it into git 4/ Apply migration to database