Sign in through GitHub

RailsCasts Pro episodes are now free!

Learn more or hide this

Applied Filters: search xPro Episodes x
Full-Text Search in PostgreSQL
Episode #343Apr 17, 2012119 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)
Autocomplete Search Terms
Episode #399Dec 31, 201279 comments

Autocomplete Search Terms

Learn how to add autocompletion to a search form and improve performance using Rack middleware, caching and switching from SQL to Redis. (17 minutes)
ElasticSearch Part 2
Episode #307Dec 12, 201157 comments

ElasticSearch Part 2

This final part on ElasticSearch and Tire will show how to make more complex search queries, customize the indexing, and add facets. (16 minutes)
Multitenancy with PostgreSQL
Episode #389Oct 27, 2012102 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)
Hacking with Arel
Episode #355May 30, 201261 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)
Testing with VCR
Episode #291Oct 17, 201149 comments

Testing with VCR

If you ever need to test an application which communicates with an external API, VCR is the way to go. Here I show a workflow in RSpec, how to use with capybara-mechanize, how to add sanitization filtering, and more. (13 minutes)