summaryrefslogtreecommitdiff
path: root/storage/migrations
diff options
context:
space:
mode:
authorGrail Finder <wohilas@gmail.com>2024-12-31 13:25:13 +0300
committerGrail Finder <wohilas@gmail.com>2024-12-31 13:25:13 +0300
commit461d19aa2512fea7ac07e50c3178609850ef07c3 (patch)
tree1e317b813686ca7696e96bba766cdbd3aeb35138 /storage/migrations
parent4db8aea43dded3f2c1d0d41b5a3fb322a38d4730 (diff)
Feat: add rag [wip; skip-ci]
Diffstat (limited to 'storage/migrations')
-rw-r--r--storage/migrations/002_add_vector.up.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/storage/migrations/002_add_vector.up.sql b/storage/migrations/002_add_vector.up.sql
new file mode 100644
index 0000000..4fcc9aa
--- /dev/null
+++ b/storage/migrations/002_add_vector.up.sql
@@ -0,0 +1,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
+);