Ordering & Pagination

Correctly handling ORDER BY, LIMIT, OFFSET, and pagination in ActiveRecord, including cases where Rails generates unexpected SQL.

Why ActiveRecord Exists: The SQL Mental Model That Breaks in Rails

ActiveRecord isn't SQL with Ruby syntax — it's a different mental model. Here's why the shift trips up SQL-fluent developers and how to make it click.

December 21, 2025 5 min read