From: Daniel Berger <djberge@...>
Date: 2003-02-20T02:40:23+09:00
Subject: Re: How does one connect to a remote database using dbi?

> 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

For a consistent API mainly.  It's not uncommon to have multiple DBMS within the
same company.  We mainly use Oracle here at work, but there are also DB2
databases, plus a few folks have created home-grown MS Access (ick) and MySQL
databases.  We currently are using Oracle for our own development team but are
considering a switch to postgres or mysql.

I have no idea if the API between the oracle, postgres and mysql driver are the
same (I doubt it), but by using DBI, I don't need to worry about it.

Regards,

Dan

--
a = [74, 117, 115, 116, 32, 65, 110, 111, 116, 104, 101, 114, 32, 82]
a.push(117,98, 121, 32, 72, 97, 99, 107, 101, 114)
puts a.pack("C*")