from Hacker News

Do you test your database?

by trapatsas on 3/20/16, 10:39 AM with 2 comments

Do you test your SQL/database? Do you unit test your stored procedures? What tools do you use for functionality/performance testing?

  • by okket on 3/20/16, 11:05 AM

    For PostgreSQL, I'm using David Wheelers pgTAP (unit testing framework) and Sqitch (git inspired change management). For other DBs, Sqitch at least provides sanity checks for structure/design stage.

    http://pgtap.org/

    http://sqitch.org/