How good is Rails and PostgreSQL support?

Question

I am thinking of working on a Rails application that uses PostgreSQL. I have some questions before I am comfortable using Rails:

• Is PostgreSQL support in Rails less superior than, say, MySQL.
• Would it feel any different if using PostgreSQL?
• Are there any cases where using PostgreSQL fail to work?

Thanks.

Answer 1

After having used sqlite, mysql and postgresql with Rails, I prefer using postrgresql.

Installation for OSX, Ubuntu and Windows went well as opposed to buggy installs for other DBs.

I had to install the following gem to use postgresql: install gem postgres-pr

It may "feel" different when you come across complex databse requests where you add in special conditions such as extracting the month from a date as the actual text will differ depending on the database system. Also, postgresql delimits strings in request with E'' so sometimes a request using a text-field may come up with an error if you're not careful with your :conditions => [].