Documentation

Dreambase Documentation

Reference documentation for the Dreambase hybrid vector-SQL database. If you are evaluating Dreambase, start with the Quickstart and Concepts pages โ€” they explain the HNSW co-location model and query planner in enough detail to determine if the architecture fits your workload.

Getting started

Dreambase speaks the PostgreSQL wire protocol on port 5432. If you already use psycopg2, asyncpg, SQLAlchemy, or node-postgres, you can connect without installing a new driver. The native dreambase SDK adds typed vector column handling (float32 array serialization, NumPy integration), the NEAR query builder, and EXPLAIN HYBRID parsing โ€” but is optional for basic connectivity.

pip install dreambase

# or with Node
npm install dreambase

Your connection string is a standard PostgreSQL DSN:

import dreambase

db = dreambase.connect(
    "postgresql://<user>:<pass>@<host>.dreambase.io/<dbname>"
)