Postgres Pull Request Review
🟢SQL
What is the easiest way to review pull requests for Postgres database changes?
I'm reviewing my first pull request from the first additional developer (besides me) and haven't found a clean way to do it. Because each change is a "migration" script, a change to a function just shows the new code rather than the changes.
Is there a simple, clean way to see what the definition for a database object was before, what it is now, and what the changes were?
When I used to work with SQL Server, they had a tool in Visual Studio called Schema Compare that allowed you to compare database definitions in code. I'm assuming that something like that exists for Postgres (and if I should use that I'd love to know), but that would mean not using the native Supabase version control functionality, at least for the DDL.
I'm reviewing my first pull request from the first additional developer (besides me) and haven't found a clean way to do it. Because each change is a "migration" script, a change to a function just shows the new code rather than the changes.
Is there a simple, clean way to see what the definition for a database object was before, what it is now, and what the changes were?
When I used to work with SQL Server, they had a tool in Visual Studio called Schema Compare that allowed you to compare database definitions in code. I'm assuming that something like that exists for Postgres (and if I should use that I'd love to know), but that would mean not using the native Supabase version control functionality, at least for the DDL.
