From: ahoward <ahoward@...>
Date: 2003-02-20T02:32:07+09:00
Subject: Re: How does one connect to a remote database using dbi?

On Wed, 19 Feb 2003, Ernie wrote:

> Thanks for your help.  I have dbi and postgresql up and running and have
> accessed both remote and local data bases, successfully done queries,
> inserts, updates, and transactions.
> Thanks for all the help.
> By the way dbi rocks.
>
> Ernie
> "Gabriel Emerson" <egabriel@io.com> wrote in message
> news:pan.2003.02.17.23.58.47.718188@io.com...
> > connection = DBI.connect('dbi:Pg:dbname=foo;host=foo.bar.com;port=5432',
> >            'someuser', 'somepassword)
> >
> > On Mon, 17 Feb 2003 18:27:16 -0500, Ernie wrote:
> >
> > > I've looked at the examples and I can connect to a local data base.
> What
> > > is the syntax for connecting to a remote database using dbi and
> > > postgresql?
> > >
> > > Thanks
> > > Ernie

can someone illuminate me as to the advantages of using DBI?  it seems that
for most applications one will make use of vendor specific SQL and thus lose
portability of database code.  am i mistaken to think this way?  personally i
find the postgres module _so_ easy to use it's hard to imagine something
easier...

perplexed.

-a

-- 
 ====================================
 | Ara Howard
 | NOAA Forecast Systems Laboratory
 | Information and Technology Services
 | Data Systems Group
 | R/FST 325 Broadway
 | Boulder, CO 80305-3328
 | Email: ahoward@fsl.noaa.gov
 | Phone:  303-497-7238
 | Fax:    303-497-7259
 ====================================