Postgres full-text search over counselling reports, ranked by relevance. Filter by school, grade, or report kind.
Aditya Krishnan:** Honestly, more pressure now. Dad keeps saying CA and Commerce is the safe path. Mom is more
Aditya Krishnan. Top RIASEC dimensions: Realistic (47), Investigative (34), Artistic (60). The pattern suggests strong fit for analytical
Aditya Krishnan. Top RIASEC dimensions: Realistic (47), Investigative (34), Artistic (60). The pattern suggests strong fit for analytical
Aditya Krishnan based on assessment battery + 3 counselling sessions. Top pathway: entrepreneurship (consistent across RIASEC, DAT V, and self
Aditya Krishnan based on assessment battery + 3 counselling sessions. Top pathway: research (consistent across RIASEC, DAT V, and self
Aditya Krishnan completed the mock CET aptitude battery. Performance: Maths 59/100, Logical Reasoning 60/100, English 85/100. Time management
Aditya Krishnan completed the mock CET aptitude battery. Performance: Maths 73/100, Logical Reasoning 68/100, English 78/100. Time management
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.