Simon Willison’s Weblog

Subscribe

Friday, 10th February 2023

Introducing sqlite-vss: A SQLite Extension for Vector Search (via) This latest SQLite extension from Alex Garcia is possibly his best yet: it adds FAISS-powered vector similarity search directly to SQLite, enabling fast KNN similarity lookups against a virtual table that feels a lot like SQLite’s own built-in full text search feature. This write-up includes interactive demos using Datasette called from an Observable notebook, running similarity searches against an index of 200,000 news headlines and summaries in less than 50ms.

# 10:53 pm / sqlite, datasette, observable, alex-garcia, vector-search

2023 » February

MTWTFSS
  12345
6789101112
13141516171819
20212223242526
2728