Cool,
We use liquibase I wonder how this compares to it?
Also, how do you handle the back filling on columns, how you make sure you don't miss any data before dropping the old column?
Also, how do you handle the back filling on columns, how you make sure you don't miss any data before dropping the old column?
Backfilling happens in batches, we use the PK of the table to update all rows, a trigger is also installed so any new insert/update executes the backfill mechanism to update any new column.
More details can be found here: https://github.com/xataio/pgroll/blob/main/pkg/migrations/ba...