dbmate
dbmate copied to clipboard
Comparison of dbmate vs sqitch or flyway
Both sqitch and flyway are mature alternatives that would be good to add to your comparison, although they have somewhat larger requirements (Perl for sqitch, Java for flyway).
One of the things that’s really nice about sqitch
is that it has three pieces to each migration, each as a separate file:
- up
- down
- verify
The verify step encourages people to write a query that confirms that the migration happened successfully. It can also integrate with pgTAP
for Postgres, to enable unit testing.
Nice tools. Are you willing to propose a change in the comparison table by opening a pull request? :-)
I can do sqitch
(it’s what we use at work), but I know almost nothing about flyway except that it exists. I’ve also made sqitch
much easier to use for us by putting it in a Docker image complete with pgTAP
.
Good! We can integrate sqitch now, and then see if anyone else uses flyway :-)