Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : PEAR or ADOdb

[kenny873]

there is an extension in PHP called PEAR, where we no longer need to connect to the DB using mysql_connect() but with
the embedded function such as DB:connect(), one of the main advantage is the ease of implementation if we want to change the db from mysql into Oracle....saves a lot of implementation time to rewrite!

I want to know the comparison of PEAR to ADOdb, which one is better to implement by their performance, functionality?

thanks

[Protollix]

well, most people seem to prefer ADODB over PEAR.

I have never used either as I use my own DB Abstraction Library (Datalib)

ADODB has a lot of little utility functions that AFAIK, PEAR doesn't have. As well, I think ADODB probably has a bigger "community following".

Performance-wise, I can't really comment as I haven't used them. But any DB Abstraction lib should perform about the same as any other unless it has some really funky stuff going on under the hood :p

[cortices]

I personally use PEAR as it is very nicely designed and ships with PHP so it is available by default.

I think basically it comes down to which syntax you prefer. They both have slightly different ways of working with the library. Check out the documentation and see which you prefer.

As to performance, they both probably perform reasonably well. Any differences are most likely negligable.