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

Re: pg or DBI

From: "Peter Galbavy" <peter(dot)galbavy(at)knowtion(dot)net>
To: <pgsql-novice(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org>,"Devinder K Rajput" <Devinder(dot)Rajput(at)ipaper(dot)com>
Subject: Re: pg or DBI
Date: 2002-10-26 11:26:58
Message-ID: 008b01c27ce2$996436d0$ (view raw, whole thread or download thread mbox)
Lists: pgsql-adminpgsql-novice
> 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
> other for connecting to postgres via perl.  Also, which one is more widely
> used?  Thanks for your input.

I have never used Pg but I had a quick look and appears to be the way to go
if you are going to be using PostgreSQL only. DBI gives you two benefits
which are related; a) You can build software that will work with different
database backends with only minimal changes (if you follow the portability
guidelines) and b) you can work with multiple different database backends in
the same code at the same time.

The later is extremely powerful when you 'inherit' a job that may involve
ODBC, Oracle, PostgreSQL etc. Cough.

Give both a quick try, proof of concept them, and decide.


In response to

  • pg or DBI at 2002-10-24 17:05:03 from Devinder K Rajput

pgsql-novice by date

Next:From: Josh BerkusDate: 2002-10-28 01:13:30
Subject: Re: how to create secondary key!!
Previous:From: John RaganDate: 2002-10-26 03:32:00
Subject: CoreReader

pgsql-admin by date

Next:From: Ludwig LimDate: 2002-10-27 12:05:11
Subject: Re: FATAL 1: configuration file 'postgresql.conf' has wrong permissions
Previous:From: PandurangDate: 2002-10-26 10:06:46
Subject: Strange..!!! Can u tell me why this ?

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