Offset vs Keyset Pagination for Soft‑Deleted Records in NestJS: Which Keeps Page Size Consistent?
When building a NestJS API that serves large datasets, developers must decide how to paginate queries while respecting soft‑deleted records. Offset‑based pagination (limit/offset) is easy to add with QueryPipe and TypeORM’s findAndCount, but if the total count includes soft‑deleted rows, the number of active entities returned on a page can fall below the req
nestjs