← All rules

Relational DatabasesDatabase correctness

relational-databases/require-deterministic-pagination-order

LIMIT/OFFSET and skip/take pagination need a deterministic ordering contract so records do not drift unpredictably between pages.

paginationorderingqueries

01 Examples

TypeScript

db.user.findMany({ skip: page * 20, take: 20 });

Finding

Require visible ordering for pagination.

02 Enable it

Setup

Install the package, register its plugin factory, then enable the rule.

Install the package

pnpm add -D @scruple/relational-databases

Register the plugin

In scruple.config.ts, register the factory under the relational-databases namespace used by the rule ID.

import { relationalDatabases } from "@scruple/relational-databases";

plugins: {
  "relational-databases": relationalDatabases(),
},

Enable the rule

"relational-databases/require-deterministic-pagination-order": "warn"

Package

@scruple/relational-databases

Default threshold

Plugin default

Minimum confidence

Plugin default