Opinions on best DB interface

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

re: Opinions on best DB interface

Craig Taylor wrote: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.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

re: Opinions on best DB interface

Craig Taylor wrote:The only distinction that I can see is that the native drivers run
faster, because there are inherently less layers. I'm not sure if PDO
limits the flexability you have but that may be another question. The
native drivers allow you to submit any SQL for Selecting, Inserting,
Deleting, or altering the structure of the database, but there's no
guidence from the interface on how to do what. At that point it's all
about the MySQL documenation.

Josh

re: Opinions on best DB interface

Craig Taylor wrote:Having used both PEAR DB and mysql native interface, I prefer the
latter. I can't see any advantages offered by PEAR DB unless you
envisage connecting to more than one database type. I haven't made any
accurate measurements, but my impression was that PEAR DB adds a not
insignificant overhead.

--
Ian Collins.

re: Opinions on best DB interface

Ian Collins wrote:You could look at MDB2 which is quoted to be an upgrade of the older
PEAR::DB. The DB package is there just to give support to all of the
current programs that use it. MDB2 has a mysqli support. Their are some
PEAR modules that are really nice but require DB or MDB2. I am new to
PHP but I like some of the modules in PEAR if it can make my life easier
and not take to many cycles. Example which could require DB or MDB2:

DB_DataObject
DB_DataObject_FormBuilder
HTML_QuickForm

Thanks in Advance...
IchBin, Pocono Lake, Pa, USA http://weconsultants.phpnet.us
__________________________________________________ ________________________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)

re: Opinions on best DB interface

Jerry Stuckle wrote: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

re: Opinions on best DB interface

Craig Taylor wrote:ADODB is better, IMHO. Creole also looks promising.

--
<?php echo 'Just another PHP saint'; ?>
Email: rrjanbiah-at-Y!com Blog: http://rajeshanbiah.blogspot.com/