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

from Ruby Rogues · host Charles M Wood

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.SponsorsAudible.comCacheFlyPanelDave KimuraJohn EppersonLuke StuttersCharles Max WoodGuestEric HayesLinkshttps://devhints.io/arel nice little cheat sheethttps://astexplorer.net/https://en.wikipedia.org/wiki/Visitor_patternhttps://twitter.com/ehayesPicksLuke Stutters:https://www.amazon.com/Micsig-DP10013-Differential-Attenuation-Tektronix/dp/B074K4XPW3Chuck:http://podcastplaybook.co/mostvaluable.devAmazon: Lightbringer SeriesNeewer 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 96John Epperson:BuckeyeballsDave Kimura::https://www.elgato.com/en/gaming/stream-deckhttps://www.philips-hue.com/en-usEric Hayes:https://www.playgoodsudoku.com/https://www.ansiblefordevops.com/Follow Ruby Rogues on Twitter > @rubyrogues Special Guest: Eric Hayes. Advertising Inquiries: https://redcircle.com/brandsPrivacy & Opt-Out: https://redcircle.com/privacyBecome a supporter of this podcast: https://www.spreaker.com/podcast/ruby-rogues--6102073/support.

Episode metadata supplied by the publisher feed · Published Nov 3, 2020

Embed this episode

Attribution link and audio player

NOW PLAYING

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

0:00 34:00

1×

No transcript for this episode yet

We transcribe on demand. Request one and we'll notify you when it's ready — usually under 10 minutes.

Share this episode

Similar Episodes

No similar episodes found.

Similar Podcasts

Friday Afternoon Deploy: A Developer Podcast Lofty Labs Episodes and show notes available at friday.hirelofty.com. An unapologetic show about the culture and chaos of software engineering from the makers and breakers of digital products at Lofty Labs. We build software with Python and Django, Ruby and Rails, Golang, whatever frontend framework we're forced to use because it's popular this month, and anything else to get the job done right. Then on Friday afternoons we have a beer and talk about our regrets on this show. Explicit I Love My Baby, And... Erin Schlozman and Ruby Falk Motherhood is awesome. But not always. Holding space for the best parts of motherhood seems impossible when the challenging parts feel really heavy – and vice versa! Erin, licensed therapist, and Ruby, licensed therapist candidate, hold nothing back when talking about the dual realities associated with this chaotic, wonderful, hard, hilarious, sad, and undeniably happy part of life. This podcast is a place for community. Submit your thoughts, feelings, or wonderings to our voicemail box or email, and let’s talk about it! We can't wait to hear from you. Explicit

Frequently Asked Questions

How long is this episode of Ruby Rogues?

This episode is 34 minutes long.

When was this Ruby Rogues episode published?

This episode was published on November 3, 2020.

Can I download this Ruby Rogues episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.

URL copied to clipboard!