Re: Abstraction library

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.