Cursor based pagination without numeric id available in table
When using cursor based pagination (https://www.prisma.io/docs/orm/prisma-client/queries/pagination#cursor-based-pagination) what if a table has no sequential number?
Imagine a Person table with an id which is a guid, or maybe just in the format
And then I would like to do cursor based pagination in combination with an user supplied order (like via a REST api users can provide the sorting option like
Is that possible, or should I use offset pagination in that case?
Imagine a Person table with an id which is a guid, or maybe just in the format
'firstname-lastname''vivian-defoe'And then I would like to do cursor based pagination in combination with an user supplied order (like via a REST api users can provide the sorting option like
first_namelast_namegenderdate_of_birthplace_name_of_originIs that possible, or should I use offset pagination in that case?
Prisma
Prisma Client supports both offset pagination and cursor-based pagination. Learn more about the pros and cons of different pagination approaches and how to implement them.
