Week 46, year 2015

• Is SQL a good place for business logic? - <TL;DR> No, it isn’t. While SQL is a Turing-complete language and we can use it to encode any business logic we want, placing business (domain) logic into SQL leads to a less maintainable solution comparing to one that uses an OO or functional language. Because of that, I advocate to limit the use of SQL to read-only queries (which can potentially contain business logic, that’s fine) and simple CRUD statements where possible. [Enterprise Craftsmanship]

Permalink | From 09 November 2015 to 15 November 2015 | Last updated on: Mon, 7 Jun 2021 09:11:15 GMT