From: Austin Ziegler Date: 2005-04-07T23:11:57+09:00 Subject: Re: In-depth schema details in ActiveRecord On Apr 7, 2005 9:41 AM, Gavin Kistner wrote: > Doing more digging, I assume that the reason these sorts of > deep-schema-inspection details don't exist in AR is that (from what I > can tell) not all DBs support this level of inspection in the > interfaces. MySQL, notably. > I'm a rails noob, just starting out. Perhaps I'm wrong. I doubt you're wrong, as DHH has stated several times in the past that the canonical database for Rails (and thus AR) is MySQL. That's right. The entire semantics of AR are based on what MySQL does. Never mind that MySQL is perhaps the crappiest SQL database that 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). I don't know if Og does this better or not. -austin -- Austin Ziegler * halostatue@gmail.com * Alternate: austin@halostatue.ca