The MySQL question.

[Lamar Owen]

On Friday 10 September 2004 06:24, Thomas Zehetbauer wrote:
> Where MySQL provides performance, reliability, standards conformance,

PostgreSQL is as high performance as MySQL (where MySQL is using InnoDB 
tables) and the load is multiple users.  Benchmarks are there.

PostgreSQL's reliability is good enough to run the .ORG domain registry, and 
MySQL is not even a competitor in that space.

PostgreSQL is considerably more ANSI SQL-99 compliant than MySQL.  And don't 
get me started about MySQL's data corruption by design issues because 
<sarcasm>throwing an error hurts performance.... </sarcasm>.... See 
http://sql-info.de/mysql/gotchas.html for more information.

MySQL is a toy database that is getting better.  It's like running a 
industrial robot with a Lego Minstorms controller.  Competition is good; but 
SQLite is MySQL's competition, and SQLite is faster.  PostgreSQL is not 
MySQL's competitor; think Oracle, Sybase, and MS-SQL instead.
-- 
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC  28772
(828)862-5554
www.pari.edu