From: Alan Garrison Date: 2005-04-08T00:12:45+09:00 Subject: Re: In-depth schema details in ActiveRecord Kujawa, Greg wrote: >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... > > I've heard the "gotchas" list is a bit out of date, but I agree with Austin in that developing from a MySQL (instead of ANSI SQL) base is unfortunate. I'm very much a PostgreSQL devote and avoid MySQL like the plague, and if a given software package is focused on working with MySQL I generally avoid it. That, and PostgreSQL just rocks anyways. :) -- Alan Garrison Cronosys, LLC Phone: 216-221-4600 ext 308