Ruby on Rails chases simplicity in programming

TalkBack 33 of 34:

Next »

« Previous

• Thread View
• Flat View

This is not serious development

I'm sorry, I know that this is an old thread and that what I'm going to say may offend some of you, but I can't just let this nonsense go.

First, stored procedures should not be shared outside of a project group. That they sometimes are is a problem not related to the use of stored procedures and does not impeach the use of stored procedures.

Second, for you to claim that you've "... never seen it substantiated" indicates that you are being either disingenuous (which I don't believe you are) or that you have either never worked on an application of any substance or have never bothered to take performance metrics, probably both. To question the performace improvement potential inherent in stored procedures is sophmoric and must be taken with a grain of salt by any database developer of any experience.

Third, yes developers can and often do send hundreds of lines of SQL code over the network. Yes, they are implementing business logic in the application layer which is the only place to put most of it if you disallow the use of the middle layer of stored procedures. Yes, yikes is right. That's the point. The fact that you act surprised by this concept simply reinforces my idea of your level of experience in this field.

Last, I can scarecy think of an example of a properly developed application where you would NOT want to restrict all users from direct access to the tables of the database, requiring them to access through stored procedures only. This is the best way to prevent users and application layer developers from corrupting the database while still allowing them to access it.

Posted by: SQLDBAJames   Posted on: 05/29/06 You are currently: a Guest | Members login | Terms of Use

Alert moderator to an offensive message

Subscribe to this discussion via Email or RSS

SponsoredWhite Papers, Webcasts, and Downloads

• VMware Infrastructure: A Guide to Bottom-Line Benefits VMware Frustrated by the costs of maintain ever larger data centers?or building ... Download Now
• Three Steps You Need to Know to Stop Data Loss Varonis Sensitive data exposed to misuse or loss... it is the stuff of nightmares ... Download Now
• Building the Virtualized Enterprise with VMware Infrastructure VMware VMware virtualization software has been adopted by over 120,000 enterprise ... Download Now