TDEngine Build Internal Application

TDengine is an industrial data platform purpose-built for the IoT (Internet of Things), combining a time series database with essential features like stream processing, data subscription, and caching.
Pulse is a free internal app builder, it allows creating data driven GUIS while writing only SQL code.

Setting up a TDengine connection in Pulse

Start TDEngine
Connecting to TDEngine
Create TDEngine Database
Create UI

Start TDEngine

We will use docker to quickly launch an instance of TDEngine:

docker pull tdengine/tdengine:3.0.1.4
docker run -d -p 6030:6030 -p 6041:6041 -p 6043-6049:6043-6049 -p 6043-6049:6043-6049/udp tdengine/tdengine

This will output something similar to the below when it runs successfully.
TDengine Server 3.0 uses TCP port 6030.
Port 6041 is used by taosAdapter for the REST API service.
Ports 6043 through 6049 are used by taosAdapter for other connectors.

john@SERVER-BOX-1 $ docker pull tdengine/tdengine:3.0.1.4

3.0.1.4: Pulling from tdengine/tdengine
Digest: sha256:f67b428e3c97c32ab0c03d8b530106921ac46ac93f8527fb870d0e0a4b75242d
Status: Image is up to date for tdengine/tdengine:3.0.1.4
docker.io/tdengine/tdengine:3.0.1.4

john@SERVER-BOX-1 $ docker run -d -p 6030:6030 -p 6041:6041 -p 6043-6049:6043-6049 -p 6043-6049:6043-6049/udp tdengine/tdengine
08af8bc59cd83b0e54bfdb987528cc96ebccbcf3ba8c24785e3ef4af8a4a4190

john@SERVER-BOX-1 $ docker ps
CONTAINER ID   IMAGE               COMMAND                  CREATED         STATUS         PORTS
                              NAMES
08af8bc59cd8   tdengine/tdengine   "/tini -- /usr/bin/e…"   4 seconds ago   Up 3 seconds   0.0.0.0:6030->6030/tcp, 0.0.0.0:6041->6041/tcp, 0.0.0.0:6043-6049->6043-6049/tcp, 0.0.0.0:6043-6049->6043-6049/udp   charming_burnell

Connecting to TDEngine from Pulse

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

Click on the Connections menu then Add Connection button.
Server Type: TDEngine
Host:localhost
Port: 6041
Username: root
Password: taosdata
Click Add

Once you've added the connection, you can run code on the SQL page or add a dashboard.

Create Database

Copy paste the below code into the SQL editor. Then Run this code line by line otherwise it will FAIL.

// DROP DATABASE IF EXISTS db;
CREATE DATABASE db;
use db;
SHOW DATABASES;

CREATE STABLE meters (ts timestamp, current float, voltage int, phase float) TAGS (location binary(64), groupId int);
CREATE TABLE d1001 USING meters TAGS ("California.SanFrancisco", 2);
INSERT INTO d1001 USING meters TAGS ("California.SanFrancisco", 2) VALUES (now, 10.2, 219, 0.32);
SHOW TABLES;

select * from meters;
select * from d1001;

Create UI

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

Click add component Table.
Make sure the data source is set to your TDEngine connection. TDE in this demo.
Enter your SQL query.
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.