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

* 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? :)

As a postgresql advocate (I started with pgsql over mysql because
	a) I wanted to learn SQL, not mySQL
	b) in those days mysql had a *lot* of missing features
	c) I'm perverse when it comes to choosing the underdog
)

I have to say I'm pleased there's any support for postgres in there at all -
I have a mysqldb running alongside my postgresql one purely for supporting 
the dozens of great open source projects that don't dig pgsql, or are stuck
with mysql because it's got its tentacles so deep into the codebase that
no one wants to go through abstracting it out.

[ JDBC thinks it makes this easier, but IMO that's just marketroid hypnosis ]

And these are usually the guys who wrote the project, so being a lazy kind of
sysadmin I slap on mysql and make obscene gestures at it when I need a break
from typing...

From my very limited experience of Rails (almost 24 hours now, woot!) it
seems to expect a fair bit from the database structure, especially in
naming conventions. I don't really see this issue as any different.

I'm assuming there's a way to customize those assumptions in ActiveRecord,
or the adapter. If that's a bit low-level and/or hackish, I'd say that
should be on the feature wishlist for later versions as much as SQL
compliance, since expecting new users to rebuild their database to support
a new MVC kid in town is easily as unrealistic as persuading them to switch
from oracle  to mysql....

[ Incidentally can I make it clear here I'm not slagging rails, David.
I have no wish to be its new maintainer :) ]

-- 
Everybody's a jerk. You, me, this jerk. - Bender
Rasputin :: Jack of All Trades - Master of Nuns