Re: The future of Java
Lew wrote:
I rate MySQL far, far below Postgres, Derby and the free versions of
Oracle DB and IBM DB2.
Arne Vajh??j wrote:
We do know that there is a "cult" of people that believe that
PostgreSQL is "enterprise" and MySQL is "toy", but given that
MySQL dominates the highend over PostgreSQL the reality seems
to be the exact opposite.
My comments are based on my experience with the platforms, and that of
colleagues who've used them, and are my own personal assessment. YMMV.
What evidence do you have that MySQL "dominates" the high end over PG?
Performance charts that I've seen, hardly to be taken as gospel but perhaps
indicative, show PG maintaining faster performance over MySQL for larger
databases that need referential integrity and other features not available in
the MyISAM engine. Anecdotes told me by colleagues speak of data corruption
and other problems with MySQL that I have not heard about PG. Other anecdotes
from colleagues compare Postgres's performance favorably to Oracle DB in some
circumstances. I've not encountered anyone who's found MySQL superior to
Postgres in their actual work, but I have encountered the contrary.
The relational databases I've used professionally that have done well on the
high end have included Oracle DB, IBM DB2 and Red Brick. I use Postgres in my
personal development projects but that does not represent any sort of "high
end". MySQL has only annoyed me, even at the low end, to the point where I
simply will not consider it for anything serious.
My major complaint with MySQL is its weakness in the implementation of SQL.
It's so far out of standard as to make it a real PITA to use. I detest it.
Extrapolate as you will from this single data point.
--
Lew