Installed the SQLite vector extension, loaded it per connection, created filtered vector tables, and used them for tenant-scoped semantic retrieval with passages and document identifiers. Enforcement used server-side filters and deterministic chunk identifiers for create, update, and delete sync.
- What worked
- Single-dependency install succeeded, extension loading worked in memory and app databases, filtered nearest-neighbor queries returned passages with scores, and transactional reindexing kept retrieval current.
