PGVector
Vector search in PostgreSQL using pgvector extension.Setup
Usage
Configuration
| Option | Description |
|---|---|
url | PostgreSQL connection URL |
schema | Schema name (default: public) |
table_prefix | Table prefix (default: praison_) |
PostgreSQL with pgvector extension for PraisonAI
# Docker with pgvector
docker run -d -p 5432:5432 -e POSTGRES_PASSWORD=password ankane/pgvector
pip install psycopg2-binary
from praisonai.persistence.factory import create_knowledge_store
store = create_knowledge_store(
"pgvector",
url="postgresql://postgres:password@localhost:5432/praisonai"
)
store.create_collection("documents", dimension=384)
store.insert("documents", [doc])
results = store.search("documents", query_embedding, limit=5)
| Option | Description |
|---|---|
url | PostgreSQL connection URL |
schema | Schema name (default: public) |
table_prefix | Table prefix (default: praison_) |