News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Xaprb's Blog:
Four types of database abstraction layers
August 14, 2006 @ 07:55:26

In this new posting from Xaprb's blog today, there's a look at four different types of database abstraction layers, each with their own unique strengths.

Quite a few people have chimed in on a recent discussion about PHP, MySQL, database abstraction layers, and performance. I think enough viewpoints have been covered that I don't need to comment, but one question I don't see answered is "what are the qualities of a good SQL abstraction layer?" I think it's a very interesting - and complicated - question. As it turns out, the term has several meanings, and I think it's important to understand them.

The four types he lists are:

  • Libraries that provide access to a database
  • Libraries that present a common interface to different server software
  • Libraries that write portable SQL
  • Object-relational mapping software
Each has their own description and example packages that show the strength. Following these notes, he shares some opinions on each, mentioning his likes and dislikes about the state of support for them.

0 comments voice your opinion now!
database abstraction layer four types opinion database abstraction layer four types opinion


blog comments powered by Disqus

Similar Posts

Zend Developer Zone: Fetching multiple random rows from a database

IBM developerWorks: Starting to use ODBC with PHP

Ralph Schindler's Blog: Database Abstraction Layers Must Live!

Volker Dusch's Blog: References suck! - Let's fix MySqli prepared statements!

Lukas Smith's Blog: PHP adopting branching kicking and screaming


Community Events





Don't see your event here?
Let us know!


interview series podcast testing install refactor language framework threedevsandamaybe release configure laravel developer opinion list unittest introduction code symfony2 community

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework