Skip site navigation (1) Skip section navigation (2)

Re: [NOVICE] pg or DBI

From: Jason Earl <jason(dot)earl(at)simplot(dot)com>
To: "Williams, Travis L, NPONS" <tlw(at)att(dot)com>
Cc: "Devinder K Rajput" <Devinder(dot)Rajput(at)ipaper(dot)com>,<pgsql-novice(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [NOVICE] pg or DBI
Date: 2002-10-24 20:11:47
Message-ID: 87d6pzy4u4.fsf@npa01zz001.simplot.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-novice
Actually there are two PostgreSQL Perl interfaces the DBI based one
and Pg.  It has been a while since I have used Perl (and it has been
even longer since I used the Pg interface), but I can tell you that
most people use the DBI version.  The two interfaces are very similar,
but the Pg interface is PostgreSQL specific.  In other words, if you
want to migrate to another database in the future then you should use
DBI.  DBI is also likely to be more familiar to Perl hackers that have
worked with another database.

Jason

"Williams, Travis L, NPONS" <tlw(at)att(dot)com> writes:

> Unless I am mistaken (which actually happens quite often) DBI is the
> base modue that perl uses.. the extension of that DBI::Pg (which is
> called in the script) is postgres specific.  That is what I am using and
> I am new to postgres but have been working with perl for 3-4 years and I
> have found it very easy to use.
> 
> Travis
> 
> -----Original Message-----
> From: Devinder K Rajput [mailto:Devinder(dot)Rajput(at)ipaper(dot)com]
> Sent: Thursday, October 24, 2002 12:05 PM
> To: pgsql-novice(at)postgresql(dot)org; pgsql-admin(at)postgresql(dot)org
> Subject: [NOVICE] pg or DBI
> 
> 
> Hi all,
> 
> I have used pg to connect to postgres.  However, I have seen a lot of
> people use DBI.  Are there any advantages/disadvantages in using one or
> the
> other for connecting to postgres via perl.  Also, which one is more
> widely
> used?  Thanks for your input.
> 
> Devinder Rajput
> Stores Division Corporate Offices
> Chicago, IL
> (773) 442-6474
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

In response to

pgsql-novice by date

Next:From: Oliver ElphickDate: 2002-10-25 09:15:26
Subject: Re: function problems.
Previous:From: Williams, Travis L, NPONSDate: 2002-10-24 18:17:17
Subject: Re: [NOVICE] pg or DBI

pgsql-admin by date

Next:From: Michiel LangeDate: 2002-10-24 22:18:40
Subject: Re: Admin software
Previous:From: Ross J. ReedstromDate: 2002-10-24 19:12:14
Subject: Re: newbie qs; examining databases and tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group