Re: [HACKERS] PostgreSQL and DBI/DBD...vs Pg.pm - Mailing list pgsql-hackers

From Mattias Kregert
Subject Re: [HACKERS] PostgreSQL and DBI/DBD...vs Pg.pm
Date
Msg-id 34FFD6D6.198B2E1B@algonet.se
Whole thread Raw
In response to PostgreSQL and DBI/DBD...vs Pg.pm  ("D. Dante Lorenso" <dlorenso@afai.com>)
List pgsql-hackers
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 */

pgsql-hackers by date:

Previous
From: Mattias Kregert
Date:
Subject: Re: [HACKERS] Execution time
Next
From: "Vadim B. Mikheev"
Date:
Subject: Re: [HACKERS] Re: [PATCHES] Changes to sequence.c