HN Explorer

Do you test your database?

3 points by trapatsas ↗ HN
Do you test your SQL/database? Do you unit test your stored procedures? What tools do you use for functionality/performance testing?

2 comments

[ 3.2 ms ] story [ 15.5 ms ] thread
okket
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/

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