Re: [Phplib-users] Oracle usage

[Eric M. <er...@pa...>]

Jesse Swensen wrote:
> 
> I have used the oracle abstraction for a couple of years.  I have found it
> to complete enough to do our web site for several internal projects.  I am
> currently using it to support a global data warehouse for Nortel Networks.
> 
> The only change I have thought would be nice would be to support commit and
> rollback.  Currently all transactions are auto committed.  I have looked
> into it and would be a minor thing to add.

Actually, I extended db_sybase.inc to provide that functionality for
Sybase for the application that I'm working on, but I never submitted it
to the project because these features are not supported throughout
DB_Sql and my code is kinda ugly right now.  However, if anyone is
interested, I'd be happy to contribute that work to db_sybase.inc.

> 
> The shortcoming of the DB_SQL interface is it is based on MySQL.  Don't get
> me wrong, MySQL is a wonderful database and I have used it in several
> projects.  But it is not Oracle.  There are many things that can be done
> with the Oracle API that is not supported by DB_SQL.  But most of them are
> not of value in a web environment.  So, selects, inserts, updates and
> deletes are enough and DB_SQL has been bullet proof.
> 
> I would recommend it.


Thanks for the info.

Eric