Hacker News Reader

Half of the problems in this article are migration related.

I am extremely grateful that some people have created awesome libraries like strong migrations https://github.com/ankane/strong_migrations.

Even if you are not using rails, you can bookmark its readme, it is an awesome cheat-sheet on how to do common database migrations.

View on HN

You might also be interested in Reshape, a tool I’ve been working on to automate zero-downtime deployments with Postgres: https://github.com/fabianlindfors/reshape

In terms of automating migrations in postgres, I really want declarative migrations and only the safe subset too. The overhead of having a schema defined over a bunch of migrations seems non ideal.

The closest tool I've found here is: https://atlasgo.io/

Sqitch probably does what you want?

Awesome will be adding this gem to my current rails backend.

Reply on news.ycombinator.com