Groupdate to group temporal data in Active Record

There are lots of things that can make your life easier. Like cars, planes, electricity, light…Ruby on rails. Ok, let’s be more specific and talk about Groupdate, the simplest way to make easy group queries in SQL. Add various types of charts and use Groupdate to group temporal data in Active Record.

The simplest way to group by:

day
week
hour of the day
and more (complete list below)

It supports PostgreSQL, MySQL, and Redshift, plus arrays and hashes.

Use it anywhere you can use group. Works with count, sum, minimum, maximum, and average. For median, check out ActiveMedian. For other aggregate functions, including multiple together, check out CalculateAll.

Groupdate has limited support for SQLite.

No time zone support
No day_start or week_start options
No group_by_quarter method

Groupdate 4.0 brings a number of improvements. Here are a few to be aware of:

group_by methods return an ActiveRecord::Relation instead of a Groupdate::Series
Invalid options now throw an ArgumentError
week_start now affects day_of_week
Custom calculation methods are supported by default

As Ruby on Rails agency, we created the new digest with interesting and useful Ruby/Ruby on Rails open source projects.