Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re^3: Abstracting SQL without Stored Procedures

by dragonchild (Archbishop)
on Sep 29, 2004 at 19:48 UTC ( [id://395114]=note: print w/replies, xml ) Need Help??


in reply to Re^2: Abstracting SQL without Stored Procedures
in thread Abstracting SQL without Stored Procedures

Then, your Private:: idea is about the best you're going to get. SQL::Catalog might be of some service.

Frankly, it might even be best to store your queries in the database itself and pre-load them when the app starts up. *shrugs*

Being right, does not endow the right to be rude; politeness costs nothing.
Being unknowing, is not the same as being stupid.
Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence.
Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.

I shouldn't have to say this, but any code, unless otherwise stated, is untested

  • Comment on Re^3: Abstracting SQL without Stored Procedures

Replies are listed 'Best First'.
Re^4: Abstracting SQL without Stored Procedures
by mpeppler (Vicar) on Sep 30, 2004 at 05:55 UTC
    Frankly, it might even be best to store your queries in the database itself and pre-load them when the app starts up. *shrugs*
    But if you do that - make sure that you actually keep the source to that information in operating system files, preferably under source control. Have the SQL specialist edit these files and load them to the data server as needed (and after thorough testing, of course).

    Michael

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others romping around the Monastery: (1)
As of 2024-04-19 18:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found