which d should I choose?

rubyonrails-talk
1

Hi   I am planning to start a new rails project. I would like to know from two options mysql and postgresql which i should use? Can anyone please compare them?

Thanks Tom

2

The first thing to consider is which is available on the server where you plan to deploy the application.

If you have a free choice then postgresql is generally considered superior I believe.

Of course if you require the answer for a student assignment then google is the place to start your research.

Colin

3

It really depends on the type of application you wish to develop. For example, MySQL's MyISAM database format is fast for applications that require more reads than writes, yet it doesn't support transactions.

I would read up on the differences and choose your database for your specific application. The wonderful thing, however, is that rails will abstract most of it away so for a project that is just starting up it shouldn't even matter; you could develop it with sqlite and figure it out later.

Jeff Aigner

4

Hi Colin

Thanks for reply.Any other detailed links or thoughts broadly compares the merits/demerits ? Any thoughts?

Tom

5

Additionally we have the authority to choose db since deployed on our server

6

I have little personal experience but Google for compare mysql postgresql yields many results.

Colin

7

I have, and continue to use both. As they both live behind ActiveRecord they are much of a muchness. They work and I don’t have to give them much thought.

If you are just using them as plain databases then flip a coin there is no real difference between the two. However in the companies that I have work in for the last 13 years as a web developer in Perl, Java and Ruby PostgreSQL has been used on almost all projects except three. MySQL was use on two projects (I can’t remember why we used them, I suspect it was a client requirement, but we had no issues with it) and MSSQL Server (definitely imposed by the client).

Personally I use MySQL for my own projects, but that was just because I had it installed.

To be honest PostgreSQL and MySQL are both solid and trusted databases that work well in large production environments and are well supported, it comes down to personal choice, just like the editor you write you code in (Vi, emacs or textmate?). People can become passionate about which editor / database they use but this doesn’t mean one is better than the other.

Flip a coin, heads install PostgreSQL, tails install MySQL.

Then get back to the important part, developing the application.