From: Austin Ziegler <halostatue@...>
Date: 2006-09-13T01:57:02+09:00
Subject: Re: Joel Spolsky on languages for web programming

On 9/12/06, Keith Gaughan <kmgaughan@eircom.net> wrote:
> On Tue, Sep 12, 2006 at 09:08:44PM +0900, Austin Ziegler wrote:
> > That's one. An aversion to foreign keys (which, contrary to DHH's
> > assertion, *can* encode the relationships captured by most of the
> > (Worse, MySQL behaviour is not consistent on this matter; on Windows,
> > MySQL itself is case-insensitive but AR is still case-sensitive. MySQL
> > is one of the worst damned implementations of SQL ever. Still.)
> That's with respect to table names rather than column names, and really only
> effects MyISAM tables. InnoDB tables don't have that problem, if I remember
> correctly. BDB and others I'm not so sure about because I haven't had need to
> use them myself.

IME, it is something with MyISAM (which is still the most common
configuration because it offers pure speed) and it *does* affect
column names as well even though it shouldn't for the stupid reasons
that tables are affected.

MySQL is a big sticking pile that should be left in the scrapheap.

-austin
-- 
Austin Ziegler * halostatue@gmail.com * http://www.halostatue.ca/
               * austin@halostatue.ca * http://www.halostatue.ca/feed/
               * austin@zieglers.ca