From: "Kujawa, Greg" Date: 2005-04-07T23:52:14+09:00 Subject: Re: In-depth schema details in ActiveRecord Agreed. I have used MySQL in the past for quick setups that required not much more than basic select statements being thrown against a database. There are more capable alternatives (such as PostgreSQL) IMHO that are proven. I know this list might be a bit dated but check out some of the MySQL "gotchas" at http://sql-info.de/mysql/gotchas.html. Some of these are staggering. Especially the ones that involve invalid/out-of-bounds data being inserted into the database... -----Original Message----- From: Austin Ziegler [mailto:halostatue@gmail.com] Sent: Thursday, April 07, 2005 10:38 AM To: ruby-talk@ruby-lang.org 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