Ruby on Rails chases simplicity in programming

TalkBack 17 of 34:

Next »

« Previous

• Thread View
• Flat View

Varying opinions

There are varying opinions. Stored procedures are tied to the database and thus make the database part of the application. Since the stored procedures are database spesific, you can't copy them between different database vendor products.

If you are selling packaged software, you don't want anything to do with stored procedures for that particular reason. You want your stuff to work on many databases.

If you are developing software for a company that has vendor independence requirements like many companies do, then you better make software that runs on all major databases. These companies want to keep the vendors on their toes to negotiate the best price. If you are married to one vendor, you have no good way to negotiate, and have to cough up the 'extortion premium'. These days, that does not fly.

What comes to writing database software - you don't have to write inline SQL at all. You can have all queries tucked away in config files (xml for example). Nothing is copied or duplicated.

So it is a matter of taste, within one application, if you are going to use stored procedures or not. Sometimes you have to use them because they solve problems that inline sql does not (performance, some heavy lifting in database that has to do with organizing data). In general, there is no significant performance advantage for simple stored procedures, so using them boils down to convenience and often it is more convenient to do the work in a proper programming language.

Posted by: tero_t_vaananen@...   Posted on: 11/01/05 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

• The Impact of Virtualization Software on Operating Environments VMware Today's use of virtualization technology allows IT professionals to ... Download Now
• Building the Virtualized Enterprise with VMware Infrastructure VMware VMware virtualization software has been adopted by over 120,000 enterprise ... 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