If you GROUP BY, make sure you ORDER BY NULL

Posted About 11 years ago by Marcus Mitchell.

TL;DR: If using :group => :some_field you might want to :order => 'NULL'. According to the man By default, MySQL...

DateTimes are Dates, beware

Posted About 11 years ago by dncrht.

datetime = DateTime.now date = datetime.to_date #or Date.today will assert: datetime.is_a? Date == true datetime.is_a? DateTime == true datetime.instance_of...

When you set date attributes, you should not pass times

Posted About 11 years ago by Arne Hartherz.

As you know, time zones make stuff a bit more difficult but are necessary. A time-zoned record is converted...

Database: Scopes, migrations, and indices

Posted Over 11 years ago by Julien Letessier.

Wether you modify an existing named scope or add a new one, or when you write a new query, make...

Writing raw SQL queries

Posted Over 11 years ago by Julien Letessier.

If you really, really have a good reason to write raw SQL (generally a bad practice), make sure you use...

ActiveRecord::NamedScopes (2.3.x) obtaining the SQL conditions

Posted Almost 12 years ago.

It's a good pratice to chain several named scopes like: Property.listable.for_2_or_more_guests.best_10_properties Now, to make the lesson more...