Peter Song wrote in post #1014023: > Mysql or Postgresql? Or some other database. > > What do you prefer and does it really matter down the road? Anybody have > disaster stories where you choose one and it turned out another would > have been better? Do you use different dbs depending on the job or do > you stick with the same one always?
I'm afraid that asking this question here on this forum (or any similar forum) is probably going to leave you more confused than you are right now. As for me I typically use MySQL in production and SQLLite in development. I do this for a couple of reasons, but primarily it helps to keep my code database agnostic. Also, using SQLLite in development makes things really easy and convenient. As I said, I typically use MySQL in production, but that doesn't mean I think MySQL is the best database. PostgreSQL is probably the better database. However, I know MySQL better since I've been using it longer, and I find the setup and configuration of MySQL to be easier for me. I'm also not a concerned about my choice since MySQL is serving the needs of my application. Paraphrasing from something I read somewhere, "If you haven't yet deployed, then you don't have a scaling problem." In other words choose the database that you feel most comfortable with and use it. Chances are it will work out just fine. If it doesn't, and you've written clean database agnostic code, then you can switch to something else once you've proven, with metrics, that your choice isn't doing the job. -- 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 rubyonrails-talk@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
