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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
