Comparison of dbmate vs sqitch or flyway

[halostatue]

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).

[halostatue]

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.

[Enrico204]

Nice tools. Are you willing to propose a change in the comparison table by opening a pull request? :-)

[halostatue]

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.

[Enrico204]

Good! We can integrate sqitch now, and then see if anyone else uses flyway :-)