This Visual Studio Code extension provides extensive features for the kdb+/q programming language.
Features include syntax highlighting, auto completion, executing queries on a kdb+ server, table visualization and more.
The extension is developed with Atom's connect-kdb-q extension and QInsightPad in mind.
Although any theme will work, the recommended theme is Atom One Dark for the best experience.
Please note that the extension is usable in its current state, but is still under development.
Features
The extension currently provides the following features:
Accurate syntax highlighting
Reliable code completion (based on remote server process)
Running kdb+ queries and output the result to multiple views
Syntax highlighted document view for query results
High performance grid view for table results
Console view supporting even the largest table sizes
Explorer view exposing all functions and variables
Server view configurable per workspace (settings.json)
Demonstration
Requirements
VS Code 1.47.0 is required and kdb+ 3.6 or higher is recommended.
Extension Settings
Name
Default
Description
vscode-kdb-q.consoleViewEnabled
false
Whether results should be printed to the kdb-q console
vscode-kdb-q.gridViewEnabled
true
Whether table results should be printed to the grid view
vscode-kdb-q.documentViewEnabled
true
Whether results should be printed to a virtual document
vscode-kdb-q.gridViewPosition
Two
The view column used show the grid view
vscode-kdb-q.documentViewPosition
Grid
The view column used show the document view
vscode-kdb-q.serverList
[]
Array with server connection strings (host:port:id:pw)
vscode-kdb-q.serverGroupMode
Hostname
The rule for server grouping withing the server view
Keyboard Shortcuts
Keyboard shortcut
Command
Ctrl/Cmd + Q
Connect to kdb+ server
Ctrl/Cmd + E
Run selection as query
Ctrl/Cmd + Enter
Run current line as query
Known Issues
Below is a list of known issues and incomplete features:
Code completion is not supported when not connected to a kdb+ server
Nested table objects are not printed to console/document view
License
Licensed under GNU General Public License v3.0.
See the license file for more details.
Release Notes
1.2.0
Added support for printing dictionaries and keyed tables
Added icon to status bar to indicate connection status
Added auto (re)connect upon query
Several bug fixes regarding query results
Usability and interface improvements
1.1.2
Minor fixes to grid view, and nested object formatting
1.1.1
Added server view (configurable through settings.json)
Minor fixes to how result views are handled
1.1.0
New features:
Syntax highlighted document view for query results
Extension settings for enabled panels and their positions
Click items from kdb+ explorer to see their contents
Default keybindings (Ctrl+Q for connect, Ctrl+E/Ctrl+Enter for running queries)
Support for filtering dates and numbers in grid view
Connection status bar item is now clickable to connect
Nanosecond precision for timespans (up from milliseconds)
Microsecond precision for timestamps (up from milliseconds)
Bug fixes:
Fixed auto completion not working in some cases
Fixed printing of empty tables
Fixed variables in global namespace in kdb+ explorer
