Tools to help parametrize queries.

activerecord_extras provides utility methods and scopes for ActiveRecord models, including EXISTS and COUNT subqueries on has_many associations, and SQL helpers for boolean casting.

Break large filters into components and see how each component affects the result

Easy way to add scopes to your models.

ActiveRecord extension to filter records by a given set of parameters

ActiveRecord::FilterWithScope extends Rails ActiveRecord gently to filter records out of the box. The handy tool that lets you filter your ActiveRecord models using the scopes you have already defined. All you need to do is map the filter parameters to the corresponding scopes in the setup, and then call the filter class method on your model.

Easily find all duplicate records)

Allow custom sort order with find_each behavior

Better finder syntax (|, &, >=, <=) for ActiveRecord.

Provides find_only and find_only! query methods

This fixes the DEFAULT_LIMIT set to 4 bytes in ActiveModel::Type:Integer.

A simple fixture builder for active record

Provide an easy way to define boolean getters and settings on an integer column in active record objects.

Optionally prevents threads from checking out activerecord connections.

ActiveRecord extension that gives USE and FORCE index to any ActiveRecord Model.

Allows for larger level scoping (framing) that affect complicated queries more holistically

Use this gem to auto define Finite State Machine on ActiveRecord with one column named `status`.

Integrate PostgreSQL's Full Text Search configurations with Rails

Fuse attributes from associated models with ActiveRecord

ActiveRecord::Ghosts allows you to define a sequence column and query with ranges to get real + ghost records. Ghost records behave like AR objects but aren't persisted, perfect for filling gaps in sequences like levels, numbers, etc.