Re: PEAR and DB abstraction layer (was: PHPLIB)

Ted Knudson wrote: > I do not understand why someone would want to use a DB abstraction layer? > It looks like it would just be more code that I would have to learn. > I am using PHP and MySQL. What advantage would using phpDB (as an example) > be to me? > It would allow you to easily change your database if you need too, by not referring to mysql_* calls directly. It allows for greater portability of applications to different environments. For example if you developed on windows using an Access ODBC datasource you can easily deploy on Unix using mySQL. Or if your site for some reason needed transactions, which mySQL doesn't support, you could easily move your site to an Oracle or Sybase backend. > > If I add a DB abstraction layer wouldn't it increase overhead and slow down > the server? > Probably a little. Michael