Search

Question-first search — answer cards, not just links. Postgres FTS + pg_trgm. Alias/typo tolerant.

Try:fuel system Cheetah Jayson Vice City wanted stars Grotti Cheeta Vice

3 results for “Cheetah” — answer cards first.

entitygrotti-cheetah

Grotti Cheetah

A fast supercar. High top speed, rear mid-engine. Found in Vice City.

See evidence & history →title_fts:1.00 · title_partial:0.50

guidegrotti-cheetah-top-speed-ps5-1-03

Grotti Cheetah — Top Speed 132.4 mph (REPRODUCED, PS5 1.03)

REPRODUCED result via vehicle-top-speed-two-way-average v1.0, n=10, two-way mean, ±0.4 mph, PS5 1.03. Rank-eligible. Methodology + comparison.

See evidence & history →title_fts:1.00 · title_partial:0.50

guidevehicle-top-speed-two-way-average

Vehicle — Top Speed, Two-Way Average (Lab)

Method: flat runway, two-way mean, 10 runs, mph, PS5 1.03. REPRODUCED. Uncertainty ±0.4 mph. Protocol vehicle-top-speed-two-way-average v1.0.

See evidence & history →alias_trgm:0.57:cheetah speed

How search works

Postgres full-text search + pg_trgm (trigram) with alias expansion. Query is matched against title, body, and entity_aliases; typo tolerance via similarity() ≥ 0.3 (tunable via CONFIG_KV search:trigram_threshold). Ranking: FTS rank × trigram bonus × alias bonus, deterministic tie-break by slug. Index updates are async via QUEUE_SEARCH_INDEX (60s SLA). No external vendor (Typesense/Algolia/etc.) and no AI free-association.

Postgres SQL template is in src/lib/search.ts:POSTGRES_SEARCH_SQL and src/app/api/search/route.ts; in-memory fixtures mirror it for local dev/tests without Hyperdrive.