Re: "Business Logic / Rules should never be in the database or stored procedures"
From: Thomas Kellerer <OTPXDAJCSJVU_at_spammotel.com>
Date: Sun, 13 Dec 2009 09:24:19 +0100
Message-ID: <7ojmliF3nvgjmU1_at_mid.individual.net>
> rules/logic in the database tend to be developers
> who are essentially lazy and refuse to learn anything about the
> database or its facilities. They just want to use it as a bit bucket
> and do absolutely everything in the application layer. Too often, this
> even includes basic data manipulation that could have been done more
> efficiently and resulted in clearer and more easily maintained code
> using SQL. This situation appears to have gotten worse with the growth
> in popularity of Java - essentially, code monkeys who just want to
> plug in API calls and who have no interest in learning all the tools
> available to them. they have mastered basic select, update and insert
> and thats as far as they want to go. When you are coming from this
> perspective, stored procedures are really just a way to make SQL
> 'easier and you get the CRUD way of thinking.
Date: Sun, 13 Dec 2009 09:24:19 +0100
Message-ID: <7ojmliF3nvgjmU1_at_mid.individual.net>
> * In my experience, those who argue for not having any business
> rules/logic in the database tend to be developers
> who are essentially lazy and refuse to learn anything about the
> database or its facilities. They just want to use it as a bit bucket
> and do absolutely everything in the application layer. Too often, this
> even includes basic data manipulation that could have been done more
> efficiently and resulted in clearer and more easily maintained code
> using SQL. This situation appears to have gotten worse with the growth
> in popularity of Java - essentially, code monkeys who just want to
> plug in API calls and who have no interest in learning all the tools
> available to them. they have mastered basic select, update and insert
> and thats as far as they want to go. When you are coming from this
> perspective, stored procedures are really just a way to make SQL
> 'easier and you get the CRUD way of thinking.
Completely agree
And things like Hibernate tend to make this situation even worse as people ge the impression they don't need to think about the database anymore "because Hibernate takes care of that" Received on Sun Dec 13 2009 - 02:24:19 CST