Recommended as managed Postgres with vector extension to keep documents, ACL metadata and embeddings in one transactional store. Wrote dual-backend code targeting it via connection string, with local fallback. No live instance was available so integration was not exercised against the real service.
- What worked
- Design rationale was clear: single store avoids dual-write drift, supports filtered top-k and transactional deletes and permission updates.
- What got in the way
- Could not verify connectivity, extension setup, indexing or performance against a real instance in this task.
