Cursor pagination on table using UUID as primary key
Hello everybody! We've switched from Prisma and are trying to implement cursor pagination. It turns out our tables are using UUID instead of integers as primary keys. I couldn't find anything on Drizzle's documentation about it. Even Google search didn't return a result. Could someone here provide guidance? Thank you very much!
2 Replies
Not sure if it's possible to make cursor pagination with just a single uuid field. It may be achieved using some sort of date together with uuid, but not only uuid
Was it possible with Prisma?
because I think it's not possible in sql itself
Thanks @Andrew Sherman ! We decided to go with
created_at !