RailsCasts Pro episodes are now free!

Learn more or hide this

Applied Filters: search xActive Record x
Full-Text Search in PostgreSQL
Episode #343Apr 17, 2012131 comments

Full-Text Search in PostgreSQL

Postgres offers full-text searching right out of the box. This episode shows how to write queries from scratch, apply tools like Texticle and pg_search, and optimize performance through indexes. (16 minutes)
Thinking Sphinx (revised)
Episode #120Dec 09, 201144 comments

Thinking Sphinx (revised)

Sphinx is a full-text search engine for use with MySQL or PostgreSQL. Learn how to add Thinking Sphinx by defining an index on your model and searching with various options. (10 minutes)
Advanced Search Form
Episode #111May 26, 2008105 comments

Advanced Search Form

If you need to create an advanced search with a lot of fields, it may not be ideal to use a GET request as I showed in episode 37. In this episode I will show you how to handle this by creating a Search resource. (7 minutes)
Multitenancy with PostgreSQL
Episode #389Oct 27, 2012112 comments

Multitenancy with PostgreSQL

PostgreSQL Schemas can help create a multi-tenant app by keeping data separate at the database layer. Integrating with migrations can be tricky though, so watch this episode for the full details. (11 minutes)
MetaWhere & MetaSearch
Episode #251Jan 31, 201165 comments

MetaWhere & MetaSearch

MetaWhere provides a way to do complex find conditions without SQL in Active Record. MetaSearch makes it easy to create search forms with many find options. (8 minutes)
Migrating to PostgreSQL
Episode #342Apr 17, 2012137 comments

Migrating to PostgreSQL

Postgres is a feature-packed relational database that every Rails developer should consider using. Here you will learn how to install it, add it to a new application, and transition from an existing SQLite app using the "taps" gem. (8 minutes)
Hacking with Arel
Episode #355May 30, 201270 comments

Hacking with Arel

Here I show a variety of ways to rewrite a long SQL query using only Active Record and Arel. This includes generating scopes dynamically, adding an "or" operator, and adding a powerful "match" method. (15 minutes)
Searchlogic
Episode #176Aug 24, 200996 comments

Searchlogic

Searchlogic makes searching models easier than ever with its assortment of named scopes. In this episode I show you how to create simple and advanced searches. (13 minutes)
Thinking Sphinx
Episode #120Jul 28, 2008114 comments

Thinking Sphinx

If you need a full text search engine, Thinking Sphinx is a great solution. See why in this episode. (12 minutes)
Anonymous Scopes
Episode #112Jun 02, 200870 comments

Anonymous Scopes

The scoped method allows you to generate named scopes on the fly. In this episode I show how to use anonymous scopes to improve the conditional logic which was used in the previous episode on advanced search form. (8 minutes)