Re: Database Abstraction Layer?

[Justin Patrin <papercrane@xxxxxxxxxxxxxxx>]

I like PEAR::DB myself, especially since so many other PEAR packages 
build upon it. To make your code even more DB independant, you can use a 
package which builds the SQL for you, such as DB_DataObject. It can also 
quote table / column names and values correctly per DB. (Although DB 
hasn't been uypdated yet with my patch to support table and column quoting.)

Muhammed Mamedov wrote:

> Thanks Ricardo for your comments.
>
> What do you think guys: ADODB or PEAR::DB ?
>
> ----- Original Message -----
> From: "Ricardo Lopes" <lopes@xxxxxxxxxxxxxxx>
> To: "Muhammed Mamedov" <mm@xxxxxxxxxx>
> Sent: Wednesday, January 21, 2004 11:21 AM
> Subject: Re:  Database Abstraction Layer?
>
>
>
> > You have ADODB and PEAR DB that both work as abstraction layer. I have
>
> used
>
> > ADODB and seems to me that is very good, yet i have not tested PEAR DB...
> >
> > To make php code 100% database independent is not very easy, depends of
>
> what
>
> > are you going to do with your code. Use the ADODB or PEAR functions every
> > time possible, and avoid the using of sql statements in your code because
> > you have to carefull design then to be database independent but that can
>
> be
>
> > a very difficult task.
> >
> > ----- Original Message -----
> > From: "Muhammed Mamedov" <mmamedov@xxxxxxxxxxxxxxx>
> > To: "phpdb" <php-db@xxxxxxxxxxxxx>
> > Sent: Wednesday, January 21, 2004 8:31 AM
> > 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


--
paperCrane <Justin Patrin>

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