MySQL or PostgreSQL

Author Topic: MySQL or PostgreSQL  (Read 7789 times)

Offline SeofinderTopic starter

  • Trade Count: (0)
  • Jr. Member
  • **
  • Thank You 2
  • Posts: 53
  • Karma: 2
MySQL or PostgreSQL
« on: 04-21-2010, 18:27:19 »
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?


Offline Sevam

  • Administrator
  • Trade Count: (0)
  • *****
  • Thank You 103
  • Posts: 359
  • Karma: 13
  • Gender: Male
    • Trust Directory Project
Re: MySQL or PostgreSQL
« Reply #1 on: 04-21-2010, 18:30:07 »
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.

Offline PCKen

  • Trade Count: (0)
  • Semi-Newbie
  • *
  • Thank You 1
  • Posts: 25
  • Karma: 1
Re: MySQL or PostgreSQL
« Reply #2 on: 05-09-2010, 11:16:10 »
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

Offline ravi

  • Trade Count: (0)
  • Semi-Newbie
  • *
  • Thank You 0
  • Posts: 23
  • Karma: 0
    • Seo Manual Submission
Re: MySQL or PostgreSQL
« Reply #3 on: 10-07-2011, 22:40:29 »
sql- structured query language...................

Offline electra

  • Trade Count: (0)
  • Jr. Member
  • **
  • Thank You 8
  • Posts: 88
  • Karma: 1
  • I like SEO
    • Hosting discussion
Re: MySQL or PostgreSQL
« Reply #4 on: 12-10-2011, 08:23:02 »
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.


Offline mmeetkaur3

  • Trade Count: (0)
  • Newbie
  • *
  • Thank You 0
  • Posts: 3
  • Karma: 0
Re: MySQL or PostgreSQL
« Reply #5 on: 11-06-2012, 22:43:18 »
I know only sql not postsql.
http://www.zaydenmortgage.ca/ , http://www.heightincrease.in
, http://www.sharekhantips.com/

Offline saravanan28

  • Trade Count: (0)
  • Sr. Member
  • ****
  • Thank You 2
  • Posts: 301
  • Karma: 0
Re: MySQL or PostgreSQL
« Reply #6 on: 06-10-2021, 01:48:40 »
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.

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
2852 Views
Last post 10-17-2011, 02:12:57
by manvbf
4 Replies
4145 Views
Last post 07-16-2012, 07:07:34
by sunilkumar
1 Replies
2802 Views
Last post 01-04-2014, 02:37:25
by Luca tall
0 Replies
1643 Views
Last post 12-23-2015, 04:45:59
by chinmay.sahoo
0 Replies
1565 Views
Last post 11-14-2016, 03:19:21
by aarav