A curated library of common SQL patterns and their correct ActiveRecord equivalents, serving as a reference for real-world Rails queries.
Over-eager loading with includes() can make Rails apps slower. Learn when 100 simple queries beat 1 massive join. Real benchmarks from production apps.
Books teach concepts. You need examples. See SQL vs ActiveRecord side-by-side, when to use scopes/Arel/SQL, and how to ship maintainable queries fast.
How to teach ActiveRecord to SQL developers: relations over strings, scopes, preloading vs joins, and when to use Arel/SQL—with concrete metrics and code.
From raw SQL to Rails ActiveRecord: when to use scopes, Arel, or SQL; how to kill N+1s; and why maintenance wins. Real numbers, trade-offs, and code.
Same SQL can map to multiple ActiveRecord queries. Learn five correct patterns, when each wins, and how to choose using data shape, EXPLAIN, and APM profiling.
Rails tutorial on the real difference between ActiveRecord includes, joins, preload, and eager_load—with numbers, trade-offs, and guardrails to avoid N+1 traps.
Learn EXPLAIN/ANALYZE for Rails ActiveRecord. Fix includes vs joins, DISTINCT, and missing indexes with real numbers, Arel patterns, and safe workflows.
Learn SQL to ActiveRecord conversion patterns, when to use joins vs includes, aggregations, Arel, and Pagy. Real numbers, trade-offs, and a production bug—Rails 7+, Ruby 3+.
If you know SQL, ActiveRecord can feel pointless—until it saves you from consistency bugs. Here’s the mental model: where SQL alone breaks app invariants, and how to use AR without losing performance.