Skip to main content

SQLite

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

Installation and Setupโ€‹

We need to install the SQLAlchemy python package.

pip install SQLAlchemy

Vector Storeโ€‹

See a usage example.

from langchain_community.vectorstores import SQLiteVec
from langchain_community.vectorstores import SQLiteVSS # legacy
API Reference:SQLiteVec | SQLiteVSS

Memoryโ€‹

See a usage example.

from langchain_community.chat_message_histories import SQLChatMessageHistory
API Reference:SQLChatMessageHistory

Was this page helpful?