The Slog

In a nutshell - I’ve been porting the unreleased Studio for kdb+ V2 to be a netbeans module (plug-in), which can also be wrapped up inside a Netbeans RCP (rich client application) application, or released as a stand-alone module.

What does that mean?

Well, if you are already running netbeans, you need only install this module, and you’ll have syntax highlighting for q files, ability to send queries to kdb+ servers, and to display the results in the table view or the classic console view.

If you don’t already have netbeans, you can download the zipped RCP, unzip it, and run as a stand-alone application.

Here’s a very quick and rough guide to installing the zipped RCP -

Download from http://skelton.fileburst.com/nb/studioforkdbplus.zip

unzip it, cd into the bin dir, and you’ll see the exe, double-click to start. You might want to increase available heap space, so you can edit the

etc/studioforkdbplus.conf file

setting this line

default_options=”-J-Xms24m -J-Xmx768m”

Once you have started it, the (only) windows of interest are

Favourites, kdb+ servers(Server Explorer), Results, Properties, Output

you can close all the other windows. If you want to open a window again, you can do that from the Windows menu.

To hook up keyboard shortcuts (like ctrl-e and ctrl-enter) goto

tools->options->keymap

and open up the edit node of the tree, select the Execute…. and then add whatever shortcut suits you.

To add a server, select the Servers node in the kdb+ Servers window, right-click->Add Server and the select it and edit the servers properties in the properties window.

The server connections are cached. It currently dont detect whether a connection has died until you try to query it. So if a server is restarted, the first query you run will generate a null pointer exception

The active server context used for a query is the one that is selected in the kdb+ server window.

Use the favourites window to (mount &) view your filesystem. Editing a q file via double-clicking on a file in the favouraites window.

Disclaimer - use at your own risk, I accept no liabilities for this software.

Enjoy.