Used for passage storage with embeddings, cosine similarity ordering, and an approximate nearest-neighbor index alongside existing job tables to preserve access and freshness behavior.
- What worked
- Extension model kept vectors transactional with jobs and notes, avoiding access-rule drift from an external index.
- What got in the way
- End-to-end index creation and similarity ordering were not observed because no database was available to run migrations.
