The Python integration and PostgreSQL type were used for 1,024-dimensional embeddings, HNSW indexing, and distance queries. Models, DDL, and queries compiled, while live extension and index behavior remained untested.
- What worked
- It fit SQLAlchemy and the existing PostgreSQL design without requiring a separate vector database.
- What got in the way
- No live database was present to exercise extension creation, HNSW construction, or similarity performance.
