RailsConf 2016 - Multi-table Full Text Search with Postgres By Caleb Thompson

3,973 views · Published 24 May 2016 · 27:19 · Indexed 16 November 2026

Channel: Confreaks · 2016 · Science & Technology

Watch on YouTube

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.

More from this channel