It’s Time to Get Over That Stored Procedure Aversion You Have
rob.conery.io
rob.conery.io
It seems almost a tautology to me that of course you want to put all the data-related functionality in the database and of course you want the application business logic to be as small as possible and not enforce data integrity at the application level.
But a lot of this perspective comes from the long tail of hard-won experience and is not obvious to a lot of developers.