qStudio kdb+ IDE Help

  1. Getting Started.
    1. Connecting to a Server
    2. Sending Queries
    3. Kdb Server Tree
  2. Adding Servers in Bulk
  3. Charting
  4. Database Management
  5. User Permissions
  6. Advanced Use - Watching expressions, Autocompletion
  7. qDoc - How to write doc comments for the qDoc tool, generating Documentation.
  8. Database Documenter - Generate HTML describing your database tables.
  9. qUnit - Unit testing framework for q
  10. Csv Loader - Load CSV's and other text data into kdb+
  11. Keyboard Shortcuts
  12. User Preferences
  13. FAQ - Frequently Asked Questions
  14. For sqlDashboards see our sqlDashboards Help section.
View Quick Start Video play

Getting Started

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.

  1. Click on the menu options Server->Add Server or on the add server button on the toolbar.
  2. Enter the server details and click add

qStudio when first loaded server settings

Sending Queries

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:

  1. Within the Documents panel click the cursor on the line with q code you want to execute.
    Example: ([] dt:2013.01.01+til 21; cosineWave:cos a; sineWave:sin a:0.6*til 21)
  2. Press Control+Enter to execute that line
  3. Or particularly useful for multi-line queries, highlight the text you want to execute and press Control+e to execute it.

sending a kdb+ query in qStudio

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.

server tree showing the variables that exist on a kdb server

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.

browsing partitioned table in kdb+ within qStudio

Right click can also be used to bring up actions relevant to that item.

right click kdb+ server tree