SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: postgreSQL

  1. #1
    $books++ == true matsko's Avatar
    Join Date
    Sep 2004
    Location
    Toronto
    Posts
    795
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    postgreSQL

    I have thoguht of switching to postgreSQL, and I currently use MySQL. I know mysql pretty well however I am a dinosaur to postgreSQL.

    So to get started, what are the differences between the two? I have heard that postgreSQL is more faster, however I am sure there are differences...

  2. #2
    Afrika
    Join Date
    Jul 2004
    Location
    Nigeria
    Posts
    1,737
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    to start both are open source db.

    Mysql has far more documentation than any other db i know.

    A while ago, mysql didnt have things like, transactions, ACID Compliant, sub queries, stored proceedures etc. I hear it has in the latest version.

    Mysql used to be faster, but cant say now. basically read up on
    http://www.databasejournal.com/featu...le.php/3288951
    http://www.webtechniques.com/archives/2001/09/jepson/
    http://www.devx.com/dbzone/Article/20743

    there are so many articles out there, google is your friend.

    Also read up on MyISAM and InnoDB , which are the different database table structures.

    also see
    http://www.postgresql.org/
    http://dev.mysql.com/

    Afrika

  3. #3
    SitePoint Member
    Join Date
    Nov 2002
    Posts
    7
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    MySql tends to be faster for simpler queries, however PostgreSql will win out in more complex queries.
    PostgreSql scales better.
    While MySql is adding many new features these are relatively untested compared to Postgresql.


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
  •