Apache IoTDB vs LinDB

Apache IoTDB is an open-source industrial IoT time-series database for collecting, storing, managing, and analyzing device data across edge and cloud deployments. The project describes high-speed writes for millions of networked devices alongside fast reads. Query features include aligning time across devices and sensors, time-series computation, and aggregation by time dimensions. Ingestion options include IoTDB-SQL, JDBC, Java, C++, Python, and Go native APIs, REST, MQTT, CSV, and TsFile. Named analysis ecosystem examples include Hadoop, Spark, Flink, and Grafana. Deployment options include cloud installation, a desktop terminal tool, and synchronization between cloud and on-premise machines. The REST service is disabled by default and uses Basic Authentication except for the health check endpoint. Data and cluster permissions can be managed through users, roles, and privileges. The homepage states disk storage can cost less than $0.23 per GB. The project lists energy, aerospace, transportation, steel, and other IoT scenarios. Its JDBC documentation cautions that insert operations may not provide high-performance writing and recommends the Java Native API for Java applications.

LinDB is an open-source distributed time-series database for IoT and IT operations monitoring. It stores and analyzes metrics across IaaS, PaaS, SaaS and application layers, using a schema-free model of metrics, tags and fields. LinQL provides SQL-like syntax for queries and cluster or database operations; data can be inserted and queried through an HTTP REST API, client connections and an admin console. Ingestion supports FlatBuffers, Protocol Buffers and InfluxDB protocols, with Go and Java client libraries listed. The system separates computation from storage and identifies ETCD as its only external dependency. It supports replicas, horizontal scaling, operation across multiple IDCs, and automatic minute, hour and day rollups. Deployment documentation covers standalone and cluster modes, with packages for Linux, Windows and macOS and a Docker guide for Linux. LinDB is free under Apache 2.0. Its data scope is limited to numeric time series with accuracy up to the second; it is not suited to text records or finer time precision.