Queries

Read and write typed data with the generated client: filters, sorting, pagination and mutations.

Reading rows

TypeScript

const recent = await db.tasks  .where({ done: false })  .orderBy("createdAt", "desc")  .limit(20)  .all()

Pass an object for equality, or use operators like gt, in and like for everything else.

TypeScript

import { gt, like } from "tessera" await db.projects.where({ seats: gt(10), name: like("Acme%") }).all()

Use cursor pagination for lists that grow. page() returns the rows and a nextCursor you pass to the next call.

TypeScript

const { rows, nextCursor } = await db.tasks.page({ size: 50 })const next = await db.tasks.page({ size: 50, after: nextCursor })

const task = await db.tasks.insert({ title: "Ship docs", projectId })

Rules run on every query

Queries from the browser are checked against your row-level rules, so the same code is safe on the client and the server.

Permissions

Relations

Was this helpful?

Support

Status