Andrew Pace wrote: > I too choose PostgreSQL by default. > > Here are some of my reasons. > > 1) It adheres more reliably to SQL standard than MySQL. > 2) PostgreSQL has a better query planner than MySQL. > 3) The number value zero in MySQL is treated NULL. > 4) The default settings for MySQL make it case IN-sensitive. > 5) Until version 5.0, MySQL did not support referential integrity, or > advanced features like views, transactions, or triggers.
What he said. Also: * mySQL's procedural language sucks (less of a problem than it used to be, since I don't use stored procedures as much). * I use PostGIS a lot. There is nothing comparable for mySQL. * MySQL makes you choose between speed and data integrity. PostgreSQL does not. * I have yet to see anything in mySQL that Postgres cannot do better. > > Just my thoughts. > > Andrew Best, -- Marnen Laibow-Koser http://www.marnen.org [email protected] -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
