Getting Started

pg.zig

_=tryconn.exec("CREATE EXTENSION IF NOT EXISTS vector", .{});

_=tryconn.exec("CREATE TABLE items (id bigserial PRIMARY KEY, embedding vector(3))", .{});

constembedding1= [_]f32{1,2,3 };constembedding2= [_]f32{4,5,6 };_=tryconn.exec("INSERT INTO items (embedding) VALUES ($1::float4[]), ($2::float4[])", .{embedding1,embedding2 });

constembedding3= [_]f32{3,1,2 };varresult=tryconn.query("SELECT id FROM items ORDER BY embedding <-> $1::float4[]::vector LIMIT 5", .{embedding3});

_=tryconn.exec("CREATE INDEX ON items USING hnsw (embedding vector_l2_ops)", .{});// or_=tryconn.exec("CREATE INDEX ON items USING ivfflat (embedding vector_l2_ops) WITH (lists = 100)", .{});

libpq

constpg=@cImport({@cInclude("libpq-fe.h");});

constres=pg.PQexec(conn,"CREATE EXTENSION IF NOT EXISTS vector");

constres=pg.PQexec(conn,"CREATE TABLE items (id bigserial PRIMARY KEY, embedding vector(3))");

constparamValues= [2:0][*c]constu8{"[1,2,3]","[4,5,6]" };constres=pg.PQexecParams(conn,"INSERT INTO items (embedding) VALUES ($1), ($2)",2,null,&paramValues,null,null,0);

constparamValues= [1:0][*c]constu8{"[3,1,2]"};constres=pg.PQexecParams(conn,"SELECT * FROM items ORDER BY embedding <-> $1 LIMIT 5",1,null,&paramValues,null,null,0);

constres=pg.PQexec(conn,"CREATE INDEX ON items USING hnsw (embedding vector_l2_ops)");// orconstres=pg.PQexec(conn,"CREATE INDEX ON items USING ivfflat (embedding vector_l2_ops) WITH (lists = 100)");

Contributing

git clone https://github.com/pgvector/pgvector-zig.gitcd pgvector-zigcreatedb pgvector_zig_testzig buildzig-out/bin/pgzig-out/bin/libpq

zig build --search-prefix /opt/homebrew/opt/libpq

createdb pgvector_examplezig-out/bin/openai