Re: Database Abstraction Layer?

[Justin Patrin <papercrane@xxxxxxxxxxxxxxx>]

There's also PEAR's DB_DataObject which does build SQL for you. The join 
syntax isn't set up to be totally DB independant yet, but it can and 
will be.

Paul Miller wrote:

> PEAR is great from what I hear.  The issue you are going to run into with DB
> independence is not the function calls which could be handled with something
> as simple as sqlalphp.  It is the SQL calls themselves.  The two options I
> have found is a SQL library with unembeded SQL or the Propel solution.
>
> Either way adds a significant time to coding and product release initially.
>
> - Paul
>
> -----Original Message-----
> From: Muhammed Mamedov [mailto:mmamedov@xxxxxxxxxxxxxxx]
> Sent: Wednesday, January 21, 2004 10:07 AM
> To: pmiller@xxxxxxxxxxxxxxx; phpdb
> Subject: Re:  Database Abstraction Layer?
>
>
> Hmm..
> Thank you for you sql picks:)
> But what do you guys think aabout Pear :: DB? Is it as effective as these
> Paul's picks?
>
> Thank you.
> Muhammed Mamedov
>
> ----- Original Message -----
> From: "Paul Miller" <pmiller@xxxxxxxxxxxxxxx>
> To: "phpdb" <php-db@xxxxxxxxxxxxx>
> Sent: Wednesday, January 21, 2004 5:44 PM
> Subject: RE:  Database Abstraction Layer?
>
>
>
> > There are a couple of products out there that I am about to start testing,
> > starting first with:
> >
> > - SQL Relay
> > http://sqlrelay.sourceforge.net/
> > This product uses its on C interfaces to interact with DBs and different
> > programming languages.  It addresses a bunch of items in the PHP DB calls.
> > Connection pooling and load balancing.
> >
> > - Propel
> > http://propel.phpdb.org/
> > Extensive templates create the SQL definition files you need to setup your
> > database and the classes you need to work with your data model in your PHP
> > scripts. The classes for your object model are generated from a simple XML
> > schema and any customizations are written in plain PHP.
> >
> > This will effectively that add SQL and DB dependence out of your mix.
>
> This
>
> > is PHP5 also.
> >
> > HTH
> >
> > - Paul
> >
> > -----Original Message-----
> > From: Muhammed Mamedov [mailto:mmamedov@xxxxxxxxxxxxxxx]
> > Sent: Wednesday, January 21, 2004 2:31 AM
> > To: phpdb
> > Subject:  Database Abstraction Layer?
> >
> >
> > Hello everybody,
> > What do you think is the best method to abstract php code from a specific
> > database?.
> > Make PHP code 100% database independent?..
> >
> > Waitin' for your comments.
> > Muhammed Mamedov
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php


--
paperCrane <Justin Patrin>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php