Do you test your database?

3 pointstrapatsas10y ago2 comments

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

2 comments

okket10y ago

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/

trapatsasOP10y ago

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

j / k navigate · click thread line to collapse