Consider to support pagination at react-hooks/trpc-route level

[ymc9]

Pagination can be done using Prisma client but it has one drawback: you can't get the total count in the same call with fetching a page.

https://github.com/prisma/prisma/issues/7550

ZenStack can probably makes some improvements here, say by adding a paginate API at the open-api level and corresponding client code generation for react-hooks and trpc-router.

const { paginate } = usePost();

const { data } = paginate({ where: {...}, take: ..., skip: ...});
const { count, items } = data;

[ymc9]

Also, today react-hooks plugin doesn't generate a count hooks, otherwise it can serve as a workaround for getting totals.

[ymc9]

Related discussion from discord:

[ymc9]

SWR and Tanstack-Query plugins now generate useInfiniteFindManyXXX hooks.