| From: | "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com> |
|---|---|
| To: | "Duncan Garland" <duncan(dot)garland(at)ntlworld(dot)com> |
| Cc: | pgsql-advocacy(at)postgresql(dot)org |
| Subject: | Re: Postgres v MySQL 5.0 |
| Date: | 2006-10-21 07:12:04 |
| Message-ID: | 7be3f35d0610210012k24d76324rbaaac1db7afcf5ca@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy |
Duncan,
MySQL is more popular but I've always regarded it as a bit lightweight. I'm
> told that this is no longer the case with 5.0. Why choose Postgres over
> MySQL 5.0?
>
There are a big bunch of arguments that I would present if on a paid
consulting contract :)
But for free:
a) PostgreSQL has BSD licence, MySQL GPL or commercial. Please consult you
legal advisor for differences.
b) PostreSQL is known for being correct, robust and trustworthy for years.
"Users data is sacred" is the mantra of every postmaster process. Since 8.0,
8.1 and the upcoming 8.2, PostgreSQL is additionally known to be
exceptionally fast.
MySQL is known to be fast for simple queries since years; and with 5.0 on
some storage engines there is announced correctness as spelled with ACID.
My personal decision: To believe in correctness and to build trust I need
time and history. To check speed I run benchmarks, which complete in
minutes.
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Python: the only language with more web frameworks than keywords.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lukas Kahwe Smith | 2006-10-21 07:40:58 | Re: Postgres v MySQL 5.0 |
| Previous Message | Jeff Davis | 2006-10-21 00:21:06 | Re: Postgres v MySQL 5.0 |