I don't think that DB_DataObject will create a nicce SQL. I think it's better to write it yourself (you know when you have large data sets its better to handle the work youurself)... But your comments on that PEAR::DB is a good package and that many others depend on it makes it the favorite one, I am right?.. And one more question : A guy from this list told that MDB supports XML files (can create db from an XML file and ...) . What do you all think about it? Regards, Muhammed Mamedov ----- Original Message ----- From: "Justin Patrin" <papercrane@xxxxxxxxxxxxxxx> To: <php-db@xxxxxxxxxxxxx> Sent: Thursday, January 22, 2004 11:26 PM Subject: Re: Database Abstraction Layer? > 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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php