Allows DateTime fields to be split into a Date field and a Time field.

Adds accessors to a class so that the date can be set as a string while days, months and years can be set as integers. It also allows for month as short and long text inputs, e.g. Jan, March. It will validate resulting dates and generate errors when parts are invalid and where combined p...

sportweb - instant open sports web admin browser command line tool

This module implement [to_spreadsheet | xls] to ActiveRecord::Relation

Log MySQL queries with EXPLAIN that may be slow.

Short, unique, and human-readable IDs for ActiveRecord models with Sqids.

Add virtual attributes to an ActiveRecord model based on an SQL query.

Use builder pattern to create ad-hoc SQL queries that aren't tied to models but return read-only plain Ruby objects.

A Ruby client for sqlcached

Use ActiveRecord to execute SQL against any DB to export CSV

The SQLite3 adapter in Rails 4 doesn't support JSON columns. This gem adds it via a railtie and a series of hacks.

No more '...sqlite_master...' queries in your log when using sqlite

Fork from ankane! Explore your data with SQL. Easily create charts and dashboards, and share them with your team.

SqlLoader allows you to keep your plain SQL queries as files instead of mixing them in your ActiveRecord models.

ActiveRecord extension that provides large performance improvements when you need large sets of read-only data and do not need the magic of ActiveRecord.

Query assertions and SQL matchers for RSpec.

This gem will help setup partitioning on a table, based on its `timestamp` column. Once you have a table that is partitioned based on a timestamp, you will likely need to regularly add new partitions into the future, and drop older partitions to free up space. This gem can help ca...

Provide #pluck_by_sql for Rails ActiveRecord models

A Ruby on Rails gem that analyzes SQL queries and suggests optimizations like missing indexes, inefficient sorts, and risky joins.

Do you use ActiveRecord::Connection.execute for speed sometimes? Does it bother you that the results are not mapped to your schema and type-cast as ActiveRecord would? Well that's what SQLRecord does.