Database Abstraction
Posted: Thu Feb 15, 2007 4:42 pm
What database abstraction library, if any, do you use? I'm after a fairly simple one but with a handful of specific requirements:
1. It's got to work in PHP 4. PHP 5 as well would be nice but it's not vital.
2. It's got to work *everywhere*. That means it can't rely on PEAR being available (hence no PearDB or MDB).
3. It only needs to work with MySQL really.
4. It needs to handle a few things:
a. Escaping data.
b. Monitoring connections (a simple count of queries would be enough).
c. Returning data in the same form as PHP (eg, array, assoc or object).
I can't find anything good and I'm on the verge of writing my own, but I thought I'd ask first.
1. It's got to work in PHP 4. PHP 5 as well would be nice but it's not vital.
2. It's got to work *everywhere*. That means it can't rely on PEAR being available (hence no PearDB or MDB).
3. It only needs to work with MySQL really.
4. It needs to handle a few things:
a. Escaping data.
b. Monitoring connections (a simple count of queries would be enough).
c. Returning data in the same form as PHP (eg, array, assoc or object).
I can't find anything good and I'm on the verge of writing my own, but I thought I'd ask first.
