Vlado Cingel recounts his story where he needed common table expressions within SQL for a project he was working on and wrote a patch to AREL and ActiveRecord which he submitted to the Rails Core. Since it hasn't been accepted, he's supporting it as a gem.


Vlado explains what Common Table Expressions (CTEs) are, how they work, and where they're used.


Panel


John EppersonLuke StuttersValentino Stoll


Guest


Vlado Cingel


Sponsors


Top End DevsRaygun | Click here to get started on your free 14-day trialCoaching | Top End Devs


Links


GitHub | vlado/activerecord-cteOrganising complex SQL queries in RailsGitHub: Vlado Cingel ( vlado )


Picks


John- Digital Storm: Custom Gaming Computers & Gaming PCsLuke- Pitch PerfectValentino- Ruby TogetherValentino- Ruby CentralValentino- The Ruby VM a speedrun - Penelope PhippenVlado- The Wood Whisperer Guild - Online Woodworking SchoolVlado- Polished Ruby Programming


Contact John:


Rock Agile ConsultingGitHub: John Epperson ( kirillian )LinkedIn: John Epperson


Contact Luke:


GitHub: Luke Stutters ( lukestuts )


Contact Valentino:


Doximity Technology BlogWork @ DoximityGitHub: Valentino Stoll ( codenamev )Twitter: V ( @thecodenamev )
Special Guest: Vlado Cingel.