How do your database migration/structure workflows look like?
🔢DB Connections🤷other
CLI
CLIWorking with a friend, I'm Fullstack and know a fair bit of PSQL - he is mostly Frontend but also has worked with Firebase and hence document databases before.
We are not yet public with our product, so for now it's only a
I understand that this question is somehow abstract, but I can't decide on what's the best way (probably subjective on how each of us likes to do things and team composition), but I'd love to hear opinions on how all of you manage your individual workflows regarding the database.
I went through the documentation and I feel like declarative schemas would be the way to go - what do you think? Does it work properly, are there any caveats and issues that might pop up from using those? All input appreciated - thanks
TLDR: What do you think is the best way to manage the database? Declarative schemas or individual migration files? And which commands from Supabase CLI do you use? Do you use the Supabase UI for changing database?
We are not yet public with our product, so for now it's only a
Staginghosted SupabaseDocker/migrations/*supabase db resetSupabase DB UII understand that this question is somehow abstract, but I can't decide on what's the best way (probably subjective on how each of us likes to do things and team composition), but I'd love to hear opinions on how all of you manage your individual workflows regarding the database.
I went through the documentation and I feel like declarative schemas would be the way to go - what do you think? Does it work properly, are there any caveats and issues that might pop up from using those? All input appreciated - thanks
TLDR: What do you think is the best way to manage the database? Declarative schemas or individual migration files? And which commands from Supabase CLI do you use? Do you use the Supabase UI for changing database?
