summaryrefslogtreecommitdiff
path: root/storage/migrations/002_add_vector.up.sql
diff options
context:
space:
mode:
authorGrail Finder <wohilas@gmail.com>2025-01-04 18:13:13 +0300
committerGrail Finder <wohilas@gmail.com>2025-01-04 18:13:13 +0300
commit4736e43631ed21fd14741daa1dde746687d330fa (patch)
treec5dcee2930e8681397a369ae7869671bdcf568dc /storage/migrations/002_add_vector.up.sql
parent461d19aa2512fea7ac07e50c3178609850ef07c3 (diff)
Feat (RAG): tying tui calls to rag funcs [WIP; skip-ci]
RAG itself is annoying to properly implement, plucking sentences with no context is useless. Also it should not be a part of main package, same for goes for tui. The number of global vars is absurd.
Diffstat (limited to 'storage/migrations/002_add_vector.up.sql')
-rw-r--r--storage/migrations/002_add_vector.up.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/storage/migrations/002_add_vector.up.sql b/storage/migrations/002_add_vector.up.sql
index 4fcc9aa..f64aecb 100644
--- a/storage/migrations/002_add_vector.up.sql
+++ b/storage/migrations/002_add_vector.up.sql
@@ -4,3 +4,10 @@ CREATE VIRTUAL TABLE IF NOT EXISTS embeddings USING vec0(
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
+);