Connecting Tech Pros Worldwide Forums | Help | Site Map

Database Abstraction Layers / Frameworks

rickycornell@gmail.com
Guest
 
Posts: n/a
#1: May 16 '07
Greetings All,

On past projects in PHP4 I had always just written my own libraries to
deal with database interaction. Somehow I was operating in the dark
that there were all these database abstraction things available that
made my work on the libraries I made from scratch a waste of time.

So now I've started researching all these things that are available,
and I have to say I am a little confused. It's a matter of
understanding the level of abstraction in all of these different
projects. For example:

PEAR::DB, PDO, Creole, Propel, etc.

Propel, for example, seems to be a much higher level of abstraction
than PDO. Are there similar projects that compete with the level of
abstraction that Propel offers? Where are these various projects on
the abstraction totem pole?

This is my first post, hope I'm not making myself sound like a fool.
Thanks a lot in advance for anyone with insight on this.

Ricky


Benjamin
Guest
 
Posts: n/a
#2: May 16 '07

re: Database Abstraction Layers / Frameworks


On May 15, 8:51 pm, "rickycorn...@gmail.com" <rickycorn...@gmail.com>
wrote:
Quote:
Greetings All,
>
On past projects in PHP4 I had always just written my own libraries to
deal with database interaction. Somehow I was operating in the dark
that there were all these database abstraction things available that
made my work on the libraries I made from scratch a waste of time.
>
So now I've started researching all these things that are available,
and I have to say I am a little confused. It's a matter of
understanding the level of abstraction in all of these different
projects. For example:
>
PEAR::DB, PDO, Creole, Propel, etc.
>
Propel, for example, seems to be a much higher level of abstraction
than PDO. Are there similar projects that compete with the level of
abstraction that Propel offers? Where are these various projects on
the abstraction totem pole?
PDO merely provides connection abstraction; this means you connect to
any database server abstractly but the SQL is not changed.

PEAR::DB has been replace by PEAR::MDB2. It offers both connection
abstraction and SQL abstraction (your SQL should work on any server) I
haven't tried the others, but I love this one.
Quote:
>
This is my first post, hope I'm not making myself sound like a fool.
Thanks a lot in advance for anyone with insight on this.
No, your not a fool.
Quote:
>
Ricky

Closed Thread