Re: Abstraction library
Lester Caine <[email protected]>
| Newsgroups | gmane.comp.php.database |
|---|---|
| Message-ID | <[email protected]> |
David McGlone wrote: > On Fri, 2011-12-30 at 11:23 -0500, David McGlone wrote: >> > On Fri, 2011-12-30 at 12:27 +0000, Lester Caine wrote: >>> > > David McGlone wrote: >>>> > > > Hi everyone I got a quick question. I'm wondering if anyone is using a >>>> > > > DB abstraction layer such as PEAR DB. I've used PEAR DB in the past and >>>> > > > knew it's been on it's way to extinction, but never looked into >>>> > > > alternatives or any other way to replace it. Now this has come back to >>>> > > > bite me in the rear and I don't know what to do. Is PEAR useful anymore >>>> > > > at this point? Am I better off just writing my own? I hate the thought >>>> > > > of having to change my habits I've had for so long, but I guess that's >>>> > > > how it has to be. Maybe I should have rolled my own in the first place >>>> > > > and I wouldn't have had to rely on something that's not guaranteed :-/ >>> > > >>> > > Pear DB was superseded by MDB2http://pear.php.net/package/MDB2 but that has not >>> > > been updated in the last year. >>> > > PDO is a half way house to an abstraction layer and while it is having minor bug >>> > > fixes, it is not really abstraction layer, only a different way of interfacing >>> > > to the drivers. It does nothing for >>> > > I'm still using ADOdbhttp://adodb.sourceforge.net/ which I've had no problems >>> > > with in the last 10 years and on the whole transparently switches between >>> > > databases ( including PDO drivers if you want;) ). It even includes it's own >>> > > cache which can help with repetitive stuff. It is still actively supported, and >>> > > is used by a number of large projects. >> > >> > Lester, that sounds good. By any chance would you know how much they >> > differ and the learning curve between the two? > I forgot to add that I took a look at some examples and it looks almost > exactly like PEAR. I'm more less worrying about anything drastic I may > run into once I've gotten so far into the project. I'm afraid it would > be a big setback. I've switched a few projects from an assortment of styles ( including PDO ) TO use ADOdb instead with little trouble. bitweaver uses a slim wrapper around ADOdb, which can be switched to using PEAR instead, and this works well, so I would not expect much trouble migrating over. Simple wrappers like GetOne() tidy a number of areas and it makes database access easy. -- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk// Firebird - http://www.firebirdsql.org/index.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php