Posted by Rik on 08/15/06 18:21

Jerry Stuckle wrote:
> Craig Taylor wrote:
>> Just curious as to opinions on the best DB interface for mysql ... I
>> typically use the PEAR DB package but curious as to what others see
>> as strengths and weaknesses in PDO, native mysql drivers and others.
>>
>> - Craig Taylor
>> http://www.ctalkobt.net/php
>>
>
> Personally I just use the mysql or mysqli interface (depending on the
> version of PHP I'm writing for).
>
> Other programmers swear by PEAR:DB. It's OK, if that's what you want,
> and it does make the interface easier.
>
> If you don't want to use the mysql/mysqli interface, I would recommend
> PEAR:DB.

I second that. I use mainly mysql (with some kind of custom abstraction
layer depending on the size of the project and repetitiveness (?) of the
queries. The reason for using mysql instead of mysqli is the support on the
servers they will be run. Thank God more and more servers move to PHP5 with
mysqli, so I'll be coding more and more for that.

Of the 2 I'd prefer mysqli, because of the prepared statements.

I'm not totally averse tot PEAR MDB2, which is usefull for porting code to
different databases. That's onlyu real gain from it IMO.

Grtz,
--
Rik Wasmus

[Back to original message]