Do you test your database?

3 points by trapatsas 10 years ago | 2 comments

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

okket 10 years 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/

trapatsas 10 years ago | |

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