Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re: What use DBI?

by moritz (Cardinal)
on Mar 12, 2013 at 21:07 UTC ( #1023050=note: print w/ replies, xml ) Need Help??


in reply to What use DBI?

Some random thoughts:

  • Security: passing passwords on the command line is insecure, because other users can see them with ps and related tools
  • Security: getting the escaping right is non-trivial
  • Correctness: getting the parsing of the results right is non-trivial. As far as I can tell there's no reliable way to parse the output from the mysql command line tool, because it doesn't escape "special" characters
  • Performance: spawning a new process for each query is costly
  • Correctness: You don't check for errors at all.


Comment on Re: What use DBI?
Download Code

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (6)
As of 2015-07-04 17:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (60 votes), past polls