DB vs MDB vs MDB2?
| From: | Larry Garfield | Date: | Tue, 11 Oct 2005 02:40:08 +0000 |
| Subject: | DB vs MDB vs MDB2? | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-21339@lists.php.net to get a copy of this message | ||
What is the current status of the various database wrappers in PEAR? It's
been a long time since I looked into them, at which time DB was the most
widely used but MDB was recommended (I think). Which other packages
(DataObjects, Auth, etc.) are compatible with MDB or MDB2 instead of just DB?
Which is recommended for stability/compatibility/future-proofing?
I am looking to replace a lame ad hoc system with a proper DB wrapper layer
(for validation/SQL insertion protection, mostly), and am trying to consider
my options. Right now the production server for the app in question is
running PHP 4.0.6, which I know won't run PEAR, but we want to try and
convince the admin to upgrade to something modern. If we can, I want to
future-proof myself as much as possible. Of course, the catch is that the
admin, for no sane reason, only allows about a third of the odbc_* functions.
(odbc_result() being the only permitted way to access data from a result
object.) With those limitations, would any of the existing DB wrappers work
or would they all fail that overly-strict limitation?
Thanks for any advice you can offer.
--
Larry Garfield AIM: LOLG42
larry@garfieldtech.com ICQ: 6817012
"If nature has made any one thing less susceptible than all others of
exclusive property, it is the action of the thinking power called an idea,
which an individual may exclusively possess as long as he keeps it to
himself; but the moment it is divulged, it forces itself into the possession
of every one, and the receiver cannot dispossess himself of it." -- Thomas
Jefferson