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

    Join Date
    Sep 2002
    Posts
    8
    Rep Power
    0

    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
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    61
    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