storage/migrations/002_add_vector.up.sql


1
2
3
4
5
6

CREATE VIRTUAL TABLE IF NOT EXISTS embeddings USING vec0(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    embedding FLOAT[5120],
    slug TEXT NOT NULL,
    raw_text TEXT NOT NULL
);