Prisma doesn't return meta information like
no_of_pages when returning paginated results. With information like
total_page we can know beforehand if we are at the end of the page and show/hide relevant information. In prisma, this doesn't seem to be possible at the moment without adding a second query to fetch the count of results.
Fetch More button at the bottom of a list. We need to enable this button only if we have more records to show. If not, we should hide this button.
This demo implementation doesn't use a second query. While fetching each page it retrieves one more record than the required page size. With this approach, the maximum number of records fetched twice is equal to the number of page requests. A more detailed explanation is attached below.