#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    300
    Rep Power
    15
    I am slowly loosing my mind to this. All was well as long as I worked with MySQL. Now I have to work with PostgreSQL, and I just don't dig it.

    Is there anyone out there who worked on somethng like this before?? Or knows of any good tutorials???
  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 haven't yet worked with PostgreSQL on PHP yet but I hope to soon, because Postgres has enterprise-level features.

    One good place to go is www.phpwizard.net,, where you can download phpPgAdmin, which uses PHP as a Postgres admin frontend, and browse through their source code, to see examples of PHP and Postgres in action.

    Also, you could post the first question at the PostgreSQL forum here at DevShed.

    [This message has been edited by rycamor (edited June 06, 2000).]

    [This message has been edited by rycamor (edited June 06, 2000).]
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 1999
    Posts
    37
    Rep Power
    26
    I actually found Postgres to be too experimental and incomplete for my use. Make sure those "features" that attract you are already developed and not just "planned".

    I was surprised that I couldn't even do a DROP COLUMN. Postgres doesn't support that yet (unless this has changed in the last few months).

    I hope Postgres makes it big. I'd like to see a powerful open-source object-relational database with full atomicity and stored procedures; but I'm not sure if it's there yet.
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    300
    Rep Power
    15
    Well, I found out that there is no easy way to add somethng like auto_increment whem you create the table. Not to mention that all of the PHP functions act a little strange...
  8. #5
  9. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    Perth West Australia
    Posts
    757
    Rep Power
    15
    Yep it pretty much sucks - but as you have to work with it - http://www.elite2000.f2s.com has a basic intro to interacting with PostgresSQL, and http://www.freedom2surf.com itself has a help forum for PHP/PostgresSQL although as it is a free server you get all sorts of strange questions there!


    Simon

    ------------------
    Simon Wheeler
    FirePages -DHTML/PHP/MySQL
  10. #6
  11. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    300
    Rep Power
    15
    Oh man...This is the solution I came to, but I thought that there is a more elegant way to do it. Something like with MySQL. But thanks a lot, you were all cery helpful. :-))

Similar Threads

  1. Replies: 2
    Last Post: August 18th, 2004, 10:45 PM
  2. Problem connecting to PostGreSQL with php.
    By c.caraccioli in forum PostgreSQL Help
    Replies: 5
    Last Post: January 24th, 2004, 11:25 AM
  3. PHP with UnixODBC
    By coder4hire in forum PHP Development
    Replies: 2
    Last Post: January 20th, 2004, 01:14 PM
  4. Passing string from PHP to Javascript
    By ka8oad in forum JavaScript Development
    Replies: 4
    Last Post: January 17th, 2004, 03:12 PM
  5. UnixODBC + PHP + Apache + Empress
    By coder4hire in forum Database Management
    Replies: 0
    Last Post: January 15th, 2004, 01:41 PM

IMN logo majestic logo threadwatch logo seochat tools logo