Pros/Cons of MySQL vs Postgresql for production Ruby on Rails environment?
- by cakeforcerberus
I will soon be switching from sqlite3 to either postgres or mysql. What should I consider when making this decision? Is mysql more suited for Rails than postgres in some areas and/or vice versa? Or, as I somewhat suspect, does it not really matter either way?
Another factor that might play into my decision is the availability of tools to data pump my test data from the sqlite3 db to my new one. Is there anything that ActiveRecord provides natively to do this or any decent plugins/gems to help with this task?
BONUS: How do I pronounce "Postgresql" and sound like I know what I'm talking about? :)
Thanks Greg Smith for providing the following link that shows the most common pronunciations:
http://www.postgresql.org/community/survey.33
UPDATE:
Reference this question for more:
http://stackoverflow.com/questions/110927/do-you-recommend-postgresql-over-mysql
FYI:
I ended up using MySQL. There is a neat plugin called yamldb that really saved me some time with the data transfer from my sqlite db to my new mysql one. Instructions on how to install and use it can be found here:
http://accidentaltechnologist.com/ruby/change-databases-in-rails-with-yamldb/
Thanks
Tom