View Poll Results: What are your thoughts on PostgreSQL versus MySQL?
- Voters
- 19. You may not vote on this poll
Results 1 to 20 of 20
Thread: PostgreSQL or MySQL?
-
04-07-2008, 11:27 AM #1Junior Guru Wannabe
- Join Date
- Jan 2005
- Location
- Philadelphia Suburbs
- Posts
- 39
PostgreSQL or MySQL?
I wanted to get a sense of the usage of Postgres versus MySQL. Does anyone here prefer Postgres over MySQL?
-
04-07-2008, 11:40 AM #2Web Hosting Master
- Join Date
- Oct 2007
- Posts
- 1,903
I think that all depend. That like compare Honda and Ford. I believe there are lots of fans of PostgreSQL and plenty of MySQL
ServerPoint.com - a true hosting company offering online presence solutions since 1998.
>>Web Hosting, colocation, dedicated servers and virtual private dedicated servers.
>>>>Wholly owned multi homed network, servers and facilities.
-
04-07-2008, 11:42 AM #3Disabled
- Join Date
- Apr 2008
- Posts
- 25
I would say that MySQL is used more than PostgreSQL, but then you will find companys that disagree whom use PostgreSQL, but even companys whom use it, will use MySQL Along side it..
-
04-07-2008, 11:44 AM #4Web Hosting Master
- Join Date
- Aug 2002
- Location
- Superior, CO, USA
- Posts
- 635
-
04-07-2008, 11:49 AM #5Web Hosting Master
- Join Date
- Aug 2003
- Location
- Dallas, TX USA
- Posts
- 2,812
I don't think anyone can come up with reasons why you should use MySQL over PostgreSQL, besides the fact that more people use MySQL. On the other hand, there are reasons to use PostgreSQL over MySQL.
-
04-07-2008, 11:57 AM #6Junior Guru Wannabe
- Join Date
- Jan 2005
- Location
- Philadelphia Suburbs
- Posts
- 39
So, besides the ubiquity of MySQL, why has Postgres not overtaken MySQL?
Is it lack of clear support offerings for webhosts? Is it lack of an integrated webhosted offering (control panel, admin console, etc) Is it upstream (ie the big guys that a lot of resellers use don't offer it)? Is it an education issue?www.rodstar.net
RODSTAR.NET - Affordable Web Hosting Without Compromise
-
04-07-2008, 01:31 PM #7Web Hosting Guru
- Join Date
- Aug 2005
- Posts
- 309
-
04-07-2008, 01:40 PM #8Web Hosting Master
- Join Date
- Jan 2001
- Location
- Kihei, HI
- Posts
- 576
MySQL is fantastic and works for most people most of the time. I think for the majority of users they should look to MySQL first, since its everywhere and it is used for most web applications by default.
There may be particular reasons you would prefer PostgreSQL over MySQL and that is fine. Go ahead and use it. Its not like its that hard to install PostgreSQL if you need it. If you're not a server admin its pretty easy to find a web host that has PostgreSQL support now.:: 1StopWebHosting.com :: - Professional Web Hosting Services
::
:: Featuring the CPanel Control Panel running on CENTOS Linux servers
:: We offer Shared Web Hosting, Business Hosting, Java / J2EE Servers and Dedicated Server solutions.
-
04-07-2008, 01:44 PM #9Web Hosting Guru
- Join Date
- Jan 2005
- Posts
- 326
It doesn't matter which DB System that I use. Most hosts offer MySQL standard but there are fewer hosts that offer PostgreSQL. Why some hosts don't offer PostgreSQL I have no idea. I think hosts should offer both DB Systems but that means one more thing to keep up with.
Charles
-
04-07-2008, 02:02 PM #10Junior Guru Wannabe
- Join Date
- Mar 2008
- Posts
- 47
MySQL has been backed by commercial support from the beginning and has also had excellent Linux distribution support right from scratch. Postgres has had efforts to get commercial and is is commercially supported even now. First came Great Bridge, then Command Line, Inc, and then Pervasive Software. They all failed for various reasons.
FluidVM :: Manage Xen PV, Xen HVM and OpenVZ
Multi-Hypervisor, Extensible Virtualization Platform :: Website :: User Forums ::
Simple Browser based UI-Simple User VPS Control Panel!
-
04-07-2008, 02:14 PM #11Junior Guru Wannabe
- Join Date
- Jan 2005
- Location
- Philadelphia Suburbs
- Posts
- 39
What about now? EnterpriseDB has been doing the Postgres thing for 3 years now. They just launched Postgres Plus which is a full distribution with administration built in, etc. They have a high end support offering though.
Its 995/socket for business hours support and $2495/socket for 24/7 support. What if they had special support packages for smaller webhosts?
-
04-07-2008, 03:17 PM #12Web Hosting Master
- Join Date
- Aug 2004
- Location
- Canada
- Posts
- 3,785
█ Tony B. - Chief Executive Officer
█ Hawk Host Inc. Proudly serving websites since 2004
█ Quality Shared and Cloud Hosting
█ PHP 5.2.x - PHP 8.1.X Support!
-
04-07-2008, 03:28 PM #13Web Hosting Master
- Join Date
- Aug 2003
- Location
- Dallas, TX USA
- Posts
- 2,812
-
04-07-2008, 04:12 PM #14Junior Guru Wannabe
- Join Date
- Jan 2005
- Location
- Philadelphia Suburbs
- Posts
- 39
Yeah, not sure I buy that statistic. I agree that MySQL has more mindshare right now, but the delta is not great.
I would be interested in some legitimate stats, if available.www.rodstar.net
RODSTAR.NET - Affordable Web Hosting Without Compromise
-
04-07-2008, 04:20 PM #15Retired Moderator
- Join Date
- Oct 2002
- Location
- EU - east side
- Posts
- 21,920
Where did you pull that statistic from?
-
04-07-2008, 04:46 PM #16Web Hosting Master
- Join Date
- Apr 2004
- Location
- UK
- Posts
- 1,334
It is a question of requirements.. http://www-css.fnal.gov/dsg/external...-vs-mysql.html - Postgre has native support for transactions, support for full joins, unions, table views and triggers but is slower.
MySQL is faster, doesn't support transactions as explicitly (and cannot without InnoDB) and is better at handling large text lumps..
» Kayako customer service software and live chat software- your customers deserve better than helpdesk
-
04-07-2008, 04:51 PM #17Junior Guru Wannabe
- Join Date
- Jan 2005
- Location
- Philadelphia Suburbs
- Posts
- 39
Jamie,
that is a woefully outdated document (2005). Both databases have improved dramatically since then.
Try this: http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL
or this: http://wiki.postgresql.org/wiki/Why_..._Speed_in_2007www.rodstar.net
RODSTAR.NET - Affordable Web Hosting Without Compromise
-
04-07-2008, 04:55 PM #18Web Hosting Master
- Join Date
- Aug 2003
- Location
- Dallas, TX USA
- Posts
- 2,812
-
04-07-2008, 05:06 PM #19Web Hosting Master
- Join Date
- Apr 2004
- Location
- UK
- Posts
- 1,334
Yes - it is, due to Postgre's thorough handling and explicit execution of transactions. The more robust and thorough the transaction handling and vacuum, the slower the database (i.e. look at Oracle).
On todays hardware with medium sized databases, the speed differences on either may be negligible..
» Kayako customer service software and live chat software- your customers deserve better than helpdesk
-
04-07-2008, 05:08 PM #20Web Hosting Master
- Join Date
- Aug 2003
- Location
- Dallas, TX USA
- Posts
- 2,812