Re:Declarative Schemas for simpler database management
by pounderstanding on Thursday April 03, 2025 @04:32PM
(#43575006)
Do you keep the history of applied migrations? (Just in case subtle issue need to be investigated later)
Re:Declarative Schemas for simpler database management
by kiwicopple on Thursday April 03, 2025 @04:37PM
(#43575070)
yeah, 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
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