From: Austin Ziegler Date: 2005-04-07T23:38:14+09:00 Subject: Re: In-depth schema details in ActiveRecord On Apr 7, 2005 10:16 AM, B. K. Oxley (binkley) wrote: > Austin Ziegler wrote: >> Never mind that MySQL is perhaps the crappiest SQL database that > I sense a feeling of hostility. Hostility toward MySQL? Absolutely. It's an SQL-like database that barely implements anything remotely close to a proper database. (You want something that is ACID from the get go? You *don't* want your table and column names to be case sensitive by default? You must be an anti-open source advocate.) Hostility toward AR? Not at all. Disappointment that such an otherwise useful framework uses such crap as MySQL as its driving principles. >> exists that doesn't even fully conform to the ANSI SQL92 >> specification and uses platform specific behaviour to determine >> whether tables should be case-sensitive or not (when the ANSI >> SQL92 specification clearly states that they should not, unless >> enclosed in double quotes). > Where might I find a good comparison of the level of support of AR > for each of the various supported databases? I don't know; I haven't done anything with AR in a while, since I found that it uses a broken model and have no current need for a database (or even a pseudo-database like MySQL) in any of the applications I'm developing at the moment. I suspect that the level of support for anything outside of MySQL is iffy, at best. -austin -- Austin Ziegler * halostatue@gmail.com * Alternate: austin@halostatue.ca