Implement cursor based pagination

Question

Implement cursor based pagination

bakura10 opened this issue 11 years ago · 3 comments

While working on Stripe API a lot, they have implemented a type of pagination I was unaware of: cursor based pagination. The idea is that normal pagination (using limit, offset...) is unreliable because if new records are insreted while you paginate, you may miss records.

Cursor based assume that you pass the last id of the records, so that pagiantion continue just after this record.

I'm not sure if that can be implemented easily in ZfrRest but that would be a nice addition :p.

Answer 1 · 2014-05-09T17:16:31.000Z

You mean something like start=invoice1234?

Answer 2 · 2014-05-09T17:24:35.000Z

Exactly. Stripe uses "starting_after" and "ending_before"

Answer 3 · 2014-05-09T17:25:55.000Z

I think the idea would be to automatically create a criteria that would sort by the id, and having a gt / lt filter.