Professional Web Applications Themes

Postgresql Vs. Mysql -- Need advice - MySQL

Hi Database Gurus, Not to start a war among fanatics, but I just wanted to get honest opinion/advise of smart folks like you about this. We are about to begin development for a data intensive web based application and are faced with the choice of database software. We (at least currently) are focusing on free software. Some basic research has indicated both Postgresql and Mysql as the best of lot. Can people please advise as to pros/cons of each of these ? I am looking from the following angles: a.. Performance (Scalability) b.. Reliability c.. Ease of use d.. Extensibility ...

  1. #1

    Default Postgresql Vs. Mysql -- Need advice

    Hi Database Gurus,

    Not to start a war among fanatics, but I just wanted to get honest opinion/advise of smart folks like you about this. We are about to begin development for a data intensive web based application and are faced with the choice of database software. We (at least currently) are focusing on free software. Some basic research has indicated both Postgresql and Mysql as the best of lot.

    Can people please advise as to pros/cons of each of these ? I am looking from the following angles:

    a.. Performance (Scalability)
    b.. Reliability
    c.. Ease of use
    d.. Extensibility and portability (If we were to migrate to some other database engine in the future, for example Oracle)
    e.. Feature rich-ness
    f.. Rich-ness of other tools available around the database engine
    g.. Anything else that I have missed.

    Are there any pointers to any online work that has done comparisons between these two ?

    Please do reply. Any help/guidance will be truly appreciated.

    Thanks in advance!

    ================================================== ===================
    Email : myoda0001 AT
    Website: http://www.eruditionhome.com [Excellent site for data mining tutorials and resouces]
    ================================================== ===================
    Guest

  2. #2

    Default Re: Postgresql Vs. Mysql -- Need advice

    com wrote: 

    IMHO,Both perform well and are reliable. I find them easy to use with
    tools on the market.

    As for portable - the only way you'll get true portability is if you use
    something like ODBC. If you're using PHP, Pear::MDB2 gives you some
    portability. But in general you're going to have to change code no
    matter which database you use. The SQL will, for the most part, be
    portable, however.

    Postgres has more features available. But MySQL is catching up.

    Tools - probably about the same. I'm not familiar with all the
    available for either one, but for general purpose tools I've been able
    to find what I need for either.

    IMHO you're going about this the wrong way. You need to define your
    requirements for a database, then choose the right one based on those
    requirements. You may find either MySQL or Postgres will work for you.
    Or you may find neither will. Or one, but not the other.

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    net
    ==================
    Jerry Guest

Similar Threads

  1. MySQL v. postgreSQL
    By Jim Morrissey in forum MySQL
    Replies: 0
    Last Post: May 15th, 11:10 PM
  2. Replies: 1
    Last Post: January 7th, 07:37 PM
  3. conflict types mysql and PostgreSQL
    By Pavel Stehule in forum PostgreSQL / PGSQL
    Replies: 0
    Last Post: January 31st, 02:09 PM
  4. mysql postgresql future
    By provaands in forum PHP Development
    Replies: 0
    Last Post: August 12th, 09:48 PM
  5. MySql vs PostgreSQL
    By Jesper Olsen in forum Ruby
    Replies: 4
    Last Post: November 21st, 07:58 AM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139