Searching and Queries Plugins

Active Search: ActiveSearch is a barbarian way to give your models a sparkle of fuzzy search, which most users will surely prefer to very specific forms.
Rating: 3/5 (26 votes)
Added on 14 Apr 2006
Where Builder for ActiveRecord: An easier way to create where clauses.
Rating: 4/5 (2 votes)
Added on 14 Apr 2006
ORMQL Plugin: ORMQL (Object Relational Mapping Query Language) is a very simple query language to retrieve ActiveRecord objects from a database.
Rating: 3/5 (3 votes)
Added on 18 Apr 2006
Acts as Ferret: Mixin that uses ferret to automatically build and maintain an index for fast fulltext search within the data stored in a Rails model.
Rating: 4/5 (43 votes)
Added on 18 Apr 2006
ActiveRecord IO Mode Plugin: Redirect the SQL that ActiveRecord generates
Rating: 5/5 (3 votes)
Added on 22 Apr 2006
ez_where: This plugin augments ActiveRecord::Base#find to add ruby like syntax for queries.
Rating: 3/5 (26 votes)
Added on 22 Apr 2006
Slice and Dice: Allows construction of where clauses using a hash passed in as the :conditions option.
Rating: 4/5 (4 votes)
Added on 23 May 2006
Searchable: Module for search-enabling models using Ferret (future: multiple backends)
Rating: 4/5 (6 votes)
Added on 25 Jun 2006
Acts as Clusterable: Provides an easy way to cluster to your database records -- for example, for grouping search results.
Rating: 5/5 (2 votes)
Added on 25 Aug 2006
paginating_find: Makes it easy to load tens of thousands of model instances through the standard ActiveRecord find methods in "pages" rather than all at once.
Rating: 4/5 (43 votes)
Added on 27 Aug 2006
criteria_query: Extension to the ActiveRecord find mechanism. It allows object-oriented construction of queries.
Rating: 4/5 (6 votes)
Added on 6 Sep 2006
Date Finder: Finds dates that match criteria.
Rating: 4/5 (3 votes)
Added on 20 Sep 2006
acts_as_solr: This plugin adds full text search capabilities using the Solr engine to any Rails model.
Rating: 4/5 (16 votes)
Added on 30 Sep 2006
ZipCodeSearch: Adds radius-based location searches to your app.
Rating: 2/5 (8 votes)
Added on 31 Oct 2006
Eager Finder SQL: Use custom SQL for complex eager-loading find operations.
Rating: 4/5 (3 votes)
Added on 6 Nov 2006
JobPI (Naukri Featured Jobs API): A Naukri Featured Jobs Plugin is a small piece of code that pulls specific job listings based on your given criteria from Naukri.com web server onto to any external chosen webpage
Rating: 5/5 (1 vote)
Added on 8 Dec 2006
Condition Builder: Creates a :conditions array using Ruby blocks for use in your "find" queries. No complex mappings as in the ez_where plugin.
Rating: 4/5 (4 votes)
Added on 4 Jan 2007
Squirrel: Gives ActiveRecord::Base#find a more Ruby-like syntax.
Rating: 4/5 (5 votes)
Added on 27 Jan 2007
acts_as_tsearch: Super simple full text search for any model if you're running against Postgresql for the database.
Rating: 4/5 (3 votes)
Added on 7 Feb 2007
AutoScope: Automatically create scoped access methods on your ActiveRecord models.
Rating: 3/5 (3 votes)
Added on 28 Mar 2007
scan_fields: Alleviate's the need for long and ugly ActiveRecord::find search conditions by automatically searching all columns of a model.
Rating: 4/5 (7 votes)
Added on 29 Mar 2007
ArPaginator: Allows you to easily paginate over any existing AR queries. paginator.paginate { my_company.complete_videos }
Rating: 5/5 (1 vote)
Added on 4 Apr 2007
acts_as_fulltext_indexed: A MySQL-specific plugin that allows you to perform fulltext searching on models backed by InnoDB tables, so you get transactions, foreign keys, and row-level locking while retaining the power of fulltext search.
Rating: 5/5 (4 votes)
Added on 1 May 2007
Random Finders: Allows quick and easy fetching of random records, or records in random order. Simply pass the :random to the order in any finder method.
Rating: 4/5 (2 votes)
Added on 20 May 2007
sortable column headers: I wanted the ability to sort my tabular data using column header links.
Rating: 4/5 (8 votes)
Added on 2 Jun 2007
DynaCon: Dynamically add search conditions before you call a Model.find
Rating: 4/5 (8 votes)
Added on 15 Jun 2007
Grape: A command-line tool for searching Rails project files.
Rating: 0/5 (0 votes)
Added on 27 Jun 2007
query cache: A backport of Rails 2.0 query cache to work with Rails 1.2
Rating: 5/5 (3 votes)
Added on 6 Jul 2007
SimplySearchable: The main goal of SimplySearchable is to help you create a clean url to search in your controller and model. This plugin adds a method to the controller named "search" that will find and filter the model data smartly from the search fields defined in its calling line SimplySearchable recognizes three types of filters: 1. Exact values: like the title in the example above (acts_as_ferret implementation to come soon) 2. Belongs to associations: for those fields that ends with _id, like author_id in the example above 3. Has many association: for those fields that are in plural form, like comments in the example above
Rating: 5/5 (17 votes)
Added on 29 Jul 2007
Ultrasphinx: Ruby on Rails interface to the Sphinx full text search engine.
Rating: 5/5 (12 votes)
Added on 2 Aug 2007
Acts As Indexed: Fulltext search with zero-dependencies (No gems required) and a minimal setup. Maintains an index of content in your Rails models for fast query results.
Rating: 5/5 (5 votes)
Added on 30 Aug 2007
HitTracker: HitTracker is a very simple plugin to give you quick and easy functionality to track access to your records using ActiveRecord.
Rating: 4/5 (4 votes)
Added on 9 Sep 2007
acts_as_fulltextable: Easily perform full text searches using MySQL
Rating: 5/5 (18 votes)
Added on 4 Oct 2007
ActsAsArchivable: Methods to quickly grab records based on dates
Rating: 5/5 (4 votes)
Added on 29 Oct 2007
RailsWhere: Flexible condition builder. Supports sanitization.
Rating: 5/5 (3 votes)
Added on 31 Oct 2007
alphabar: A paginator that splits the pages based on the alphabet instead of simply page numbers.
Rating: 4/5 (2 votes)
Added on 4 Dec 2007
multi_statement_query: This plugin allows you to perform multiple statements, each optionally returning a resultset, with a single query to the database. Only MySQL is planned for now. When the DB server is remote, performance gains should be quite noticeable.
Rating: 0/5 (0 votes)
Added on 9 Jan 2008
Rquerypad: Simplify query options with association automation and improve inner join for activerecord of rails
Rating: 5/5 (2 votes)
Added on 24 Mar 2008
BolingForBatches: A Better Way To Run Methods on Heavy Query Results 1. Setup a Batch for an ActiveRecord model. 2. Run an instance method on each record in each batch (can send params too!) 3. Print the results!
Rating: 5/5 (2 votes)
Added on 16 Apr 2008
JamBase4Rails: JamBase4Rails is a plugin that provides access to the JamBase live music search API.
Rating: 0/5 (0 votes)
Added on 20 Jun 2008
Will Paginate Acts As Searchable: Integrate will_paginate with acts_as_searchable Movie.paginate_by_fulltext_search(params['q'],:page=>params[:page],:per_page=>1)
Rating: 5/5 (1 vote)
Added on 6 Jul 2008

Agile Web Development

Build it. Launch it. Love it.

Searching and Queries Plugins

Search Plugins

Plugins by Category

Sponsors

Have a comment?