SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    cd /pub; more beer diacono's Avatar
    Join Date
    Dec 2000
    Location
    Horsham, West Sussex, UK
    Posts
    277
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i just wanted to know how diferent is postgreSql to mySql.
    for example, lets take kevins very famous article on php & sql. would it be possible to literally use that article for posgreSql withou any changes?
    is it true that posgreSql is much more complex & robust?

    cheers.

  2. #2
    SitePoint Wizard
    Join Date
    Jul 1999
    Location
    Chicago
    Posts
    2,629
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    All of the SQL query syntax would be the same, but the administration would be different. So if you found a way to do tasks such as 'create table' in PgSql (and the rest of those types of queries) you could use the code and queries he listed.

    You might need to change a tiny bit more. Of course, you'd use pg_connect and pg_command instead of mysql_connect....

  3. #3
    cd /pub; more beer diacono's Avatar
    Join Date
    Dec 2000
    Location
    Horsham, West Sussex, UK
    Posts
    277
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ok, understood!
    i've heard about needing drivers for stuff like phorum so that i can work with PgSql...
    how would that work?
    is it like that for the rest?

  4. #4
    SitePoint Zealot
    Join Date
    Nov 2000
    Posts
    109
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Read what Tim Perdue at PHPBuilder.com comment MySQL and PostgreSQL on a previous project work :-

    http://phpbuilder.com/columns/tim20000705.php3

    Over 100 Free Wordpress Themes for download
    Get your website a free hosting account
    Dotservant.com professional website hosting since 2000

  5. #5
    cd /pub; more beer diacono's Avatar
    Join Date
    Dec 2000
    Location
    Horsham, West Sussex, UK
    Posts
    277
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    fweikeong: spot on! thanx

  6. #6
    SitePoint Zealot
    Join Date
    Nov 2000
    Posts
    109
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    welcome and enjoy your reading.
    Over 100 Free Wordpress Themes for download
    Get your website a free hosting account
    Dotservant.com professional website hosting since 2000


Bookmarks

Posting Permissions

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