Re: [PHP-DB] Which Database Abstraction Layer ?

2004-10-01 Thread Lukas Smith
Lester Caine wrote: Lukas Smith wrote: mysql: http://marc.theaimsgroup.com/?l=pear-devm=108239153527834w=2 ibase: http://marc.theaimsgroup.com/?l=pear-devm=108240351804395w=2 there are other interesting points being discussed through out this thread but with a noteably focus on the pear

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-30 Thread Lukas Smith
Lester Caine wrote: Ed Lazor wrote: Has any performance testing been done between ADOdb and PEARdb? Not recently. Personally I am still trying to benchmark engines within ADOdb against the latest Firebird. This is an area where any results would be useful. There are speed comparisons on the

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-30 Thread Lester Caine
Lukas Smith wrote: mysql: http://marc.theaimsgroup.com/?l=pear-devm=108239153527834w=2 ibase: http://marc.theaimsgroup.com/?l=pear-devm=108240351804395w=2 there are other interesting points being discussed through out this thread but with a noteably focus on the pear abstraction layers.

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-12 Thread John Lim
Hi Hans, The case-changing code for postgresql is in the postgres7 driver. Regards, John Hans Lellelid [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi John, John Lim wrote: /abstract/ stuff. For example, ADOdb would completely fail to be portable accross databases where the

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-11 Thread Hans Lellelid
Hi John, John Lim wrote: /abstract/ stuff. For example, ADOdb would completely fail to be portable accross databases where the case of the column names in result array changes (e.g. postgres always returns lowercase col names, Oracle always uppercase, MySQL returns mixed case, SQLite is

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-11 Thread Manuel Lemos
Hello, On 09/11/2004 11:11 PM, Hans Lellelid wrote: /abstract/ stuff. For example, ADOdb would completely fail to be portable accross databases where the case of the column names in result array changes (e.g. postgres always returns lowercase col names, Oracle always uppercase, MySQL returns

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-04 Thread Lester Caine
Hans Lellelid wrote: No, that's true; no Firebird yet. Drivers needed :) It's basically a slightly modified version of the JDBC API for PHP. Now THAT might be the correct way forward. I already use the Firebird-Jaybird interface when running plug-ins on Eclipse without any problems, but I

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-04 Thread Lester Caine
Lester Caine wrote: No, that's true; no Firebird yet. Drivers needed :) It's basically a slightly modified version of the JDBC API for PHP. Now THAT might be the correct way forward. I already use the Firebird-Jaybird interface when running plug-ins on Eclipse without any problems, but I

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-03 Thread Lester Caine
Hans Lellelid wrote: You definitely should do your own benchmarks. Bear in mind that the ADOdb benchmarks test a certain type of behavior -- namely repeated select statements. Also bear in mind that the speeds of the different layers are going to be inversely proportional to how well they

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-03 Thread Lester Caine
Jeffrey Moss wrote: Doesn't do Firebird yet ;) - but it looks interesting. As long as it has not made the mistake of using MySQL as the SQL standard. Many other packages are simply MySQL wrappers with cobbled support for a couple of other engines. I was curious about Firebird as I've heard it

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-03 Thread Hans Lellelid
Lester Caine wrote: snip So you start with ADOdb datadict and build the database from that - works well when adding any supported engine. Reserved words which differ between engines are another problem area though. Yeah, but not just reserved words -- but even what is allowable in a query.

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-02 Thread Lester Caine
John Holmes wrote: I'd personally recommend ADOdb for no other reason than that's what I use and it's effective. Seconded. John Lim who wrote ADOdb is always updating it with input from users. PEARdb does seem to have caught up, but lots of third party applications are already available that use

RE: [PHP-DB] Which Database Abstraction Layer ?

2004-09-02 Thread Ed Lazor
Has any performance testing been done between ADOdb and PEARdb? -Original Message- PEARdb does seem to have caught up, but lots of third party applications are already available that use ADOdb or have moved to it (or are moving) in later updates. -- PHP Database Mailing List

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-02 Thread Lester Caine
Ed Lazor wrote: Has any performance testing been done between ADOdb and PEARdb? Not recently. Personally I am still trying to benchmark engines within ADOdb against the latest Firebird. This is an area where any results would be useful. There are speed comparisons on the ADOdb site, but they

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-02 Thread Jean-Philippe Côté
John, I thought the point of such discussion lists as php-db was to be able to maturely discuss these questions. I understand that people have different opinions and that's exactly what I'm looking for. I'm hoping to receive pointers in one or the other direction and then I can make an educated

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-02 Thread John Holmes
From: Jean-Philippe Côté [EMAIL PROTECTED] I thought the point of such discussion lists as php-db was to be able to maturely discuss these questions. I understand that people have different opinions and that's exactly what I'm looking for. I'm hoping to receive pointers in one or the other

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-02 Thread Lester Caine
Jean-Philippe Côtê wrote: I thought the point of such discussion lists as php-db was to be able to maturely discuss these questions. I understand that people have different opinions and that's exactly what I'm looking for. I'm hoping to receive pointers in one or the other direction and then I can

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-02 Thread Jean-Philippe Côté
Quoting Lester Caine [EMAIL PROTECTED]: I am sure if I started again now I would probably be using something other than ADOdb. But at the time it fitted the bill and where there were problems they were quickly cleared. Unlike some of the other options I tried. May I ask which other ones you

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-02 Thread Hans Lellelid
Jean-Philippe Côtê wrote: Quoting Lester Caine [EMAIL PROTECTED]: I am sure if I started again now I would probably be using something other than ADOdb. But at the time it fitted the bill and where there were problems they were quickly cleared. Unlike some of the other options I tried. May I ask

[PHP-DB] Which Database Abstraction Layer ?

2004-09-01 Thread Jean-Philippe Côté
Hi, I'm trying to choose a database abstraction layer for a project and I'm having difficulty making up my mind. The two I'm currently looking at are: ADOdb and MDB2 (from PEAR). I was recommended to use MDB2 but its still a beta version and the documentation is weak. ADOdb seems to have a

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-01 Thread John Holmes
Jean-Philippe Ct wrote: I'm trying to choose a database abstraction layer for a project and I'm having difficulty making up my mind. The two I'm currently looking at are: ADOdb and MDB2 (from PEAR). I was recommended to use MDB2 but its still a beta version and the documentation is weak. ADOdb