So you're switching to PostgreSQL from MySQL? Here is some help... General hints on PostgreSQL \? opens the command overview...

Rails gives you migrations to change your database schema with simple commands like add_column or update. Unfortunately these commands...

Rails understands a :limit options when you create columns in a migration. Its meaning depends on the column type, and...

validates_uniqueness_of is not sufficient to ensure the uniqueness of a value. The reason for this is that in...

For string columns, MySQL indexes the left side of a string. That means an index can speed a like query...

When requests arrive at the application servers simultaneously, weird things can happen. Sometimes, this can also happen if a user...

An association defined with has_many :through will return the same record multiple times if multiple join models for the...

In MySQL comparing zero to a string 0 = "any string" is always true! So when you want to compare a...

When selecting records in a date range, take care not to do it like this: start_date = Date.parse('2007-05...

Note: This applies specifically to MySQL. In PostgreSQL for example, this is not an issue. If you care about performance...

If you want to have an English Ubuntu UI, but still see dates, money amounts, paper formats, etc. in German...

When storing floating-point numbers such as prices or totals in an SQL database, always use a DECIMAL column. Never...

Note: For PostgreSQL you should use advisory locks. For MySQL we still recommend the solution in this card.

CONCAT('foo', 'bar', NULL) = NULL the NULL always wins in MySQL. If you would rather treat NULL as...