$db allrows "CREATE EXTENSION IF NOT EXISTS vector"

$db allrows "CREATE TABLE items (id bigserial PRIMARY KEY, embedding vector(3))"

set params [dict create embedding {[1,2,3]} embedding2 {[4,5,6]}]
$db allrows "INSERT INTO items (embedding) VALUES (:embedding), (:embedding2)" $params

set params [dict create embedding {[3,1,2]}]
$db foreach row "SELECT * FROM items ORDER BY embedding <-> :embedding LIMIT 5" $params {
    puts $row
}

$db allrows "CREATE INDEX ON items USING hnsw (embedding vector_l2_ops)"