Thread

1. PostgreSQL and DBI/DBD...vs Pg.pm

   D. Dante Lorenso <dlorenso@afai.com> — 1998-03-05T19:50:39Z

   I'm getting confused between the methods of connectivity with PERL.
   Right now I'm accessing several MySQL tables using DBI/DBD. However,
   I'd like to convert these programs into PostgreSQL apps.  So, I'm
   assuming that since I used DBI (a common database connection format)
   that I'd only have to change the connect string to point to the
   PostgreSQL source rather than MySQL and all should be good.
   
   So, what is Pg.pm? and how is that connected (if at all) to DBI?
   I'm running 6.3 on Redhat 5, and psql seems to work Ok.  I look in the
   src/interfaces/perl5/ and All I see are files for Pg...and nothing
   mentions DBI.  Then, I search Altavista and come up with this in the
   latest from CPAN under DBI:
   
   http://www.perl.com/CPAN-local/modules/by-category/07_Database_Interfaces/DB
   D/DBD-Pg-0.68.readme
   
   Ok, so the source for PG.pm is version 1.7.0 or so, and the version of this
   DBD-Pg is 0.68.  Do these numbers have ANYTHING to do with each other,
   or are they two separate products?  Which one do I need, and if I need
   the DBD from CPAN (as I suspect), will it work with 6.3?
   
   Dante
   
   .------------------------------------------.-----------------------.
   |  _ dlorenso@afai.com - D. Dante Lorenso  | Network Administrator |
   | | |    ___  _ _  ___  __ _  ___  ___     |                       |
   | | |__ / o \| '_|/ o_\|  \ |\_ _\/ o \    | Accounting Firms      |
   | |____|\___/|_|  \___/|_|\_|\___|\___/    | Associated, inc.      |
   | http://www.afai.com/~dlorenso            | http://www.afai.com/  |
   '------------------------------------------'-----------------------'
   
   
   

2. Re: [HACKERS] PostgreSQL and DBI/DBD...vs Pg.pm

   Mattias Kregert <matti@algonet.se> — 1998-03-06T10:58:30Z

   D. Dante Lorenso wrote:
   > 
   > I'm getting confused between the methods of connectivity with PERL.
   > Right now I'm accessing several MySQL tables using DBI/DBD. However,
   > I'd like to convert these programs into PostgreSQL apps.  So, I'm
   > assuming that since I used DBI (a common database connection format)
   > that I'd only have to change the connect string to point to the
   > PostgreSQL source rather than MySQL and all should be good.
   
   Since DBI uses a different DBD for every database, you should get
   the DBD for PostgreSQL (DBD:Pg) from your local perl archive...
   
   This DBD really should be in the distribution.
   
   > So, what is Pg.pm? and how is that connected (if at all) to DBI?
   
   Pg.pm is not in any way connected to DBI. It is marginally faster
   than DBI, but you loose the ability to choose between different
   databases.
   
   /* m */