DBD::Pg vs Pg.pm

Started by Culley Harrelsonover 24 years ago2 messagesgeneral
Jump to latest
#1Culley Harrelson
Culley_Harrelson@pgn.com

Are there any significance performance differences between DBD::Pg and going directly to Pg.pm. I wasn't even aware that there was a difference till I recently... The interface difference between the two are drastic.

culley

#2Doug McNaught
doug@wireboard.com
In reply to: Culley Harrelson (#1)
Re: DBD::Pg vs Pg.pm

"Culley Harrelson" <Culley_Harrelson@pgn.com> writes:

Are there any�significance performance differences�between DBD::Pg�and going
directly to�Pg.pm.� I wasn't even aware that there was a difference till I
recently...� The interface difference between the two are drastic.

I wouldn't imagine that there's much of a difference. The main
advantage of the DBD module is that it fits into the DBI framework
which uses a common interface for many different databases. So if you
had a Perl script using a proprietary database through DBI, you could
convert it fairly easily to use Postgres (depending on how much
non-standard SQL and server-side stuff you were doing).

DBI is the "recommended" way to use databases from Perl but Pg.pm
works fine AFIAK.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863