[PHP-DB] Abstraction library
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 :-/ -- David M. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Abstraction library
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 MDB2 http://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 ADOdb http://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 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
Re: [PHP-DB] Abstraction library
On Fri, 2011-12-30 at 12:27 +, 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 MDB2 http://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 ADOdb http://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? -- David M. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Abstraction library
On Fri, 2011-12-30 at 11:23 -0500, David McGlone wrote: On Fri, 2011-12-30 at 12:27 +, 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 MDB2 http://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 ADOdb http://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. -- David M. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Abstraction library
David McGlone wrote: On Fri, 2011-12-30 at 11:23 -0500, David McGlone wrote: On Fri, 2011-12-30 at 12:27 +, 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
