Backend & systems·API and interface design
you return an opaque token pointing at the last row, so page fifty costs the same as page one and nothing shifts under the client.
Cursor pagination
Also calledkeyset pagination, seek pagination
Paginating by an ordered key rather than a numeric offset. It is stable under concurrent inserts and deletes, and each page is an indexed seek rather than a scan. The cost is that you cannot jump to an arbitrary page number, which is almost always an acceptable trade for an API.