Re: theory and practice: ying and yang
From: Kenneth Downs <knode.wants.this_at_see.sigblock>
Date: Tue, 31 May 2005 12:10:27 -0400
Message-Id: <i0fum2-icd.ln1_at_pluto.downsfam.net>
>
> Declarative code should be favoured over procedural code.
>
> Stored procedures should be used as a last resort to implement
> business rules.
>
> End of story.
Date: Tue, 31 May 2005 12:10:27 -0400
Message-Id: <i0fum2-icd.ln1_at_pluto.downsfam.net>
Alfredo Novoa wrote:
>> >>My thesis is that if you take this migration to its logical >>conclusion there may be achievable an optimal stage in >>which *all* application software in internal to the DBMS >>in the form of stored procedures.
>
> Declarative code should be favoured over procedural code.
>
> Stored procedures should be used as a last resort to implement
> business rules.
>
> End of story.
But then you have the classic loophole problem. As soon as you allow that Sprocs are used for "last resort", you have to spell out the conditions under which they can be used and suddenly everyone is claiming they've got a special case and *must* use a sproc.
This is why you have to support them either entirely and systematically, or not at all, you can't have "last resort" case.
-- Kenneth Downs Secure Data Software, Inc. (Ken)nneth_at_(Sec)ure(Dat)a(.com)Received on Tue May 31 2005 - 18:10:27 CEST