On Fri, 2011-12-30 at 17:36 +0000, Lester Caine wrote: > 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. > Thanks Lester. I spent yesterday playing around with some code using ADO and I like it. I like the fact It supports PEAR style retrieval and I can already see switching shouldn't take much, if anything at all. -- David M. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
