4 ms·
It is interesting that nobody has mentioned testability, as in unit tests. Some people (such as Thoughtworks) advocate removing all business logic from the db
by adamconroy 13y ago
It is interesting that nobody has mentioned testability, as in unit tests. Some people (such as Thoughtworks) advocate removing all business logic from the db server into app code so that it can be unit tested.
I buy that argument to some degree but in practice I am SQL junkie and always implement calculations in SQL.
- chris_wot 13y agoThere are tools that allow for unit testing for SQL. One that pops to mind is RedGate's tools. They wrote a white paper on it here: http://download.red-gate.com/HelpPDF/DatabaseUnitTestingWithRedGateSQLTools.pdf http://download.red-gate.com/HelpPDF/DatabaseUnitTestingWith... P.S. I'm not affiliated with them in any way, I just love their products.