# Pagination Two patterns — cursor (recommended) and offset. ## Cursor Pagination (recommended for large datasets) ### Helper — `packages/database/src/pagination.ts` ```ts export type CursorPage = { data: T[]; nextCursor: string | null; hasMore: boolean; }; export type CursorParams = { cursor?: string; limit?: number; }; export async function cursorPaginate( query: (args: { take: number; skip: number; cursor?: { id: string } }) => Promise, { cursor, limit = 20 }: CursorParams ): Promise> { const take = limit + 1; const results = await query({ take, skip: cursor ? 1 : 0, ...(cursor ? { cursor: { id: cursor } } : {}), }); const hasMore = results.length > limit; const data = hasMore ? results.slice(0, -1) : results; const nextCursor = hasMore ? data[data.length - 1].id : null; return { data, nextCursor, hasMore }; } ``` ### Repository usage ```ts import { cursorPaginate, CursorParams } from '@repo/database'; findAll = (params: CursorParams) => cursorPaginate( (args) => prisma.project.findMany({ ...args, orderBy: { createdAt: 'desc' } }), params ); ``` ### Controller usage ```ts getAll{R}s = async (req, res, next) => { try { const { cursor, limit } = req.query; const result = await svc.findAll{R}s({ cursor: cursor as string, limit: limit ? Number(limit) : 20, }); ok(res, result); } catch (e) { next(e); } }; ``` ### Response shape ```json { "success": true, "data": { "data": [...], "nextCursor": "clx123abc", "hasMore": true } } ``` --- ## Offset Pagination (simple, use for small datasets) ### Helper — `packages/database/src/pagination.ts` (add alongside cursor) ```ts export type OffsetPage = { data: T[]; total: number; page: number; pageSize: number; totalPages: number; }; export type OffsetParams = { page?: number; pageSize?: number; }; export async function offsetPaginate( countQuery: () => Promise, dataQuery: (skip: number, take: number) => Promise, { page = 1, pageSize = 20 }: OffsetParams ): Promise> { const skip = (page - 1) * pageSize; const [total, data] = await Promise.all([countQuery(), dataQuery(skip, pageSize)]); return { data, total, page, pageSize, totalPages: Math.ceil(total / pageSize) }; } ``` ### Repository usage ```ts findAllPaged = (params: OffsetParams) => offsetPaginate( () => prisma.project.count(), (skip, take) => prisma.project.findMany({ skip, take, orderBy: { createdAt: 'desc' } }), params ); ``` ## Export from `packages/database/src/index.ts` ```ts export { prisma } from './client'; export { cursorPaginate, offsetPaginate } from './pagination'; export type { CursorPage, CursorParams, OffsetPage, OffsetParams } from './pagination'; export * from '@prisma/client'; ```

prisma-database

Install this skill

Comments