Skip to main content

Database Setup

Configure different database backends for agent persistence.

SQLite (Default)

from praisonaiagents import Session

session = Session(
    session_id="my-session",
    persistence="sqlite",
    db_path="./data/sessions.db"
)

PostgreSQL

pip install psycopg2-binary
from praisonaiagents import Session

session = Session(
    session_id="my-session",
    persistence="postgresql",
    connection_string="postgresql://user:pass@localhost:5432/praisonai"
)
Or via environment variable:
export DATABASE_URL="postgresql://user:pass@localhost:5432/praisonai"

Redis

pip install redis
from praisonaiagents import Session

session = Session(
    session_id="my-session",
    persistence="redis",
    redis_url="redis://localhost:6379/0"
)

MongoDB

pip install pymongo
from praisonaiagents import Session

session = Session(
    session_id="my-session",
    persistence="mongodb",
    mongodb_url="mongodb://localhost:27017/praisonai"
)