This is part of The Pile, a partial archive of some open source mailing lists and newsgroups.
Subject: Re: postgresql and stuff
From: Robert Wise <smurph@area.com>
Date: Mon, 5 Jul 1999 09:49:58 -0700 (PDT)
The one HOW-TO i started in on, (which seemed unusually
evangelistic for a HOW-TO) did mention the DBI perl
interface. This is an attempt to provide a uniform
interface between perl and SQL databases, basically so you
can use the same code for making the connection and getting
the data, and only change a few variables when switching
from postgresql to mysql to informix, etc etc etc. I'm not
sure how many of the big guys DBI works with, or if it is
less efficient than a DB's built in perl interface, I do
know MySQL discontinued their native perl interface so the
only (easy) way to do perl to mysql is by using DBI. I like
it, cause in theory you have the opportunity to second guess
your choice of database. Of course it still doesn't solve
the problem of designing your code around proprietary add
ons to the SQL 92 standard, but I guess that could only be
solved by a more comprehensive standard... (I think even
things like LIMIT, as in "SELECT blahblahblah LIMIT 10" are
add-ons to the standard, but that sure would be a pain to
live without, especially when doing code that returns ten
results at a time to a webpage.)
smurph
smurph@area.com kzsu dj, linux user, and kosh kid
===