- Notifications
You must be signed in to change notification settings - Fork0
pgvector/pgvector-d
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
pgvector examples for D
Supportsdpq2
Follow the instructions for your database library:
Or check out some examples:
- Embeddings with OpenAI
- Binary embeddings with Cohere
- Hybrid search with Ollama (Reciprocal Rank Fusion)
- Sparse search with Text Embeddings Inference
Enable the extension
conn.exec("CREATE EXTENSION IF NOT EXISTS vector");Create a table
conn.exec("CREATE TABLE items (id bigserial PRIMARY KEY, embedding vector(3))");Insert vectors
QueryParams p;p.sqlCommand ="INSERT INTO items (embedding) VALUES ($1::vector), ($2::vector)";p.argsVariadic([1,2,3], [4,5,6]);conn.execParams(p);
Get the nearest neighbors
QueryParams p;p.sqlCommand ="SELECT * FROM items ORDER BY embedding <-> $1::vector LIMIT 5";p.argsVariadic([3,1,2]);p.resultFormat = ValueFormat.TEXT;auto result = conn.execParams(p);foreach (row; rangify(result)){ writeln(row);}
Add an approximate index
conn.exec("CREATE INDEX ON items USING hnsw (embedding vector_l2_ops)");// orconn.exec("CREATE INDEX ON items USING ivfflat (embedding vector_l2_ops) WITH (lists = 100)");
Usevector_ip_ops for inner product andvector_cosine_ops for cosine distance
See afull example
Everyone is encouraged to help improve this project. Here are a few ways you can help:
- Report bugs
- Fix bugs andsubmit pull requests
- Write, clarify, or fix documentation
- Suggest or add new features
To get started with development:
git clone https://github.com/pgvector/pgvector-d.gitcd pgvector-dcreatedb pgvector_d_testdub runSpecify the path to libpq if needed:
DFLAGS="-L-L/opt/homebrew/opt/libpq/lib" dub runTo run an example:
cd examples/openaicreatedb pgvector_exampledub runAbout
pgvector examples for D
Resources
License
Security policy
Uh oh!
There was an error while loading.Please reload this page.
Stars
Watchers
Forks
Releases
No releases published
Packages0
No packages published
Uh oh!
There was an error while loading.Please reload this page.