What are the three main pagination patterns?
spaceto flip
Offset (LIMIT/OFFSET, page numbers, simple but slow on deep pages). Cursor-based (opaque pointer to a position, stable across mutations). Keyset (WHERE clause with sort key values, best performance, uses index seeking). Offset for small admin UIs. Cursor for APIs and feeds. Keyset for high-volume ordered data.