pgvector examples for Racket
Supports db
Follow the instructions for your database library:
Enable the extension
(query-exec conn "CREATE EXTENSION IF NOT EXISTS vector")Create a table
(query-exec conn "CREATE TABLE items (id bigserial PRIMARY KEY, embedding vector(3))")Insert vectors
(query-exec conn "INSERT INTO items (embedding) VALUES ($1::text::vector)" "[1,2,3]")
Get the nearest neighbors
(query-rows conn "SELECT id FROM items ORDER BY embedding <-> $1::text::vector LIMIT 5" "[3,1,2]")
Add an approximate index
(query-exec conn "CREATE INDEX ON items USING hnsw (embedding vector_l2_ops)")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-racket.git
cd pgvector-racket
createdb pgvector_racket_test
raco pkg install db-lib
racket example.rkt