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/?[EMAIL PROTECTED]
--
E-mail: [EMAIL PROTECTED]
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
