Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris

Re: DBI Style Inquiry

by Tux (Abbot)
on Jun 27, 2013 at 10:15 UTC ( #1040979=note: print w/replies, xml ) Need Help??

in reply to DBI Style Inquiry

I agree with using consistent style is important, and in perl it is relatively easy to get to a consistent style using perltidy

Carve your preferences in ~/.perltidyrc and use whatever fits best to have the perltidy command do its job.

THINK about every setting. You do not have to agree with my choices, but if you take the time to read them, you will definitely agree AND disagree on several points.

I fully support mje's suggestion to connect with default attributes, like

my $dbh = DBI->connect ($dsn, $user, $pass, { RaiseError => 1, PrintError => 1, ChopBlanks => 1, ShowErrorStatement => 1, FetchHashKeyName => "NAME_lc", });

Enjoy, Have FUN! H.Merijn

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1040979]
[erix]: I'm not sure. I suppose you could compare behavior via DBD::Pg with behaviour of the naked SQL
[erix]: I mean, SQL with PREPARE
[choroba]: hmm... ok, will try
[choroba]: the documentation of PREPARE doesn't mention transactions at all :-/

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (8)
As of 2017-09-19 13:06 GMT
Find Nodes?
    Voting Booth?
    During the recent solar eclipse, I:

    Results (220 votes). Check out past polls.