Spaces:
Paused
Paused
Download scripts/sqlite-vec-smoke.mjs from amos-fernandes/melbot: direct link, hf CLI and curl.
- Browser
- Download file 1.01 kB
-
https://huggingface.co/spaces/amos-fernandes/melbot/resolve/main/scripts/sqlite-vec-smoke.mjs
- Command line
-
hf download hf://spaces/amos-fernandes/melbot/scripts/sqlite-vec-smoke.mjs
-
curl -L -o sqlite-vec-smoke.mjs https://huggingface.co/spaces/amos-fernandes/melbot/resolve/main/scripts/sqlite-vec-smoke.mjs
1.01 kB
| import { DatabaseSync } from "node:sqlite"; | |
| import { load, getLoadablePath } from "sqlite-vec"; | |
| function vec(values) { | |
| return Buffer.from(new Float32Array(values).buffer); | |
| } | |
| const db = new DatabaseSync(":memory:", { allowExtension: true }); | |
| try { | |
| load(db); | |
| } catch (err) { | |
| const message = err instanceof Error ? err.message : String(err); | |
| console.error("sqlite-vec load failed:"); | |
| console.error(message); | |
| console.error("expected extension path:", getLoadablePath()); | |
| process.exit(1); | |
| } | |
| db.exec(` | |
| CREATE VIRTUAL TABLE v USING vec0( | |
| id TEXT PRIMARY KEY, | |
| embedding FLOAT[4] | |
| ); | |
| `); | |
| const insert = db.prepare("INSERT INTO v (id, embedding) VALUES (?, ?)"); | |
| insert.run("a", vec([1, 0, 0, 0])); | |
| insert.run("b", vec([0, 1, 0, 0])); | |
| insert.run("c", vec([0.2, 0.2, 0, 0])); | |
| const query = vec([1, 0, 0, 0]); | |
| const rows = db | |
| .prepare( | |
| "SELECT id, vec_distance_cosine(embedding, ?) AS dist FROM v ORDER BY dist ASC" | |
| ) | |
| .all(query); | |
| console.log("sqlite-vec ok"); | |
| console.log(rows); | |