Postgres full-text search over counselling reports, ranked by relevance. Filter by school, grade, or report kind.
Kiara Kumar explore the recommended track for one quarter; revisit at term-end. Action: introduce Kiara Kumar to alumni
Kiara Kumar completed the mock CET aptitude battery. Performance: Maths 93/100, Logical Reasoning 68/100, English 64/100. Time management
Kiara Kumar completed the mock CET aptitude battery. Performance: Maths 89/100, Logical Reasoning 72/100, English 65/100. Time management
Kiara Kumar completed the mock CET aptitude battery. Performance: Maths 59/100, Logical Reasoning 79/100, English 64/100. Time management
Kiara Kumar was engaged today. We explored their interest in creative writing, discussing pathway options at the intersection
Kiara Kumar was engaged today. We explored their interest in creative writing, discussing pathway options at the intersection
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.