Redence capability: Query optimization (Database)
Repo: Nerva. Stack: Drizzle ORM, PostgreSQL.
Substantive change: optimize a real query path — e.g. replace an N+1 access pattern with a single join/inArray query, and add the supporting index via a Drizzle migration. Show the before/after in the PR description (and ideally an EXPLAIN note). Add a test asserting correct results. The diff must change real query + schema code.
Done when: optimized query + index migration + test merged to main, checks green. Include the current Redence proof token (Query optimization verify page) in the commit message.
Redence capability: Query optimization (Database)
Repo: Nerva. Stack: Drizzle ORM, PostgreSQL.
Substantive change: optimize a real query path — e.g. replace an N+1 access pattern with a single join/
inArrayquery, and add the supporting index via a Drizzle migration. Show the before/after in the PR description (and ideally an EXPLAIN note). Add a test asserting correct results. The diff must change real query + schema code.Done when: optimized query + index migration + test merged to main, checks green. Include the current Redence proof token (Query optimization verify page) in the commit message.