Pros/Cons of MySQL vs Postgresql for production Ruby on Rails environment?

Posted by cakeforcerberus on Stack Overflow See other posts from Stack Overflow or by cakeforcerberus
Published on 2009-08-07T03:52:32Z Indexed on 2010/04/12 13:13 UTC
Read the original article Hit count: 365

Filed under:
|
|
|

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

© Stack Overflow or respective owner

Related posts about ruby

Related posts about ruby-on-rails