|
|
|
|
|
by Shorel
1151 days ago
|
|
Store procedures and functions are very good for many things. I am not claiming you should put all your business logic in the database, like old-time Oracle consultants wanted (for self-serving reasons), but some calculations are better handled in a single place, instead of being reimplemented in different parts of the stack, or stacks, given that it is common to write a project using one framework and language, and then migrate to another one. The only reason to avoid SP is that you don't know any SQL and your ORM can't write the function calls, so you can't call them. Which is a general complaint I have about modern software development: many things are done in convoluted ways because some developers don't know SQL and don't want to learn it. |
|