How to use tdengine visually with idea database management tool?

Time:2020-9-28

What is the idea database management tool?

This paper first introduces idea, which is full name of IntelliJ idea. It is an integrated environment for Java language development. IntelliJ is recognized as one of the best java development tools in the industry.

Idea is a database management tool, similar to a small Navicat. This tool allows us to operate data directly in idea without switching to other tools. For tdengine, users can establish a connection with idea through jdbc driver, instead of writing SQL statements to the command line, they can execute it directly in idea. This also provides a solution for you to use tdengine visually.

How to connect to tdengine through idea database management tool?

  1. Add tdengine using the database module of idea

How to use tdengine visually with idea database management tool?

  1. Fill in database connection

How to use tdengine visually with idea database management tool?

  1. Connection test

How to use tdengine visually with idea database management tool?

  1. Follow the prompts to configure the driver for tdengine

How to use tdengine visually with idea database management tool?

  1. Add driver

How to use tdengine visually with idea database management tool?
How to use tdengine visually with idea database management tool?

Since the official driver [I downloaded one from Maven repository] relies on the Apache common package, the driver cannot run independently. If an error is reported after importing, it will prompt that the stringutils package does not exist. Therefore, I changed the source code of the driver and removed the dependency

Modified driver download address:

https://download.csdn.net/dow…

Of course, you can also modify the source code to remove the dependency of Apache stringutils in tsdbdriver class
How to use tdengine visually with idea database management tool?

  1. After the introduction of driver

How to use tdengine visually with idea database management tool?

  1. Reconnection test

How to use tdengine visually with idea database management tool?

You can see that the connection is successful. If there are problems in connection, there are many reasons. I have encountered that the database version is inconsistent with the client version under windows. Changing the two versions to be consistent will solve the problem.

If there are any problems, please refer to the official documents to explain the causes of the problems:

https://www.taosdata.com/cn/d…

There is another mistake that we can leave alone
How to use tdengine visually with idea database management tool?

  1. Specific use steps

How to use tdengine visually with idea database management tool?
How to use tdengine visually with idea database management tool?
How to use tdengine visually with idea database management tool?
How to use tdengine visually with idea database management tool?

At this point, the results in the tdengine table are fully displayed.

However, in this process, there is a concept that needs to be corrected. It is not entirely correct to understand tdengine as a temporal database. Tdengine is essentially an open source and efficient big data platform for the Internet of things. In addition to the core time series database function which is more than 10 times faster, tdengine also provides caching, data subscription, streaming computing and other functions. This concept is very important. Please recite it three times.

Brief introduction to the author: Zeng Jianqiang, R & D Engineer of avionics construction technology, is currently responsible for the research of data visualization, has a strong interest in technology research, and is an open source community enthusiast.

The core functions of tdengine are completely open source. With the open source wind, tdengine has also received a lot of support and feedback from the open source community. In addition to the God who introduced the idea method, there are many small partners who contribute dry goods. For example, maikebing, who contributed to the. Net core driver, has always been an active member of the community. Next time, I would like to focus on introducing several tools he has contributed.

I hope that while using tdengine, you can also give full play to your technical enthusiasm and participate in the contribution of the community!