storage/migrations/002_add_vector.up.sql


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

--CREATE VIRTUAL TABLE IF NOT EXISTS embeddings_5120 USING vec0(
--    embedding FLOAT[5120],
--    slug TEXT NOT NULL,
--    raw_text TEXT PRIMARY KEY,
--);

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