Recollect.DatabaseAdapter.SQLiteVec (recollect v0.5.1)

Copy Markdown View Source

SQLite database adapter with sqlite-vec extension for vector support.

This adapter uses standard SQLite via ecto_sqlite3 combined with the sqlite_vec extension for vector similarity search. Unlike libSQL, this works on all platforms including Windows.

Features

  • sqlite-vec extension for vector search (vec0 virtual tables)
  • Single-file database (easy backup/restore)
  • Cross-platform support (macOS, Linux, Windows)
  • Brute-force cosine distance search (DiskANN ANN in alpha)

Requirements

  • ecto_sqlite3 package
  • sqlite_vec package (bundles precompiled extension binaries)

Configuration

config :recollect, :database_adapter, Recollect.DatabaseAdapter.SQLiteVec

config :your_app, YourRepo,
  adapter: Ecto.Adapters.SQLite3,
  load_extensions: [SqliteVec.path()]