RUBY 476: SQL, Arel and the Dark Side of ActiveRecord with Eric Hayes

In this episode of Ruby Rogues, Eric Hayes joins us with the story of his journey into the dark, undocumented depths of Arel, ActiveRecord’s private API. We learn why writing custom SQL queries in 2020 can make sense and how to unlock the more powerful features of modern databases without resorting to SQL strings. Eric tells us how he manages the potential pitfalls of using Arel and achieves massive performance wins for difficult queries on large databases.Sponsors

• Audible.com
• CacheFly

Panel

• Dave Kimura
• John Epperson
• Luke Stutters
• Charles Max Wood

Guest

• Eric Hayes

Links

• https://devhints.io/arel nice little cheat sheet
• https://astexplorer.net/
• https://en.wikipedia.org/wiki/Visitor_pattern
• https://twitter.com/ehayes

PicksLuke Stutters:

• https://www.amazon.com/Micsig-DP10013-Differential-Attenuation-Tektronix/dp/B074K4XPW3

Chuck:

• http://podcastplaybook.co/
• mostvaluable.dev
• Amazon: Lightbringer Series
• Neewer 2 Packs Dimmable Bi-Color 480 LED with U Bracket Professional Video Light for Studio, YouTube Outdoor Video Photography Lighting Kit, Durable Metal Frame,3200-5600K, CRI 96

John Epperson:

• Buckeyeballs

Dave Kimura::

• https://www.elgato.com/en/gaming/stream-deck
• https://www.philips-hue.com/en-us

Eric Hayes:

• https://www.playgoodsudoku.com/
• https://www.ansiblefordevops.com/

Follow Ruby Rogues on Twitter > @rubyrogues Special Guest: Eric Hayes.

Advertising Inquiries: https://redcircle.com/brands

Privacy & Opt-Out: https://redcircle.com/privacy

Become a supporter of this podcast: https://www.spreaker.com/podcast/ruby-rogues--6102073/support.