DolphinDB GUI

DolphinDB is a high-performance time-series database that integrates a powerful programming language and a real-time streaming data system to provide a one-stop solution for fast storage, retrieval, analysis and computing of large amounts of structured data. qStudio is a free SQL GUI, it allows running SQL scripts, easy browsing of tables, charting and exporting of results. It works on every operating system, with every database including TDEngine.

Setting up a DolphinDB connection in qStudio

Start DolphinDB

1. Download DolphinDB from the official website.
2. Check dolphindb.cfg to see the setting for localSite=localhost:8848.
3. Start dolphindb.exe
DolphinDB Systems 2.00.9.7 64 bit Copyright (c) 2011~2023 DolphinDB, Inc. Licensed to Trial Users. Expires on 2042.01.01 (Build:2023.06.08) >

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. Server Type: DolphinDB
3. Host:localhost
   Port: 8848
4. Username: admin
   Password: 123456
5. Click Add


Either when you add the connection or once you try to run code in the code editor, you will be asked to install the driver automatically. Say Yes.running



Sending Queries

Copy paste the below code into the SQL editor. Then highlight the commands you want to run and press Ctrl + e to run that code. See Keyboard Shortcuts.

Command	Shortcut
Run highlighted text	Ctrl + e
Run Line	Ctrl + Enter

timestamp = [09:34:07,09:36:42,09:36:51,09:36:59,09:32:47,09:35:26,09:34:16,09:34:26,09:38:12] sym = `C`MS`MS`MS`IBM`IBM`C`C`C price= 49.6 29.46 29.52 30.02 174.97 175.23 50.76 50.32 51.29 qty = 2200 1900 2100 3200 6800 5400 1300 2500 8800 t = table(timestamp, sym, qty, price); select * from t; db = database("d"); login(`admin, `123456); saveTable(db,t,"t"); loadTable(db,"t"); select * from loadTable(db,"t");

This will update your various results panels, result contains your table (excel export etc. supported), charts are generated based on your data and the console summarizes your recent commands



The Server Tree

The server tree populates but it's not a complete as we would like. We have reported the issue.

Warning: DolphinDB driver only works with java 9+. If you attempt to run earlier java versions, it will not work.

Well Done! You have now got qStudio querying your database successfully.

We want to make qStudio the best SQL analysis tool. If you have any problems or want additional features, please post on our github repo.