API Design & Idempotency

Cursor pages

An activity feed has 50M events. Clients page through history. Why is `OFFSET 200000 LIMIT 50` problematic? Design cursor-based pagination including stable sort columns and handling new items arriving while the user pages.

Intermediate drill question.

Write it as you would say it in the interview: assumptions, the design, tradeoffs, and what you would do next. The draft saves in this browser.

Review the lesson