Re: Universal database interface?

From: Nuno Souto <dbvision_at_iinet.net.au>
Date: Sat, 16 Apr 2005 00:26:55 +1000
Message-Id: <200504160026.56040.dbvision@iinet.net.au>

On Friday 15 April 2005 08:12, Jared Still wrote:
> I think this is somewhat different than the proposal in the article.
> When I read that it just screamed 'the database is a black box'.

Exactly. If done with PL/SQL, it is a completely different beast. And it can greatly reduce the to-fro between the app and the db.

> The use of an all encompassing database independent API reminds
> me of the recent Java thread on this list. SQL is generated with
> disregard to the platform. Often (no, usually) without bind variables.

It is virtually impossible to develop a true db-independent API using only Java and JDBC. Or rather: it is possible, but unusable.

> You should exploit the features of Oracle and quit trying to
> make your application platform independent. You paid for
> the features, you should use them.

How true!

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Apr 15 2005 - 10:32:50 CDT