Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: Leashing DBI

by jorg (Friar)
on Jun 27, 2001 at 02:33 UTC ( #91770=note: print w/replies, xml ) Need Help??


in reply to Leashing DBI

I kindof see where you're coming from, as SQL is a different language it 'pollutes' your cleanly written lines of perl. And whether you're putting them at the beginning of your program as constants (like Masem points out) or you wrap some interface around it there is always some sort of SQL dependency left in the code.

My preferred way of doing things is to stick the SQL in the database as stored procedures (if the database supports it) or in .sql files which we can invoke through a commandline system call.

Jorg

"Do or do not, there is no try" -- Yoda

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (3)
As of 2021-09-28 16:14 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?