3 ms·
What I'd like is a postgres specific migration scheme that let me take advantage of a lot of cool (and unique) features postgres has without fighting with gener
by mythrwy 8y ago
What I'd like is a postgres specific migration scheme that let me take advantage of a lot of cool (and unique) features postgres has without fighting with general purpose ORMs or having to manually edit migration files.
- kronin 8y agoThis was discussed here recently: https://github.com/djrobstep/migra 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.
- deleted 8y ago[deleted]
- mythrwy 8y agoThanks! 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.
- mythrwy 8y agoI like the idea of this approach (for anyone else interested in the topic). https://news.ycombinator.com/item?id=19105159 https://news.ycombinator.com/item?id=19105159 But it does seem like a lot more work when rapidly iterating schema.
- moltar 8y agoHave you looked at Sqitch? It’s the most flexible, but also low level.
- mythrwy 8y agoHad not. Thank you!
- sanityinc 8y agoI wrote a simple solution for this which is used in production at several businesses now: https://github.com/purcell/postgresql-migrations/ https://github.com/purcell/postgresql-migrations/