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