Recipes

The recipes solve one specific problem at a time — complete, copy-paste code, with the theory of why right next to it. They are the practical complement to the Tutorial: the tutorial teaches you the concepts in order; the recipes show you how to apply them in real day-to-day situations.

How to read this

Each recipe is independent — jump straight to what you need. They all assume you have already been through the Tutorial (models, queries, execution).

Available

Recipe	Solves
created_at / updated_at	Database-managed timestamps, without remembering to set them by hand.
Typed pagination	Paginated lists with total/pages, aligned with tempest-fastapi-sdk.
Aggregations & DISTINCT	count/sum/avg/min/max + typed GROUP BY and DISTINCT.
Upsert (ON CONFLICT)	Insert resolving a key conflict: DO NOTHING or DO UPDATE.
Active-record (opt-in)	save/update/delete/reload methods on a row, when you prefer it.
Logging & errors	See the SQL that runs (onQuery) and errors carrying the failing SQL/params.
Transactions and savepoints	Atomic operations with automatic commit/rollback and savepoints.
JSON and enum columns	Store typed objects and literal unions with type safety.
Serialization (row ↔ JSON)	Convert rows to JSON and validate JSON back into a row.
Connecting to PostgreSQL	Swap SQLite for Postgres via the URL and tune the pool.

Looking for something bigger?

If you want to see it all put together in a project that runs, go to Examples: a Todo CLI, a blog with relations, a REST API, and the complete migrations workflow.