SQLite is a database engine written in theC programming language. It is not a standalone app; rather, it is a library thatsoftware developers embed in their apps. As such, it belongs to the family ofembedded databases. It is the most widely deployed database engine, as it isused by several of the top web browsers, operating systems, mobile phones, and other embedded systems.

Installation and Setup​

We need to install theSQLAlchemy python package.

pip install SQLAlchemy

Vector Store​

See ausage example.

from langchain_community.vectorstoresimport SQLiteVec
from langchain_community.vectorstoresimport SQLiteVSS# legacy

Memory​

See ausage example.

from langchain_community.chat_message_historiesimport SQLChatMessageHistory