pgvector

pgvector adds vector similarity types and indexes to PostgreSQL — embeddings next to relational truth in one transactional store. Strategically aligned with ledger-in-Postgres architectures: cases, events, and embeddings until scale demands a dedicated vector service. Open-source vector similarity search for Postgres - exact and approximate nearest neighbor search - single-precision, half-precision, binary, and sparse vectors - L2 distance, inner product, cosine distance, L1 distance, Hamming distance, and Jaccard distance - any language with a Postgres client Plus ACID compliance, point-in-time recovery, JOINs, and all of the other great features of Postgres sh cd /tmp git clone --branch v0.8.6 https://github.com/pgvector/pgvector.git cd pgvector make make install may need sudo You can also install it with Docker, Homebrew, PGXN, APT, Yum, pkg, APK, or conda-forge,.