Thread: DBD::Pg vs Pg.pm

DBD::Pg vs Pg.pm

From
"Culley Harrelson"
Date:
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

Re: DBD::Pg vs Pg.pm

From
Doug McNaught
Date:
"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