Database migrations sound difficult but are even more difficult in practice.
I’ve never run a down migration.
90%+ of DB migrations I’ve seen go wrong involve a drop (column or table) without compatible code deployed. You can’t just put it back!
What do you think of: https://xata.io/blog/pgroll-schema-migrations-postgres
I guess that why event sourcing is picking up. No state maintenance just store the events as-is. Build the state when you need it, i know it has the same issues but tolling is better now
I’ve never run a down migration.
90%+ of DB migrations I’ve seen go wrong involve a drop (column or table) without compatible code deployed. You can’t just put it back!
What do you think of: https://xata.io/blog/pgroll-schema-migrations-postgres
I guess that why event sourcing is picking up. No state maintenance just store the events as-is. Build the state when you need it, i know it has the same issues but tolling is better now