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.
Quickstart
Up and running in 10 minutes
Core concepts
How the hybrid row model works
SQL + Vector guide
Writing hybrid queries
Python SDK
Full SDK reference
API reference
REST + wire protocol
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>"
)