1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2002
    Rep Power

    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.

    - dom
  2. #2
  3. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Central Florida, USA
    Rep Power
    I'd recommend you take a look at rod k's post below. Another good place to look is the development branch of phpPgAdmin.
    The real n-tier system:

    FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL

    Amazon wishlist -- rycamor (at) gmail.com

IMN logo majestic logo threadwatch logo seochat tools logo