Practical guides for converting raw SQL queries into correct, performant ActiveRecord code, including edge cases where Rails behaves differently than SQL.
I taught SQL for 5 years. Teaching ActiveRecord broke every analogy I had. Here's what I had to unlearn — and the new model that actually works for beginners.
As a DBA, Rails felt wrong. SQL was cleaner. Then I hit maintenance hell on a raw-SQL codebase and changed my mind. Here's what shifted.
I searched for SQL to ActiveRecord conversion so many times I finally built the tool myself. Here's what I learned about the patterns that repeat constantly.
Every SQL to ActiveRecord converter gave me different output for the same query. Here's why — and what that tells you about how ActiveRecord actually works.
SQL JOINs made sense. ActiveRecord's includes() confused me for weeks. Here's the mental model that finally made it click and when to use each.
My SQL query was perfectly optimized. Porting it to ActiveRecord triggered N+1 queries in production. Here's the exact pattern that caused it and the fix.
find_by returns nil when no match. find raises RecordNotFound. Here's when each is the right choice, nil handling patterns, and production-safe usage. 2026.
My ActiveRecord query looked clean. The SQL was a full table scan. Here's what I missed and why I check EXPLAIN ANALYZE on every non-trivial query now.
SQL fluency creates specific blind spots when learning ActiveRecord. Here's where the mental model breaks, and how to reframe it so the ORM finally makes sense.
When to use select vs pluck in ActiveRecord — memory use, return types, N+1 traps, and the SQL Rails generates for each. With Rails 7/8 examples.
The complete ActiveRecord query interface for Rails 7 and 8: where, joins, includes, select, group, order, limit, offset, and the SQL each generates.
WHERE with hash, string, and .or() syntax — all in one guide. Multiple conditions, AND/OR logic, WHERE vs HAVING, and inspecting SQL output. Rails 7/8, 2026.
Rails 8.2 changes callback ordering for background jobs. Here's what breaks, why it matters, and how to audit your Sidekiq jobs before upgrading.
Step-by-step Rails 8.2 upgrade guide for production apps. Covers the breaking changes, zero-downtime migration patterns, and what to test before you deploy.
Rails 8.2 is thread-safe by default, but your app can still be slow under concurrency. Here's what's actually blocking threads and how to fix it.
Rails 8.2 ActiveRecord changes that break existing apps at scale: deprecated methods, new query behavior, and migration patterns to update safely.
Rails has no native FULL OUTER JOIN. Here are three working approaches: Arel, find_by_sql, and union of LEFT + RIGHT joins. With SQL output for each.
Seven ways to do a CROSS JOIN in Rails without blowing up in production. Covers Arel, raw SQL, CTEs, and the row-count pitfalls to know before you deploy.
Adding WHERE after LEFT JOIN in Rails silently converts it to INNER JOIN. Here's why it happens, how to spot it, and the fix with .merge() or subqueries.
Rails doesn't expose CROSS JOIN directly. Here's how to write one with Arel or find_by_sql, when it's the right tool, and when to avoid it in production.