4 ms·

This sounds like something Sqitch would help with. http://sqitch.org http://sqitch.org

• bigpeopleareold 12y ago
  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.)
• mbucc 12y ago
  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 https://github.com/naquad/shmig
  • justtheory 12y ago
    Please file a bug report. https://github.com/theory/sqitch/issues https://github.com/theory/sqitch/issues.
• shkkmo 12y ago
  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.