Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

Re: Re: The crime under reusability

by Jenda (Abbot)
on Dec 01, 2003 at 14:16 UTC ( #311239=note: print w/replies, xml ) Need Help??

in reply to Re: The crime under reusability
in thread The crime under reusability

Yep. As derby proposes ... write the SQL as optimal as you can, wrap it up as stored procs and then generate the DAO. In the project I spend most of my time on we have some 700 stored procs that need to be accessed from ASP and VB code ... what could be easier than to whip up some Perl code that'll connect to the database, load the info about the stored procs and generate the whole data access layer.

Sure the layer will not be any dandy OO, but if you wanted that you could put another layer on top of this thing very easily. I never felt the need.

Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live.
   -- Rick Osborne

Edit by castaway: Closed small tag in signature

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://311239]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (2)
As of 2022-08-14 16:15 GMT
Find Nodes?
    Voting Booth?

    No recent polls found