Need concrete "Why Postgres not MySQL" bullet list

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-advocacy(at)postgresql(dot)org
Subject: Need concrete "Why Postgres not MySQL" bullet list
Date: 2003-08-20 15:39:28
Message-ID: 200308200839.28230.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-general pgsql-hackers

Folks,

I need someone to prepare a standard response for me to send out to inquiries
on this topic. I get them a lot.

What I'd like is a factual, non-perjorative list of the things which
PostgreSQL and the PostgreSQL project have that MySQL does not, with a little
bit of explanation by each. Where links can be provided, please do so.
Examples:

PROCEDURES: Postgres supports stored procedures (as functions) allowing
programming in the database for the many tasks which are far more efficient,
consistent, and secure done there. Procedures may be written in any of nine
different languages, currently, with two more in development. MySQL does not
support procedures at all.

TRANSACTIONS: blah, blah, blah. MySQL has just begun offering transactions
this year, and their solution is largely untested, slow, and suffers from
complications with the many different "table types". PostgreSQL's MVCC
transaction support, on the other hand, has been in use in production in
numerous environments for over six years.

Can anyone do this?

--
Josh Berkus
Aglio Database Solutions
San Francisco

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Josh Berkus 2003-08-20 15:41:12 Re: Draft #7: yet more dramatic changes
Previous Message Josh Berkus 2003-08-20 15:25:47 Re: Draft #7: yet more dramatic changes

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-08-20 15:58:57 Re: Buglist
Previous Message scott.marlowe 2003-08-20 15:16:19 Re: Buglist

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 2003-08-20 16:11:38 Re: Buglist
Previous Message Bruno Wolff III 2003-08-20 14:56:27 Re: Buglist