> used MySQL rather exclusively in the past couple of years. I
> agree with Scott that Micha's list seems to be out-dated or
> not explained well.
The biggest criticism that Micha mentioned isn't really enumerated in the
list - the unsuitability of MySQL in environments where data integrity is
more important than everything else. It's kind of worrisome to hear people
giving blanket recommendations to "use MySQL" instead of using, say, Access,
because data integrity is one of those things that people tend to take for
granted when using an RDBMS.
> 2. SELECT 'A' = 'a' gets you true.
> This would be true because MySQL does a non-case-sensitive
> compare. If you wanted to know of 'A' = 'a' then use BINARY.
> Now, this is just the way it's done in MySQL and if you
> don't like that, then use a different product.
Many databases allow you to control collation.
> 6. Adding indices result in a similar temporary copy.
> Yea, but how many times are you adding a new index? It's not
> like it does it on every SELECT statement.
It's pretty common to create new indexes after observing database
performance - you learn what fields are being used more than others, and you
apply indexes to those fields.
> 4. Tablenames are treated case-sensitive on *nix systems, not
> on windows.
> I believe this not to be a MySQL specific problem. Look at
> using CFML pages on *nix vs Windows and you'll have the same
> problem. It's probably a file system thing.
It may be a filesystem thing, but tablenames are treated the same way in,
say, Oracle on Solaris as they are in Oracle on Windows. I think that's true
for most cross-platform RDBMSs.
> A lot of these I must say you can't get anything better than
> MySQL for free (maybe PostgreSQL).
I would say that PostgreSQL is much better than MySQL for many use-cases.
MySQL may be much better than Postgres for others.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
