From: Dick Davies <rasputnik@...>
Date: 2004-11-25T00:24:04+09:00
Subject: Re: Other ORMs [was: rails is awesome]

* Austin Ziegler <halostatue@gmail.com> [1109 15:09]:
> On Thu, 25 Nov 2004 00:01:11 +0900, Dick Davies
> <rasputnik@hellooperator.net> wrote:
> > * Austin Ziegler <halostatue@gmail.com> [1142 14:42]:
> > > In practice, with a putative Oracle connector to AR, AR simply won't
> > > work, because Oracle's metadata tables always return the data in
> > > uppercase -- unless the table name is quoted.
> > >
> > > MySQL is a bad model -- it doesn't actually do much of anything right.\
> > And you just found this out?
> > Have you been living in a cave for the last 5 years? :)
> 
> No, I've known it for a long time. I just didn't realise until the
> last couple of days that ActiveRecord embeds MySQL semantics into its
> otherwise nice data modeling techniques.

Sorry, I'm being flippant because I'm creating a db for rails to use, so
I don't see this as a big issue. Having a legacy DB  would probably sober
me up.

But surely even then this shouldn't affect many people?
(my class still starts with a capital letter, right?  And how many people
have a customers and a Customers  table? )

Strikes me it would bite more people switching from mysql -> sql92 than
going the other way.
(Incidentally, does windows still have case-insensitive filenames?)


The main concerns I have with mysql-centricity are more data-related -
- does mysql still do case-insensitive string searches these days?

But again, I'd see the postgres (or oracle, etc, etc) adapter as the
place to scatter a little 'tablename'.casecmp() magic to fix that..

Anyway, I do feel your pain, Austin.

-- 
That question was less stupid; though you asked it in a profoundly
stupid way. - Prof. Farnsworth
Rasputin :: Jack of All Trades - Master of Nuns