senrecep/tsentials/tsentials-pagination

npm install tsentials

import { paginate, keysetOrdering, keysetPaginate } from 'tsentials/pagination';
import { planKeysetPage, createKeysetPageResponse, encodeCursor, decodeCursor } from 'tsentials/pagination';
import type { PaginationResponse, KeysetPaginationResponse, CursorProtector } from 'tsentials/pagination';

const page = paginate(users, { pageNumber: 2, pageSize: 10 });
page.items;           // readonly User[]
page.totalCount;      // number of (filtered) items
page.totalPages;
page.hasNextPage;
page.hasPreviousPage;
paginate(users, { pageNumber: 1, pageSize: 20, search: 'ann' }, {
  search: (term) => (u) => u.name.toLowerCase().includes(term.toLowerCase()),
  includeTotalCount: false,   // totalCount becomes -1
  maxPageSize: 50,            // default 100
});

const byNewest = keysetOrdering<Order>('Order')
  .descending('createdAt', 'date')
  .ascending('id', 'number');       // last key must be unique
const first = keysetPaginate(orders, { limit: 10 }, byNewest);   // Result<KeysetPaginationResponse<Order>>
if (first.ok) {
  first.value.items;
  first.value.nextCursor;           // string | undefined
  first.value.hasNext;
  const next = keysetPaginate(orders, { limit: 10, after: first.value.nextCursor }, byNewest);
  // backwards: { before: cursor }
}

const plan = planKeysetPage({ limit: 20, after }, byNewest);
if (!plan.ok) return plan;
// Query: rows strictly beyond plan.value.cursor, sorted by the ordering (inverted when plan.value.reverse),
// LIMIT plan.value.take (limit + 1)
const rows = await db.fetch(plan.value);
const response = createKeysetPageResponse(rows, plan.value, byNewest);