News for hackers. Stuff that matters.
Re:Better Database Migrations in Postgres by neeleshs on Tuesday September 12, 2017 @11:49PM (#15235379)
For JVM languages, Flyway is quite popular (flywaydb.org) Django (python) has a builtin migration tool
Re:Better Database Migrations in Postgres by craigkerstiens on Tuesday September 12, 2017 @11:51PM (#15235391)
Original author here, thanks for sharing it. Will update the post to add it to the list of good tools.
Re:Better Database Migrations in Postgres by nblumhardt on Wednesday September 13, 2017 @12:01AM (#15235430)
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!)

Re:Better Database Migrations in Postgres by fulafel on Tuesday September 12, 2017 @11:53PM (#15235405)
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.

Re:Better Database Migrations in Postgres by iaabtpbtpnn on Wednesday September 13, 2017 @02:10AM (#15235940)
Oooh I use Flyway but did not know about this feature! It solves a big problem for me, thank you for mentioning it! :)