Practical guides for converting raw SQL queries into correct, performant ActiveRecord code, including edge cases where Rails behaves differently than SQL.
Master Rails WHERE clause with multiple conditions, OR logic, and SQL strings. Learn WHERE vs HAVING and how to verify generated SQL with real examples.
Rails 8.2 and Ruby 4.0 expose hidden callback costs. Learn why callbacks fail in production and what to use instead.
A production-tested playbook for upgrading to Rails 8.2 with Ruby 4.0. Avoid downtime, lockups, and silent performance regressions.
Rails 8.2 is thread-safe but still slow under load. Learn how Ruby 4.0 exposes connection pool starvation and how to fix concurrency correctly.
Rails 8.2 changes Active Record behavior in ways that hurt performance at scale. Learn what breaks, how Ruby 4.0 exposes it, and how to fix it safely.
Need a FULL OUTER JOIN in Rails? Learn why ActiveRecord doesn’t support it natively and the safest Postgres + UNION workarounds for production.
Master Rails CROSS JOIN with 7 production-safe methods. Learn cartesian products, when to use CROSS JOIN, and how to avoid performance traps in Rails.
Fix Rails LEFT JOIN + WHERE trap that becomes INNER JOIN. Covers .left_joins, scoped associations, WHERE vs ON, and SQL verification with examples.
How to do a SQL CROSS JOIN from ActiveRecord safely: when it’s the right tool, how to express it without losing bind params, and how to avoid accidental Cartesian products.
,%20shot%20on%20Canon%20EOS%20R5,%20shallow%20depth%20of%20field%20f_2..jpg)
Write Rails INNER JOIN queries with multiple conditions using .joins, .where, and .merge. Learn ON vs WHERE placement and verify generated SQL correctly.
Copied SQL into Rails and still got N+1? Rewrote in ActiveRecord and still got N+1? The fix is a set-based mental model: where N+1 really comes from, how to verify it, and the AR patterns that eliminate it safely.
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.