Business logic / Rules embedded in SQL DB
Posted: Tue Jan 23, 2018 1:39 pm
I am not sure if this is the forum for this topic but here goes.
While I was planing the design for a client service management system, This adea dawned on me.
Why not have a large portion of the business logic embedded in the SQL database. So I am reaching out to you guys for advice. Please bare in mind that while pondering on this, the Idea is not to put yourself in the shoes of a large corporation but small startup small to medium enterprise. I am sure the the larger companies can afford to employ SQL DBA's with the skillset and many years of experience to design a system to achieve this. I would really like for a sort of pros and cons type of response with an explanation why it is better or not, to have a large portion of the business logic in SQL database. My knowledge of sql scripting is minimal and this is already one reason why I would be hesitant to go this route.
Have fun.
Peter G
While I was planing the design for a client service management system, This adea dawned on me.
Why not have a large portion of the business logic embedded in the SQL database. So I am reaching out to you guys for advice. Please bare in mind that while pondering on this, the Idea is not to put yourself in the shoes of a large corporation but small startup small to medium enterprise. I am sure the the larger companies can afford to employ SQL DBA's with the skillset and many years of experience to design a system to achieve this. I would really like for a sort of pros and cons type of response with an explanation why it is better or not, to have a large portion of the business logic in SQL database. My knowledge of sql scripting is minimal and this is already one reason why I would be hesitant to go this route.
Have fun.
Peter G