Category: SQL, Timeseries Status: draft
Connects to KX kdb+ — an ultra-high-performance time-series column-store database commonly used in financial services.
| Field | Default | Description |
|---|---|---|
| host | localhost | kdb+ server hostname or IP |
| port | 5000 | kdb+ listener port |
| user | (empty) | Username |
| password | (empty) | Password |
| dbname | (empty) | Database or namespace |
Username and password as configured in the kdb+ server's .z.pw handler.
Catalog browsing and table viewing. Direct q/SQL querying via the connection.
Requires the qpython Python package:
pip install qpython
A running kdb+ server is required. kdb+ is commercial software — a free 32-bit developer edition is available.