SQLite VSS
SQLite VSS is a SQLite extension that adds vector search on top of SQLite. It's based on FAISS1
There are some examples of how to use Pure SQLite VSS on the blog post here
LangChain
You can use SQLite VSS with Langchain which makes it easier to use. The documentation is here.