Sign in through GitHub

RailsCasts Pro episodes are now free!

Learn more or hide this

Applied Filters: search xPro Episodes xActive Record x
Full-Text Search in PostgreSQL
Episode #343Apr 17, 2012107 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)
Multitenancy with PostgreSQL
Episode #389Oct 27, 201278 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, 201243 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)