sweatybridge

3 ms·

1. 1.▲
   by sweatybridge 1y ago

   > it doesn’t tell you the consequences of changing an attribute (database restart or other downtime-inducing stuff) Modern diff tools are designed to provide better guardrails in these situations. For eg, pg-schema-diff [0] tries to gene
2. 2.▲
   by sweatybridge 1y ago

   > When they started integrating this tool on some trial candidates they found SO many inconsistencies between environments: server settings differences, extraneous or missing indexes, vestigial "temp" tables created during prev
3. 3.▲
   by sweatybridge 3y ago

   Thank you for the helpful feedback. > Using supabase migration up would mean moving the latest migration out of the migrations folder, running supabase db reset, moving the file back in and then calling supabase migration up. We can defi
4. 4.▲
   by sweatybridge 3y ago

   > if your latest migration is destructive - you want to seed data and then run the next migration. We have added supabase migration up [0] command that runs only pending migrations (ie. those that don't exist in local db's migr
5. 5.▲
   by sweatybridge 3y ago

   Hello, I work on CLI full time. Things have certainly improved over the last few months on using this tool for migrating self-hosted databases. Currently all supabase db and migration commands support --db-url flag [1] which allows you to p