sqlite-vss
sqlite-vss copied to clipboard
asg017
A SQLite extension for efficient vector search, based on Faiss!
Currently there is a FaissException whenever the virtual table is empty. This causes a lot of problems as the system terminates without throwing an exception or any warning. Is there...
Hi I built `sqlite-vss` on `Windows 11 x64` using `cygwin64` I followed the instructions in [#building-sqlite-vss-yourself](https://github.com/asg017/sqlite-vss/blob/main/docs.md#building-sqlite-vss-yourself) ```ts $ make loadable cmake -B build; make -C build -- Could NOT find...
I have this code with the search query in python: vss_search_query = f""" SELECT rowid, filenames.filepath, Page_nr, Paragraph_nr, Sliding_Paras FROM policy_docs JOIN filenames ON policy_docs.filename_id = filenames.id WHERE vss_search(Sliding_Embedding, '{search_term_vector_sql}')...
Using the default `rowid` will cause errors if rows are deleted and a `VACUUM` is performed. The `rowid` for a row can be changed, but won't change inside the faiss...
As far as I can see, VSS uses the rowid field to correlate the index and data in a table. For lacalfirst applications that use sync and replications of a...
if index is empty i get error on query data code sample ``` import { EmbeddingModel, FlagEmbedding } from 'fastembed' import Database from "better-sqlite3"; import * as sqlite_vss from "sqlite-vss";...
In KNN style searches, we should support `rowid in (...)` constraints in queries like so: ```sql select rowid, distance from vss_articles where vss_search(description_embeddings, :query_vector) and rowid in (1, 2, 3,...
From https://github.com/asg017/sqlite-vss/discussions/108 : ```sql select rowid, distance from foo where vss_search(bar, json('[[1, 2, 3], [3, 2, 1]]')) limit 20; ``` Maybe a JOIN would be better, or [bump this up](https://github.com/asg017/sqlite-vss/blob/main/src/sqlite-vss.cpp#L1306)?
Much better structure. Among some of the things I have done are; * Created `SqlStatement` class encapsulating all SQL statements executed towards SQLite * Moved things into relevant _"xyz.h"_ file...
