3 ms·
"Completely" as in you'd put ALL your business logic in the db, or that you're open to pushing SOME to it? Most? EDIT: It's genuine question. I use views and
by sodapopcan 4y ago
"Completely" as in you'd put ALL your business logic in the db, or that you're open to pushing SOME to it? Most?
EDIT: It's genuine question. I use views and write a decent amount of business logic as queries (well, in my language's query DSL). It's always bugged me when people do a lot of post-processing for stuff that the db could do faster.
- PKop 4y agoThere's perhaps an interesting 3rd option aside from full stored procedures vs pure application code transformating data pulled down from database... where the processing and transformation is still handled with SQL, but this code and the interaction with the database resides in application code. So instead of triggers and stored procedures, you have database transactions defined in and called from application code.