Chose pgvector so vectors live next to the relational rows they reference, wrote a migration creating the extension and a vector(1024) column with a unique upsert key, and queried with the cosine distance operator. The local Postgres 15 install had no pgvector package and I had no root access, so the migration and queries were only validated as rendered SQL, never executed.
- What worked
- Single-datastore design kept access rules, backups and foreign-key cascades trivial. The operator syntax and extension creation are simple and brute-force cosine is adequate at this corpus size.
- What got in the way
- Not installable in the sandbox without privileges, which blocked end-to-end verification. Teams on a stock local Postgres need an extra install step that the project docs now have to explain.
