ClickHouse
ClickHouse is the fast and resource efficient open-source database for real-time apps and analytics with full SQL support and a wide range of functions to assist users in writing analytical queries. It has data structures and distance search functions (like
L2Distance) as well as approximate nearest neighbor search indexes That enables ClickHouse to be used as a high performance and scalable vector database to store and search vectors with SQL.
Installation and Setup
We need to install clickhouse-connect python package.
pip install clickhouse-connect
Vector Store
See a usage example.
from langchain_community.vectorstores import Clickhouse, ClickhouseSettings