ActiveRecord can't do it? Arel can!
summary
Claim: Arel generates complex, database‑agnostic SQL that Active Record does not expose, and the talk demonstrates that by building real queries and showing they produce the same SQL. Examples use matches_any and does_not_match for predicates, combine subqueries with intersect and union, alias tables (locations2), build outer and self joins, use name functions and window functions, and plug Arel nodes back into Active Record joins. An app with 10 active users motivates performance and shows the approach works.
AI-written summary · about
chapters (9)
- 0:00Start
- 2:10Backpackers
- 2:25Finding lost bags
- 5:18Searching for Indian food!
- 6:54I need vegetarian Indian food!
- 7:51Locations with bookings && rating 3
- 11:44All hotels within 5 km of malls
- 15:02Other use of Named functions
- 17:28Windows
related talks
25mActiveRecord can't do it? Arel can!
35mAdvanced aRel: When ActiveRecord Just Isn't Enough
32mArel: The Ruby Relational Algebra Library
28mActive Record Scopes and Arel
17mWrangle Your SQL With Arel
01h 52mBuild High Performance Active Record Apps
01h 52mBuild High Performance Active Record Apps
42mActiveRecord is Still Magical