SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Evangelist
    Join Date
    Jan 2002
    Scotland, UK
    0 Post(s)
    0 Thread(s)

    Postgre for beginners


    Ive been messing around with MySQL for a year now and due to my new job have been asked to look into using an Open Source RDBMS with support for stored procedures.

    Not knowing anything but MySQL I went looking around and found Postgre.

    Can anyone point me in the direction of a newbie guide or FAQ for it.

    I am presently coding in PHP and was wondering how easy/difficult it would be to move over to Postgre from MySQL.

    Many thanks.

  2. #2
    SitePoint Member
    Join Date
    Feb 2002
    0 Post(s)
    0 Thread(s)
    Postgres Introduction and Concepts

    I'm doing the same - migrating from mysql to postgres.

    FYI, Stored Procedures in postgres aren't like what you might be used to from oracle or mssql. You cannot return rows - I know, big disappointment. Stored procedures work great for updates and inserts, just not that useful for selects. I've opted for views - still better than what mysql has to offer.

    As far as the php, if you aren't using a data abstraction layer like pear then you will have some changes to make in the sql and data connection.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts