Build and populate the MySQL text search index #69

New issue

Open

opened 2026-07-01 00:59:49 +00:00 by manlycucumber · 0 comments

manlycucumber commented

2026-07-01 00:59:49 +00:00

(Migrated from github.com)

Problem

MySQL is allowed to hold a search index. To make served text searchable, a build-time process must populate that index from Core's text, keyed so results map back to addressable responses.

Acceptance criteria

A build process populates the MySQL search index from Core text with stable references.
The index records the data-version it was built against.
Rebuilding the index is idempotent and reproducible.
Index population is covered by a test on a small corpus.

Notes

The index is the only request-time MySQL read on the hot text path; keep it lean.

## Problem MySQL is allowed to hold a search index. To make served text searchable, a build-time process must populate that index from Core's text, keyed so results map back to addressable responses. ## Acceptance criteria - [ ] A build process populates the MySQL search index from Core text with stable references. - [ ] The index records the data-version it was built against. - [ ] Rebuilding the index is idempotent and reproducible. - [ ] Index population is covered by a test on a small corpus. ## Notes The index is the only request-time MySQL read on the hot text path; keep it lean.

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

Directorium/Api#69

No description provided.

Rows
Columns