The original starting from: https://mp.weixin.qq.com/s/s8VHp_fIkHLtXZejPyv5OA

When our team was working on the smart meter project, we chose the data storage scheme based on TDEngine. In the development process, we found that it was not convenient to view the data without the graphical management tool, so we developed the TDEngineGUI internally for data management. Following the concept of the Tdengine team completely open source, now this small tool is open source, easy to develop and use.

TDengineGUI profile

TDEngineGUI is a graphical management tool based on Electron and developed for TDEngine. It has the characteristics of cross-platform, easy to use and strong version adaptability.

access

Download the latest version of the executable

GitHub：https://github.com/skye0207/TDengineGUI/releases/tag/v1.0.0

Yards cloud: https://gitee.com/skyebaobao/TDengineGUI/releases/v1.0.0

Current Version Features

  • Connecting to the database through the RESTful interface of TDEngine is basically unaffected by the server version upgrade
  • Database add delete operation, display database properties
  • Displays the super table and table information in the database, removes the super table and table function
  • Display super table and table data function, provide paging, time period retrieval, field filtering, sorting and other functions

Run the development version from source code

1. Cloning Project:

git clone https://github.com/skye0207/TDengineGUI.git

If GitHub is slow to download, you can download a synchronous update from the cloud:

git clone https://gitee.com/skyebaobao/TDengineGUI.git

2. Installation Dependencies:

npm install

3. Start the development version:

npm run start

4. Generate desktop applications:

NPM Run Build // The installation package and executable files are generated in the dist folder

Directions for use

After opening the software, the list of database servers to be managed and the list of databases in the server will be displayed on the left side of the interface, as well as the version number of the database server.

You can use the “New Connection” button to add a new server for management. You need to provide the IP address of the database server, the port number of the RESTful service (default is 6041), and the user name and password to connect to the server (default is root:taosdata).

You can add database by clicking on the Add Database icon. Database properties can be selected at add time (refer to the TDengine official documentation for the meaning of the properties)

You can delete the database connection by clicking the delete icon after connecting to the server.

After selecting the database to be operated, you can enter the current database operation interface. You can click the “Switch” button to bring up the database navigation bar, switch the database to operate. The current database operation interface is divided into four tabs: super table, table, console and database properties. Each TAB displays and acts on the current database.

In the TAB page of super table (table), the left side is the list of super table (table), which can be deleted and retrieved (add, modify and other operations will be provided in the later version, if you want to add data table or insert data in the current version, please use the console input command to complete). The left side shows the data of the current data table.

You can select the time period for table data.

Time field filtering, sorting, paging and other operations can be performed on the table data.

The console can enter SQL commands to run and display the original results returned by the RESTful interface. Commands entered in the console operate on the current database by default, and there is no need to append the database name to the table name in general. But you can also pass the “database name.” Operates on tables in other databases by table name. (The way the results are displayed will be improved in future versions)

Database properties show some of the basic properties of the current database, later versions will add property modification function.

Product outlook

We will continue to develop and iterate on this small project to release better versions 2.0 and 3.0. Provide data visualization, batch import and export data and other functions. I hope that TDEngineer will have a good time and give valuable suggestions. One key three links on GitHub!

About the author: Wang Guan (WeChat ID: DAISY_Louise), a front-end engineer, graduated from Tianjin University majoring in software engineering.

If you’d like to become a community contributor to Tdengine, click on the link to learn more