November 20th, 2002, 09:20 AM
Database abstraction in PHP
Now you think that's in the wrong forum but I'm looking for a Postgre specific solution.
At the moment I'm designing a CMS with PostgreSQL and I'm looking for some input about the database connection/error handling. The design is more or less fully OO and I have for every module a separate Access-Class.
What I'm looking for is a Class that supports all the functionality of PostgreSQL and has some error handling (check if there was an error in the query).
I know PEAR DB quite well and I know that Metabase and AdoDB exists but I'm not sure if they are not too big and and doesn't fully support all PostgreSQL features (it's not the goal to be able to change to another database server).
Please let me know what you use for this and what are the benefits and drawbacks of it.
November 20th, 2002, 09:58 PM
I'd recommend you take a look at rod k's post below. Another good place to look is the development branch of phpPgAdmin.