Re: Do you use PL/SQL

On Thu, 24 May 2007 23:40:02 -0500, Galen Boyer wrote:

> Then, behind the interfaces of procs, the database professionals for
> that platform use all of that database's features at their disposal.
> The schema itself can be a bit different on each platform if needed.

The problem is in the fact that the vendors of "database independent applications" are usually trying to cut down costs and are developing applications typically on MySQL or SQL server and have little or no resources for other databases. Unfortunately, things developed and tested on 10 user configurations frequently fail on 1000 user configurations and there is the heart of the problem.
Database is not a commodity yet, state of technology doesn't allow that. Database will become a commodity when a GPL-ed database like PostgreSQL is able to handle 1000 concurrent users without a problem, with all kinds of high availability technologies, like replication and clustering. Until then, we are locked into the proprietary worlds of Oracle or DB2. There is a reason why companies start thinking about Oracle or DB2 when they reach certain size. Companies are not stupid, they would much rather use PgSQL then Oracle, if it was possible. It is possible (and cheaper) to use Linux instead of Solaris of AIX, so the companies are doing that en mass. Unfortunately, it isn't possible with the databases just yet. Software vendors are trying to behave as it is possible for them to develop on PgSQL and run on Oracle. Unfortunately, it doesn't work that way, either.

-- 
http://www.mladen-gogala.com