DolphinDB Build Internal Application

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.
Pulse is a free internal app builder, it allows creating data driven GUIS while writing only SQL code.

Setting up a DolphinDB connection in Pulse

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 DolphinDB from Pulse

When you first open Pulse it will look like the image below.



When you first open Pulse it will look like the image below.

1. Click on the Connections menu then Add Connection button.
2. Server Type: DolphinDB
3. Host:localhost
   Port: 8848
4. Username: admin
   Password: 123456
5. Click Add


Create Database

Copy paste the below code into the SQL editor. Then highlight everything and press Ctrl + e to run that code.

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");

Create UI

Go to the main dashboard listing page, then click add dashboard and:

1. Click add component Table.
2. Make sure the data source is set to your DolphinDB connection. Dolphin in this demo.
3. Enter your SQL query.
4. Click Send Query to update the UI.



Well Done!
You have now created your first Pulse App. See our other tutorials for more advanced examples.