sqlite-vec local embedding support for forge.db — offline semantic search #4

New issue

Closed

opened 2026-06-29 14:49:01 +00:00 by peterswimm · 0 comments

peterswimm commented

2026-06-29 14:49:01 +00:00

Owner

Wish: 86eb5027 — sqlite-vec local embedding support for forge.db

What

Add sqlite-vec (SQLite vector extension) to forge.db so local semantic search over wishes, lore cards, and intents can run without a network call to the embedding server.

Tasks

Add sqlite-vec extension to forge.db initialization in forge-core
Create vec_items virtual table (or equivalent) for wishes + lore embeddings
Wire ritual query semantic path to use sqlite-vec when embedding-server is unreachable (offline fallback)
Backfill existing wishes and lore cards with local embeddings on first run
Benchmark: local sqlite-vec query vs. remote embedding-server query latency

Acceptance criteria

ritual query "forge status" resolves correctly using sqlite-vec when offline
Embedding backfill completes without blocking startup
sqlite-vec loaded as SQLite extension (not a separate process)

Forge wish: 86eb5027

> **Wish:** `86eb5027` — sqlite-vec local embedding support for forge.db ## What Add `sqlite-vec` (SQLite vector extension) to forge.db so local semantic search over wishes, lore cards, and intents can run without a network call to the embedding server. ## Tasks - [ ] Add `sqlite-vec` extension to forge.db initialization in forge-core - [ ] Create `vec_items` virtual table (or equivalent) for wishes + lore embeddings - [ ] Wire `ritual query` semantic path to use `sqlite-vec` when embedding-server is unreachable (offline fallback) - [ ] Backfill existing wishes and lore cards with local embeddings on first run - [ ] Benchmark: local sqlite-vec query vs. remote embedding-server query latency ## Acceptance criteria - [ ] `ritual query "forge status"` resolves correctly using sqlite-vec when offline - [ ] Embedding backfill completes without blocking startup - [ ] `sqlite-vec` loaded as SQLite extension (not a separate process) _Forge wish: `86eb5027`_