Re: [PHP-DB] Database Abstraction Layer?
From: "Muhammed Mamedov" <[EMAIL PROTECTED]> > 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? Available for ADOdb, also. Never used it personally, though. http://phplens.com/lens/adodb/docs-datadict.htm ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Database Abstraction Layer?
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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 22, 2004 11:26 PM Subject: Re: [PHP-DB] 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:[EMAIL PROTECTED] > > Sent: Wednesday, January 21, 2004 10:07 AM > > To: [EMAIL PROTECTED]; phpdb > > Subject: Re: [PHP-DB] 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" <[EMAIL PROTECTED]> > > To: "phpdb" <[EMAIL PROTECTED]> > > Sent: Wednesday, January 21, 2004 5:44 PM > > Subject: RE: [PHP-DB] 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:[EMAIL PROTECTED] > >>Sent: Wednesday, January 21, 2004 2:31 AM > >>To: phpdb > >>Subject: [PHP-DB] 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 > > -- > 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
Re: [PHP-DB] 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:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 10:07 AM To: [EMAIL PROTECTED]; phpdb Subject: Re: [PHP-DB] 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" <[EMAIL PROTECTED]> To: "phpdb" <[EMAIL PROTECTED]> Sent: Wednesday, January 21, 2004 5:44 PM Subject: RE: [PHP-DB] 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:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 2:31 AM To: phpdb Subject: [PHP-DB] 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Database Abstraction Layer?
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" <[EMAIL PROTECTED]> To: "Muhammed Mamedov" <[EMAIL PROTECTED]> Sent: Wednesday, January 21, 2004 11:21 AM Subject: Re: [PHP-DB] 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" <[EMAIL PROTECTED]> To: "phpdb" <[EMAIL PROTECTED]> Sent: Wednesday, January 21, 2004 8:31 AM Subject: [PHP-DB] 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Database Abstraction Layer?
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:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 10:07 AM To: [EMAIL PROTECTED]; phpdb Subject: Re: [PHP-DB] 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" <[EMAIL PROTECTED]> To: "phpdb" <[EMAIL PROTECTED]> Sent: Wednesday, January 21, 2004 5:44 PM Subject: RE: [PHP-DB] 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:[EMAIL PROTECTED] > Sent: Wednesday, January 21, 2004 2:31 AM > To: phpdb > Subject: [PHP-DB] 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
Re: [PHP-DB] 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" <[EMAIL PROTECTED]> To: "phpdb" <[EMAIL PROTECTED]> Sent: Wednesday, January 21, 2004 5:44 PM Subject: RE: [PHP-DB] 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:[EMAIL PROTECTED] > Sent: Wednesday, January 21, 2004 2:31 AM > To: phpdb > Subject: [PHP-DB] 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
RE: [PHP-DB] Database Abstraction Layer?
Oh ya, one more thing, I am going to integrate SQL Relay with the PHP abstraction layer: http://sourceforge.net/projects/sqlalphp to give the functions a more PHP feel to them. Plus, I will be able to retain DB specific calls if I want with this layer. I have used this layer with a great deal of success in the past. But it was never the DB calls that got me, it was the actually SQL. So I am building a swappable SQL library. The Propel solution would effectively negate me having to do that. - Paul -Original Message- From: Muhammed Mamedov [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 3:41 AM To: phpdb Subject: Re: [PHP-DB] Database Abstraction Layer? Thanks Ricardo for your comments. What do you think guys: ADODB or PEAR::DB ? - Original Message - From: "Ricardo Lopes" <[EMAIL PROTECTED]> To: "Muhammed Mamedov" <[EMAIL PROTECTED]> Sent: Wednesday, January 21, 2004 11:21 AM Subject: Re: [PHP-DB] 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" <[EMAIL PROTECTED]> > To: "phpdb" <[EMAIL PROTECTED]> > Sent: Wednesday, January 21, 2004 8:31 AM > Subject: [PHP-DB] 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
RE: [PHP-DB] 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:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 2:31 AM To: phpdb Subject: [PHP-DB] 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
Re: [PHP-DB] Database Abstraction Layer?
Thanks Ricardo for your comments. What do you think guys: ADODB or PEAR::DB ? - Original Message - From: "Ricardo Lopes" <[EMAIL PROTECTED]> To: "Muhammed Mamedov" <[EMAIL PROTECTED]> Sent: Wednesday, January 21, 2004 11:21 AM Subject: Re: [PHP-DB] 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" <[EMAIL PROTECTED]> > To: "phpdb" <[EMAIL PROTECTED]> > Sent: Wednesday, January 21, 2004 8:31 AM > Subject: [PHP-DB] 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
Re: [PHP-DB] Database abstraction layer needed?
My current website is www.ecritters.biz. I think I need one mostly for counting how many queries a page uses, for changing stuff about how queries are executed (like doing something with the errors on every query), etc. MET wrote: >What's your current website? Why do you think you need one? > >~MET > >-Original Message- >From: Leif K-Brooks [mailto:[EMAIL PROTECTED]] >Sent: Saturday, August 17, 2002 3:28 PM >To: [EMAIL PROTECTED] >Subject: [PHP-DB] Database abstraction layer needed? > > >I'm redoing my web site, and I'm considering using a db abstraction >layer. Would I need one, and should it be db-type specific (like, can >just do one db type)? I don't plan to change database types. > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Database abstraction layer needed?
What's your current website? Why do you think you need one? ~MET -Original Message- From: Leif K-Brooks [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 17, 2002 3:28 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Database abstraction layer needed? I'm redoing my web site, and I'm considering using a db abstraction layer. Would I need one, and should it be db-type specific (like, can just do one db type)? I don't plan to change database types. -- 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