Repository navigation
Releases: radioactive-labs/sqlite_search
Releases · radioactive-labs/sqlite_search
Release list
v0.1.0
Added
- Full-text search over ActiveRecord with SQLite FTS5: the
fts5_scopeDSL, the
create_fts5_indexmigration helper (round-trips throughschema.rb), a query
sanitizer that makes untrusted input safe, BM25 relevance ranking via
order_by_rank, model-owned callback sync, andModel.reindexplus a rake task. - Vector search with sqlite-vec through the
neighborgem: thevec_scopeDSL, the
create_vec_indexmigration helper, an app-registeredSqliteSearch.embedder,
async embedding throughSqliteSearch::EmbedJob(with async: :inlineoption
and a configurable queue), andModel.reembedplus a rake task. - Hybrid search:
hybrid_scopefuses anfts5_scopeand avec_scopewith
Reciprocal Rank Fusion, with an optional, degradableSqliteSearch.reranker. - Exact pre-filtering by chaining: conditions placed before
.search/.semantic
(for examplePost.where(tenant_id: 5).search("...")) push into both arms. - Rails generators for the FTS5 and vec migrations.
- Derived text:
source:andwatch:onfts5_scopeandvec_scopeindex text
computed in Ruby and resync when the watched attributes change. vec_scope ..., sync: :manualwithrecord.reembedfor apps that run their own
embedding pipeline.- Relevance thresholds:
order_by_rank(threshold:), and per-arm
fts5_threshold:/vec_threshold:on hybrid scopes. - A reranker can return
[record, score]pairs, which set each result's
<name>_scoreto the reranker's score.