asg017 / sqlite-vss

A SQLite extension for efficient vector search, based on Faiss!
MIT License
1.59k stars 58 forks source link

Python code does not work #116

Open tumikosha opened 5 months ago

tumikosha commented 5 months ago
# ubuntu 23.04/   ;  python 3.11
-----------
import sqlite3
import sqlite_vss

db = sqlite3.connect(':memory:')
db.enable_load_extension(True)
sqlite_vss.load(db)
-------------

Error: Process finished with exit code 132 (interrupted by signal 4: SIGILL)

asg017 commented 5 months ago

Make sure to install the required linux deps like so:

sudo apt-get update
sudo apt-get install libgomp1 libatlas-base-dev liblapack-dev libsqlite3-dev

Also, does your system support AVX2 instructions? The default sqlite-vss build uses AVX2 (because of Faiss), which might be causing the SIGILL error (which is "illegal instruction)