In Lyric data system, mosquitto is used as MQTT broker to collect the data from smart massage device, TDengine is used as a time-series database to process the collected data, and Grafana is used as the visualization.
TDengine demonstrates excellent performance, 1: The writing speed can reach 12,000 to 13,000 records per second; 2: Storage spaces required for storing location data are only 1/7 of the former solution; 3: Querying the data from a single device by one-day interval will respond within 0.1 seconds.
Through comparative research on the solutions provided by several prevailing time-series databases such as IoTDB, Druid, ClickHouse, and TDengine, SF Technology finally decided to choose TDengine as a solution. Since using TDengine, impressive improvements have been achieved in the terms of stability and writing/query performance.
TDengine™ is an open-source, cloud-native time-series database optimized for Internet of Things (IoT), Connected Cars, and Industrial IoT. With its built-in caching, stream processing, and data subscription capabilities, TDengine offers a simplified solution for time-series data processing.