> 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.
Actually, the only true reason to choose PostgreSQL over MySQL is this: you know PostgresSQL better. As for transaction support in MySQL it is not even funny anymore. But just in case: MySQL supports transactions since version 3.23.34a Regards, Rimantas -- http://rimantas.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 -~----------~----~----~----~------~----~------~--~---
