# Guides

Build on your first example: query data, connect an application, and run it in production.

Choose a task for your project. Each guide explains the relevant concepts and
shows how to use them. For a first example, start with
[Onboarding](https://rindle.sh/docs/overview) and [Getting started](https://rindle.sh/docs/getting-started).
For an API, supported query shape, or configuration option, use
[Reference](https://rindle.sh/docs/api).

## Understand the engine and sync

- [How it works](https://rindle.sh/docs/how-it-works): follow a query from its definition to a maintained result.
- [Architecture](https://rindle.sh/docs/architecture): understand the browser, API authority, and data tier in a synced app.
- [Embedded replica runtime](https://rindle.sh/docs/replica-and-views): keep SQLite and live queries inside your Rust process.
- [Browser client choices](https://rindle.sh/docs/browser-clients): choose local rows, remote results, normalized sync, or optimistic writes.

## Define data and live queries

- [Schema and migrations](https://rindle.sh/docs/schema): define database tables and generate a typed schema.
- [Queries and fragments](https://rindle.sh/docs/fragments): name shared queries and connect results to components.
- [Live aggregates](https://rindle.sh/docs/live-aggregates): maintain counts, sums, and grouped results.
- [Pagination](https://rindle.sh/docs/pagination): load more rows with stable ordering.
- [Pinned queries](https://rindle.sh/docs/pinned-queries): keep server results available between requests.
- [Refine schema types](https://rindle.sh/docs/refining-schema-types): give database values application-specific types.
- [Rust delta consumer](https://rindle.sh/docs/example-rust): apply individual changes to your own result structure.

## Add writes and authorization

- [Mutators](https://rindle.sh/docs/mutators): share write logic between the browser and server.
- [Authorization](https://rindle.sh/docs/authorization): scope queries and writes to the authenticated user.
- [Rejected writes](https://rindle.sh/docs/rejected-writes): show failures after the server rejects a prediction.
- [Folded mutations](https://rindle.sh/docs/folded-mutations): combine frequent optimistic writes.
- [Undo and redo](https://rindle.sh/docs/undo-redo): reverse application actions.
- [Background writes](https://rindle.sh/docs/background-writes): change authoritative data from a server or job.

## Connect the user interface

- [TanStack Start](https://rindle.sh/docs/tanstack): connect the router, providers, and live queries.
- [Preloads](https://rindle.sh/docs/preloads) and [SSR](https://rindle.sh/docs/ssr): prepare data before navigation and render it on the server.
- [Local-only tables](https://rindle.sh/docs/local-only-tables): keep drafts and selections on the device.
- [Local persistence](https://rindle.sh/docs/persisting-local-tables): restore device data after a reload.
- [Fine-grained reactivity](https://rindle.sh/docs/fine-grained-reactivity): subscribe to the values a component needs.
- [Typeahead](https://rindle.sh/docs/typeahead): update query arguments as the user types.
- [LLM streams](https://rindle.sh/docs/llm-streams) and [agents](https://rindle.sh/docs/agents): stream generated content into live views.

## Connect data sources and deploy

- [PostgreSQL source](https://rindle.sh/docs/postgres-source): keep Postgres authoritative through the preview integration.
- [Deployment](https://rindle.sh/docs/deploy): choose a topology and understand its recovery requirements.
- [Cloud quickstart](https://rindle.sh/docs/cloud-quickstart): create a hosted deployment.
- [Cloud connections](https://rindle.sh/docs/cloud-connect): connect applications and tools to a deployment.
- [Cloud operations](https://rindle.sh/docs/cloud-scaling): inspect deployment state and switch managed plans.

For ordinary SQL requests, start with the [SQL client reference](https://rindle.sh/docs/sql-client).
SQL-only use does not require browser sync or optimistic mutators.

## Test and diagnose

- [Testing](https://rindle.sh/docs/testing): exercise queries, mutations, and synchronization.
- [Devtools](https://rindle.sh/docs/devtools): inspect subscriptions and optimistic state.
- [Troubleshooting](https://rindle.sh/docs/troubleshooting): identify setup, query, and sync errors.

The sidebar groups guides by topic. The optional integration filter narrows
the list to Engine & SQL or Synced apps.

---

[View this page on Rindle](https://rindle.sh/docs/guides)