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

Re^3: Abstracting SQL without Stored Procedures

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

This is an archived low-energy page for bots and other anonmyous visitors. Please sign up if you are a human and want to interact.


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 01: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
Sections?
Information?
Find Nodes?
Leftovers?
    Notices?
    hippoepoptai's answer Re: how do I set a cookie and redirect was blessed by hippo!
    erzuuliAnonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.