The New Orange mark: a radial orange gradient on a dark square.New Orange CMS

Documentation

Querying

GROQ against Postgres: how queries are executed, what the perspectives mean, how search works and how to keep a query fast.

  1. GROQ against Postgres

    How a query is executed here: parsed with groq-js, narrowed by a SQL planner, evaluated completely — so full semantics are available from the first day.

  2. Perspectives

    published, drafts (and its previewDrafts alias) and raw — what each admits, what _id it reports, and the overlay rules that are easy to get wrong.

  3. Full-text search

    Each document carries a generated tsvector of its extracted plain text, Portable Text included, and text::match pushes down to a Postgres tsquery.

  4. Keeping a query fast

    Which predicates the planner can push into SQL, which it cannot, and how to shape a query so the expensive half never runs.