Dev Tools · 1h ago
Building a cross-user review graph with pgvector on Amazon Aurora
A developer built Opinlog, a universal review app that uses pgvector on Amazon Aurora PostgreSQL to deduplicate user-submitted items via 1024-dim embeddings. The system matches differently spelled entries (e.g., "In-N-Out Double-Double" vs "in n out double double burger") using HNSW-based cosine similarity search. The project is open-source and deployed on Vercel.
Meridian48 take
The approach is clever but faces scalability challenges as the canonical catalog grows; real-world deduplication at scale would likely require more sophisticated entity resolution.
Read the full reporting
Building a cross-user review graph with pgvector on Amazon Aurora →
DEV Community
pgvectorvector-search