Hacker News Reader

This was discussed here recently: https://github.com/djrobstep/migra

I haven't used it, but it fits your request of a postgresql specific migration tool where you don't have to futz with manually writing migration scripts.

Thanks!

I did look at that, think I was participant in last discussion but somehow it got lost in the bookmarks.

It doesn't have rollbacks (that I can see) but maybe it is good enough (aka better than Alembic migrations). It appears to deal with actual SQL rather than models which is nice. Will check it out.

I wrote a simple solution for this which is used in production at several businesses now: https://github.com/purcell/postgresql-migrations/

I like the idea of this approach (for anyone else interested in the topic).

https://news.ycombinator.com/item?id=19105159

But it does seem like a lot more work when rapidly iterating schema.

Have you looked at Sqitch? It’s the most flexible, but also low level.

Had not. Thank you!