qStudio kdb+ IDE Help
- Getting Started.
- Adding Servers in Bulk
- Database Management
- User Permissions
- Advanced Use - Watching expressions, Autocompletion
- qDoc - How to write doc comments for the qDoc tool, generating Documentation.
- Database Documenter - Generate HTML describing your database tables.
- qUnit - Unit testing framework for q
- Csv Loader - Load CSV's and other text data into kdb+
- Keyboard Shortcuts
- User Preferences
- FAQ - Frequently Asked Questions
- For sqlDashboards see our sqlDashboards Help section.
If you installed qStudio for windows you can start it from the start menu, on linux/macs you should be able to make the jar executable and run it as long as you have java 1.6+ installed. (Click here for detailed instructions)
Connecting to a Server
When you first open qStudio it will look like the image below.
- Click on the menu options
Server->Add Serveror on the add server button on the toolbar.
- Enter the server details and click add
Now that you have added a server the panel labeled Server Tree will now display a nested drop down list of all tables / variables that exist on the server. On the toolbar the selected server dropdown will automatically have selected the latest added server. To send a query:
- Within the Documents panel click the cursor on the line with q code you want to execute.
( dt:2013.01.01+til 21; cosineWave:cos a; sineWave:sin a:0.6*til 21)
- Press Control+Enter to execute that line
- Or particularly useful for multi-line queries, highlight the text you want to execute and press Control+e to execute it.
Here you can see that I have sent the highlighted query. The result panel displays query results in the most appropriate format possible which for this data is as a table. If we click on the chart panel you will see that it has plotted a time series graph.
The Server Tree
When you added your kdb server the panel labeled Server Tree should have filled with the variables that exist on that server. e.g.
You can see that because I hovered it gave me some details about that variable. You can also Click on items to display them in the result panel. Here I have clicked on the quote item and I can page through that table in the result panel.
Right click can also be used to bring up actions relevant to that item.