Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on For Want of a JOIN. Parent comment
As for testing in the Postgres sphere, there's pgTAP and pg_prove. https://pgtap.org/
Extension development includes a built-in unit testing harness as well.
For use with any database, a tool like Sqitch allows for DB-agnostic verification at each migration point. https://sqitch.org/docs/manual/sqitchtutorial/#trust-but-ver...
Proprietary databases have their own solutions as well. https://learn.microsoft.com/en-us/sql/ssdt/walkthrough-creat...
I think "utter lack" is grossly misrepresenting the state of the art. If you mean "widespread ignorance of existing techniques related to composability or testability," then we are in agreement.
There are no comments on this comment yet.
As for testing in the Postgres sphere, there's pgTAP and pg_prove. https://pgtap.org/
Extension development includes a built-in unit testing harness as well.
For use with any database, a tool like Sqitch allows for DB-agnostic verification at each migration point. https://sqitch.org/docs/manual/sqitchtutorial/#trust-but-ver...
Proprietary databases have their own solutions as well. https://learn.microsoft.com/en-us/sql/ssdt/walkthrough-creat...
I think "utter lack" is grossly misrepresenting the state of the art. If you mean "widespread ignorance of existing techniques related to composability or testability," then we are in agreement.