Pagination Patterns: Offset, Cursor, and Keyset -- When Each One Works

Every API needs pagination. Most get it wrong. Here's how offset, cursor, and keyset pagination actually work, when to use each one, and the performance traps that turn page 500 into a production incident.