MySQL or PostgreSQL

Started by Seofinder, 04-21-2010, 18:27:19

Previous topic - Next topic

SeofinderTopic starter

Something has surprised me. I can not remember a single post on this forum about

   1. PostgreSQL: The world's most advanced open source database postgresql site:webproworld.com 41 hits but
   2. many about MySQL :: The world's most popular open source database mysql site:webproworld.com 1230 hits

Both are free and some database experts seem to agree that PosgreSQL is a better database platform.

So my simple question is why do so many seem to prefer MySQL over PostgreSQL?

Is it simply because of a larger online community?
  •  


Sevam

MySQL is easier to manage with multiple users on the same server.
This is important for an ISP.
ISP's therefore leaned toward offering MySQL.
Because it was readily available on servers more developers used it.

PostgreSQL is a better choice for enterprise applications.
MySQL is better for non-transactional web site usage.


PCKen

Personally I haven't heard of PostgreSQL, I like to stick with popular things like MySQL so I'm less likely to screw up.  But I can see the advantages of PostgreSQL
  •  

ravi

sql- structured query language...................

electra

I believe it's because of the larger online community and that MySQL seems to be more trusted as a database platform because of it's wide usage. I could be wrong though.
Reliable hosting? try HOSTGATOR and WEBHOSTINGHUB.
  •  


mmeetkaur3

I know only sql not postsql.
http://www.zaydenmortgage.ca/ , http://www.heightincrease.in
, http://www.sharekhantips.com/
  •  

saravanan28

Postgres is an object-relational database, while MySQL is a purely relational database. This means that Postgres includes features like table inheritance and function overloading, which can be important to certain applications. Postgres also adheres more closely to SQL standards.
  •  

dark404

MySQL is easier to manage with multiple users on the same server.
This is important for an ISP.
ISP's therefore leaned toward offering MySQL.
Because it was readily available on servers more developers used it.

PostgreSQL is a better choice for enterprise applications.
MySQL is better for non-transactional web site usage.