KDB+ with DBine
How to connect DBine to KDB+ and what you can do once it's connected. This page is written from what the KDB+ driver says about itself, so it matches the version of DBine you download.
Connect
- In DBine, open New connection.
- Pick KDB+ in the list of engines.
- Fill in the fields below, press Test connection and then Save and connect.
Default port: 5000.
General
| Field | Description |
|---|---|
| Server required | Example: localhost |
| Port | Example: 5000 |
| User | Empty if the process doesn't ask for a user (no -u or -U). |
| Password | Kept in the system keychain, never in DBine's files. |
| Read-only | On or off. |
SSH tunnel. The connection can go through an SSH server, even through a chain of bastions, with a password, a private key or the SSH agent. The server's fingerprint is checked against known_hosts or confirmed the first time.
SSL/TLS
| Field | Description |
|---|---|
| tcps | Encrypts the connection with TLS (:tcps://) and verifies the server's certificate. On or off. |
| SSL_VERIFY_SERVER | Unchecked (SSL_VERIFY_SERVER=NO), the certificate isn't verified: DBine accepts the first one it sees and only that one afterwards. On or off. |
| SSL_CA_CERT_FILE | PEM file with the CA that signed the server's certificate; empty = the system's authorities. A file on this computer. |
What the explorer shows
The objects appear right under the connection:
- Tables
- Partitioned tables
- Splayed tables
- Views
- Functions
- Variables
Query editor
The editor uses KDB+'s commands, with completion for the connection's objects. Statements and commands run against the database selected in the tab.
What the editor accepts:
Consultas en q, una por línea (una línea que empieza con espacio sigue la anterior):
select from trade where date=last date, sym=`AAPL
select avg price by sym from trade
meta trade | tables[] | count trade
\v (variables) | \f (funciones) | \b (vistas)
Un comentario empieza con / al principio de la línea o después de un espacio.Ready-made templates for new objects:
- New view
- New function
Tools for KDB+
Available
- Server monitor
- Sessions and running queries
- End a session
- Visual designer for new objects
Not available for KDB+
- Graphical execution plans
- Live query profiler
- Locks: who blocks whom
- Cancel another session's query from the sessions list
- Manual transactions (commit and rollback)
- Index usage
- Create databases
- Drop databases
- Database properties
- Relations in the ER diagram
- Rename objects
- Compare and sync schemas
- Clone tables
- Native bulk load when migrating data
- Users and permissions
- Backups
Why a tool doesn't apply to an engine, and the details of each one, are in the engine support reference.
Generated from the KDB+ driver 0.1.0, which DBine downloads the first time you connect to KDB+.