News for hackers. Stuff that matters.

A comment on Show HN: Stellar – Git for PostreSQL and MySQL. Parent comment

Re:Show HN: Stellar – Git for PostreSQL and MySQL by baudehlo on Friday August 22, 2014 @08:58AM (#8211879)
This sounds like something Sqitch would help with.

http://sqitch.org

[ Parent | on HN ]
Re:Show HN: Stellar – Git for PostreSQL and MySQL by mbucc on Friday August 22, 2014 @12:08PM (#8212690)
FWIW, I found shmig [1] much simpler than sqitch.

Last I used sqitch, it returned a zero value on error, which made me leery of using it for scripted deployments.

[1] https://github.com/naquad/shmig

[ Parent | on HN ]
Re:Show HN: Stellar – Git for PostreSQL and MySQL by justtheory on Sunday August 24, 2014 @02:11PM (#8219197)
Please file a bug report. https://github.com/theory/sqitch/issues.
[ Parent | on HN ]
Re:Show HN: Stellar – Git for PostreSQL and MySQL by shkkmo on Friday August 22, 2014 @02:33PM (#8213329)
Sqitch sounds like just another migration tool, not a DB change tracking tool.

I have been looking for a tool that will allow me to track, diff and revert changes to the content of specific "business logic" tables so that we can acurately track and test those changes.

It doesn't look like anything like that exists, so eventually I'll have to roll my own.

[ Parent | on HN ]
Re:Show HN: Stellar – Git for PostreSQL and MySQL by bigpeopleareold on Friday August 22, 2014 @11:23AM (#8212491)
I back up this recommendation whole-heartedly. Sqitch is a fantastic database tool. I stopped using Rails-type migrations because of it (I write PL/pgSQL functions and wanted a migration tool to handle that well, amongst other reasons.)
[ Parent | on HN ]