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


Picks

Luke 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.