Are we mischaracterising mysql? Re: 12 Silver Bullets

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Subject: Are we mischaracterising mysql? Re: 12 Silver Bullets
Date: 2007-08-16 19:12:20
Message-ID: 46C4A194.2000800@cheapcomplexdevices.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy

Simon Riggs wrote:
>
> - MySQL's feature set corresponds to ...:
> mostly read-only, simple SQL, design implemented by developers, so no
> DBA required.
>
> - PostgreSQL's feature set works for "difficult/complex" web apps.

Really. It looks to me like MySQL's niche that postgresql doesn't yet
touch is in the most complex, most insert/update intensive applications.

The two reference MySQL projects that first come to my mind are
the Sabre airline system[1]; and Google Adwords[2,3]. Both
extremely update intensive applications - far beyond what I see
PostgreSQL being used for.

In contrast - I see postgresql's successes mostly in simple (single
monolithic instances) and read-mostly applications (data mining
like Genentech's case study on the web site).

While I totally agree with Josh that Oracle's $7.2Billion database
revenue [4] is way more interesting than MySQL's $0.05Billion; it
seems a bit odd to see people suggesting that MySQL is for simpler and
read-mostly systems; when it seems the most complex and most update
intensive applications are the niche that it has that PostgreSQL
doesn't yet.

What am I missing?

[1] http://h71028.www7.hp.com/enterprise/downloads/Sabre-HP-MySQL-case-study.pdf
[2] http://xooglers.blogspot.com/2005/12/lets-get-real-database.html
[3] http://zurlocker.typepad.com/theopenforce/2005/12/googles_use_of_.html
[4] http://www.sqlmanager.net/en/news/sql/1189

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Ron Mayer 2007-08-16 19:18:03 Re: DBA-Village Poll
Previous Message Ron Mayer 2007-08-16 18:31:01 Re: default_text_search_config and expression indexes