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...