Do you test your database?

3 pointstrapatsas2 comments

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

View on HN

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/

Good to hear! Although, I really have a strong feeling that only a small minority really tests SQL/databases.

Reply on news.ycombinator.com