Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1023050]
help
Chatterbox?
[marioroy]: Is List::Util::XS a core Perl module?
[stevieb]: corelist List::Util::XS says "List::Util::XS was first released with perl v5.10.1"
[stevieb]: so yes, since v5.10.1 :)
[MidLifeXis]: According to [metaperl:// corelist], Perl 5.10.1
Lady_Aleena blurbles. One of her favorite modiles is now in "maintenance mode" in favor of a new fangled module.
[MidLifeXis]: D'oh. Slow out of the gate.
[marioroy]: Thanks stevieb, MidLifeXis.

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (12)
As of 2017-05-24 17:52 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?