storage/migrations/002_add_vector.up.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

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
);

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