Multi-table Full Text Search with Postgres

Searching content across multiple database tables and columns doesn't have to suck. Thanks to Postgres, rolling your own search isn't difficult. Following an actual feature evolution I worked on for a client, we will start with a search feature that queries a single column with LIKE and build up to a SQL-heavy solution for finding results across multiple columns and tables using database views. We will look at optimizing the query time and why this could be a better solution over introducing extra dependencies which clutter your code and need to be stubbed in tests.
Length: 27:19
Views 891 Likes: 11
Recorded on 2016-05-04 at Rails Conf
Look for other videos at Rails Conf.
Tweet this video