DB vs MDB vs MDB2?

From: 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

« previous php.pear.general (#21339) next »