pgvector examples for Erlang
Supports epgsql
Follow the instructions for your database library:
Enable the extension
epgsql:equery(C, "CREATE EXTENSION IF NOT EXISTS vector"),Create a table
epgsql:equery(C, "CREATE TABLE items (id bigserial PRIMARY KEY, embedding vector(3))"),Insert vectors
epgsql:equery(C, "INSERT INTO items (embedding) VALUES ($1), ($2)", ["[1,2,3]", "[4,5,6]"]),Get the nearest neighbors
epgsql:equery(C, "SELECT id FROM items ORDER BY embedding <-> $1 LIMIT 5", ["[3,1,2]"]),Add an approximate index
epgsql:equery(C, "CREATE INDEX ON items USING hnsw (embedding vector_l2_ops)"),
% or
epgsql:equery(C, "CREATE INDEX ON items USING ivfflat (embedding vector_l2_ops) WITH (lists = 100)"),Use vector_ip_ops for inner product and vector_cosine_ops for cosine distance
See a full example
Everyone is encouraged to help improve this project. Here are a few ways you can help:
- Report bugs
- Fix bugs and submit pull requests
- Write, clarify, or fix documentation
- Suggest or add new features
To get started with development:
git clone https://github.com/pgvector/pgvector-erlang.git
cd pgvector-erlang
createdb pgvector_erlang_test
rebar3 escriptize
_build/default/bin/example