Hacker News Reader

For JVM languages, Flyway is quite popular (flywaydb.org) Django (python) has a builtin migration tool

Original author here, thanks for sharing it. Will update the post to add it to the list of good tools.

Another x-plat CLI option is Piggy - https://github.com/datalust/piggy - a side-project still early days of development, but may be interesting for the lack of (e.g. JVM) dependencies. It's a self-contained binary for Win/Mac/Linux.

DbUp, upon which Piggy is based, is a popular option in the .NET space: https://dbup.github.io/.

(Neither attempt the protections that I think strong_migrations is offering - TIL!)

It works well as a command line tool, so not even restricted to JVM languages.

One strong point of Flyway, besides being "just SQL", is the repeatable migrations, you can update your stored procedures, views and table documentation in the same version controlled source files without making a new copy in a new migration file for each change.

Oooh I use Flyway but did not know about this feature! It solves a big problem for me, thank you for mentioning it! :)

Reply on news.ycombinator.com