Apache IoTDB vs Ubidots

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.

Ubidots provides tools to ingest, compute, visualize and act on IoT data in full-stack applications. Devices and machines can send data over MQTT or HTTP, and dashboards use widgets to display device data. Synthetic variables perform statistical and arithmetic operations on raw data over a time frame. Events can react to variable conditions, device inactivity or schedules and trigger email, SMS, voice calls, Slack messages or webhooks.

Plugins support AWS IoT, OpenWeather and LoRaWAN, as well as custom cron, webhook and widget plugins. Android and iOS apps show devices, historical variable data, web dashboards, event logs and push notifications, but cannot create or edit dashboards. The standard app is for account owners and admins; end users require an on-demand white-labeled app. The free STEM plan is for non-commercial projects and includes three devices. Professional costs $99 a month; a typical core-platform account begins with a free 30-day trial. Each device includes up to 20 variables for billing; additional variables may be billed as additional devices.