What is the best PHP MYSQL wrapper?

Question

I've bounced around between different wrappers, my own, and using straight php mysql functions over the years but I'm sure there's a really good solution out there. What is it? :)

EDIT: Only needs to connect to MYSQL.

Answer 1

A very subjective question, can you prioritise your requirements... does it have to be light weight, portable (to other DBs) etc?

I usually use ADODB, not least because it provides great database abstraction and therefore very portable.

Answer 2

I use PDO with my own wrapper. Earlier i used goBD for MySQL (extends MySQLi), but all docs are only in russian.

Answer 3

For larger projects I usually use Doctrine as an object relational mapper. It also provides abstraction for "normal" SQL queries but it can do so much more.

It can definitely make development much more painless. In the end you can develop complex applications without a single line of SQL code.

For small scripts where Doctrine would be just overkill, I just stick with PHPs built in PDO.