Postgres full-text search over counselling reports, ranked by relevance. Filter by school, grade, or report kind.
Ayaan Patel explore the recommended track for one quarter; revisit at term-end. Action: introduce Ayaan Patel to alumni
Ayaan Patel (Grade 12). Discussion focused on design as a pathway and the family's view on balancing
Ayaan Patel completed the mock CET aptitude battery. Performance: Maths 74/100, Logical Reasoning 59/100, English 86/100. Time management
Ayaan Patel was engaged today. We explored their interest in design, discussing pathway options at the intersection of curiosity
Every reports.text and counsellor_note is indexed by Postgres tsvector (english config). One GIN index, refreshed on insert.
Search box runs plainto_tsquery + ts_rank_cd. Filter chips (school, grade, RIASEC, kind) compose into the same SQL — no client-side filtering.
ts_headline wraps matches in <mark> tags so counsellors see the evidence in context.
Top 30 sorted by rank × recency. The aim is < 200 ms server-side on the full corpus, no Elasticsearch needed.