Re: Which DB abstraction ?

Hello Robert, On 21-Jun-01 00:44:23, you wrote: >Hi, >I am in a middle of the process of chosing which DB >will be used for future projects. I've been using >Mysql for almost 5 years (coupled with php of course) >but it seems to have reached it's limits (actually the >lack of some features). >The other options include some traditional comercial >dbs and postgresql. I am about to choose postgresql >because it seems to support the features I need >(foreign key, transaction, triggers, stored >procedures) and is open source with active >development. >Even tough I'd like to receive (perhaps in private) >personal thought about this decision I would not like >to start a war...so my focus here is : which db >abstraction layer is ready for use ? disavantages ? >I am considering : Manuel Lemos' Metabase, Phplib and >Pear. This may sound a little biased, but here follow some hard facts: - PHPlib is inspired in mysql API, and PEAR is inspired in Perl DBI API. Both share their limitations. - Metabase was design with portability in mind from the beginning. This means that unlike with others, you can write applications with Metabase that work seeminglessly with different databases without changing a line in your code. For instance, Metabase is able to map by itself the data types with the underlying database. - Metabase provide a unique facility of installing and updating a database schema from a portable description in a XML format. There are other facts, but this should be enough for you to decide. To sound less biased, you may also want to try ADO-DB. It also supports data type mapping. It doesn't do all that Metabase does, but has some features more and supports some more a few databases than Metabase. Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org -- E-mail: mlemos@acm.org URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp --