Evaluated Postgres text search against a dedicated index for ten million records with daytime writes, chose the managed search service, then implemented schemas, query building, write-path sync, search endpoint, reindex script, and UI without adding a client dependency.
- What worked
- API concepts were clear: collections with facet and sort fields, typo tolerance and prefix settings, scoped search keys, and bulk import mapped cleanly to the planned data model. Stubbed HTTP helpers stayed unit testable.
- What got in the way
- No live cluster was available, so relevance, latency, and indexing throughput were never observed; the integration runs in degraded mode until hosting and keys are provisioned and a backfill completes.
