MySQL RANT was: PVR or DVR for Linux - NOT MythTV

[Kristian Hermansen]

On 6/5/07, markw-FJ05HQ0HCKaWd6l5hS35sQ at public.gmane.org <markw-FJ05HQ0HCKaWd6l5hS35sQ at public.gmane.org> wrote:
> Now, if you tell my that my properly constructed queries need to be
> rewritten to work with MySQL, I will tell you instead that MySQL is
> lacking basic SQL functionality.

I took a course in college where we went into database design and
optimization.  We used PostgreSQL over MySQL.  I found the same to be
true of what you just said.  However, most people don't know that
PostgreSQL's features are a super-set of MySQL.  And to be honest,
probably most people who are using databases are using them
inefficiently anyways and don't care.  Many people also associate LAMP
and that's where their MySQL experience comes from.  If it didn't
spell "lamp", that stack wouldn't be as successful.  Who wants to sit
on my "LAPP" stack instead?  I think people get familiar with one
implementation and forget the rest because it is so popular.  This
happens all the time, even if a better product exists.  Everyone who
knows databases already knows that PostgeSQL is of much higher
quality.  You just have to worry about the rest of the people...

However, SQLite performance is a bit shabby, even in comparison to MySQL!!!
-- 
Kristian Hermansen

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.