DolphinDB Client

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 Client, 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.

DolphinDB SQL IDE

DolphinDB Syntax Highlighting
DolphinDb SQL Code Completion
Server Browser for visually viewing a servers objects
Charts for displaying your data
All with specific support for DolphinDB

Setting up a DolphinDB connection in QStudio

Start DolphinDB
Connecting to DolphinDB
Querying DolphinDB

Start DolphinDB

Download DolphinDB from the official website.
Check dolphindb.cfg to see the setting for localSite=localhost:8848.
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.

Click on the menu options Server->Add Server or on the add server button on the toolbar.
Server Type: DolphinDB
Host:localhost
Port: 8848
Username: admin
Password: 123456
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 current statement	Ctrl + q
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

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.