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

Channel:
United States Confreaks
Subscribers:
42,400
Published on ● Video Link: https://www.youtube.com/watch?v=OzHhJPlgZaw


Duration: 27:19
3,335 views
26

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.



Other Videos By Confreaks


2016-05-25RailsConf 2016 - From Zero to API Hero: Consuming APIs like a Pro by Cecy Correa
2016-05-25RailsConf 2016 - Level-up Your ActiveRecord Skills: Learn SQL! by Ryan Dlugosz
2016-05-25RailsConf 2016 - From Excel to Rails: A Path to Enlightened Internal Software by Nick Reavill
2016-05-25RailsConf 2016 - I Can’t Believe It’s Not A Queue: Using Kafka with Rails by Terence Lee
2016-05-24RailsConf 2016 - How to Get and Love Your First Rails Job By Molly Black
2016-05-24RailsConf 2016 - Client/Server Architecture: Past, Present, & Future By Mike Groseclose
2016-05-24RailsConf 2016 - The State of Web Security by Mike Milner
2016-05-24RailsConf 2016 - Inside ActiveJob By Jerry D'Antonio
2016-05-24RailsConf 2016 - Saving Sprockets by Richard Schneeman
2016-05-24RailsConf 2016 - Rediscovering ActiveRecord By Mario Chavez
2016-05-24RailsConf 2016 - Multi-table Full Text Search with Postgres By Caleb Thompson
2016-05-24RailsConf 2016 - Precompiling Ruby scripts - Myth and Fact By Koichi Sasada
2016-05-24RailsConf 2016 - Quit Frustrating Your New Developers - Tips From a Teacher By Miki Rezentes
2016-05-24RailsConf 2016 - Don't Forget the Network: Your App is Slower Than You Think By Andre Arko
2016-05-24RailsConf 2016 - Build Realtime Apps with Ruby & Pakyow By Bryan Powell
2016-05-24RailsConf 2016 - Going Serverless By Jeremy Green
2016-05-24RailsConf 2016 - Developing and Maintaining a Platform With Rails and Lotus By Simone Carletti
2016-05-24RailsConf 2016 - How We Scaled GitLab For a 30k-employee Company By Minqi Pan
2016-05-24RailsConf 2016 - Rails to Phoenix by Brian Cardarella
2016-05-24RailsConf 2016 - Surviving the Framework Hype Cycle by Brandon Hayes
2016-05-23RailsConf 2016 -Stuck in the Middle: Leverage the power of Rack Middleware by Amy Unger


Tags:
rails
ruby
ralsconf
ruby on rails