pgvector examples for Racket

Supports db

Follow the instructions for your database library:

• db

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