DBMS > Apache IoTDB vs. InfluxDB vs. SingleStore

System Properties Comparison Apache IoTDB vs. InfluxDB vs. SingleStore

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name	Apache IoTDB  Xexclude from comparison	InfluxDB  Xexclude from comparison	SingleStore former name was MemSQL  Xexclude from comparison
Description	An IoT native database with high performance for data management and analysis, deployable on the edge and the cloud and integrated with Hadoop, Spark and Flink	DBMS for storing time series, events and metrics	MySQL wire-compliant distributed RDBMS that combines an in-memory row-oriented and a disc-based column-oriented storage with patented universal storage to handle transactional and analytical workloads in one single table type
Primary database model	Time Series DBMS	Time Series DBMS	Relational DBMS
Secondary database models		Spatial DBMS with GEO package	Document store Spatial DBMS Time Series DBMS
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 0.36 Rank #264   Overall #21   Time Series DBMS	Score 29.22 Rank #29   Overall #1   Time Series DBMS	Score 6.58 Rank #64   Overall #36   Relational DBMS
Website	iotdb.apache.org	www.influxdata.com/­products/­influxdb-overview	www.singlestore.com
Technical documentation		docs.influxdata.com/­influxdb	docs.singlestore.com
Developer	Apache Software Foundation		SingleStore Inc.
Initial release	2018	2013	2013
Current release		2.0.8, August 2021	7.6, November 2021
License Commercial or Open Source	Open Source Apache Version 2.0	Open Source MIT-License; commercial enterprise version available	commercial free developer edition available
Cloud-based only Only available as a cloud service	no	no	no
DBaaS offerings (sponsored links) Database as a Service Providers of DBaaS offerings, please contact us to be listed.			SingleStore Managed Service: The world's fastest, modern cloud database for both operational (OLTP) and analytical (OLAP) workloads. Available instantly with multi-cloud and hybrid-cloud capabilities
Implementation language	Java	Go	C++, Go
Server operating systems	All OS with a Java VM (>= 1.8)	Linux OS X through Homebrew	Linux 64 bit version required
Data scheme	yes	schema-free	yes
Typing predefined data types such as float or date	yes	Numeric data and Strings	yes
XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.	no	no	no
Secondary indexes	yes	no	yes
SQL Support of SQL	SQL-like query language	SQL-like query language	yes but no triggers and foreign keys
APIs and other access methods	JDBC Native API	HTTP API JSON over UDP	Cluster Management API as HTTP Rest and CLI HTTP API JDBC ODBC
Supported programming languages		.Net Clojure Erlang Go Haskell Java JavaScript JavaScript (Node.js) Lisp Perl PHP Python R Ruby Rust Scala	Bash C C# Java JavaScript (Node.js) Python
Server-side scripts Stored procedures	yes	no	yes
Triggers	yes	no	no
Partitioning methods Methods for storing different data on different nodes		Sharding in enterprise version only	Sharding hash partitioning
Replication methods Methods for redundantly storing data on multiple nodes		selectable replication factor in enterprise version only	Source-replica replication stores two copies of each physical data partition on two separate nodes
MapReduce Offers an API for user-defined Map/Reduce methods	Integration with Hadoop and Spark	no	no can define user-defined aggregate functions for map-reduce-style calculations
Consistency concepts Methods to ensure consistency in a distributed system	Eventual Consistency Strong Consistency with Raft		Immediate Consistency
Foreign keys Referential integrity	no	no	no
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data	no	no	ACID
Concurrency Support for concurrent manipulation of data	yes	yes	yes, multi-version concurrency control (MVCC)
Durability Support for making data persistent	yes	yes	yes All updates are persistent, including those to disk-based columnstores and memory-based row stores. Transaction commits are supported via write-ahead log.
In-memory capabilities Is there an option to define some or all structures to be held in-memory only.	yes	yes Depending on used storage engine	yes
User concepts Access control	yes	simple rights management via user accounts	Fine grained access control via users, groups and roles
More information provided by the system vendor
	Apache IoTDB	InfluxDB	SingleStore former name was MemSQL
Specific characteristics	Apache IoTDB (Internet of Things Database) is a time series data management system... » more	InfluxData is the creator of InfluxDB , the open source time series database. It... » more	SingleStore offers a fully-managed , distributed, highly-scalable SQL database designed... » more
Competitive advantages	Low Cost and High Performance Tens of million points write throughput High compression... » more	Time to Value InfluxDB is available in all the popular languages and frameworks,... » more	SingleStore’s competitive advantages include: Easy and Simplified Architecture with... » more
Typical application scenarios	IoT / IIoT End-Edge-Cloud Collaboration Real-Time and Historian Time Series Analytics » more	IoT & Sensor Monitoring Developers are witnessing the instrumentation of every available... » more	Driving Fast Analytics: SingleStore delivers the fastest and most scalable reporting... » more
Key customers	Over 200 customers worldwide, including Bosch, Siemens, Komat'su, Alibaba, etc. » more	InfluxData has more than 1,300 paying customers, including customers include MuleSoft,... » more	IEX Cloud : Improves Financial Data Distribution Speed 15x with Singlestore DB Comcast,... » more
Market metrics	185+ contributors and 10,000+ times monthly clones on GitHub Rank 7 by commits among... » more	Fastest growing database to drive 23,500 GitHub stars Over 600,000 daily active instances » more	Customers in various industries worldwide including US and International Industry... » more
Licensing and pricing models	Open Source: Apache License v2.0 Pricing for commercial-/cloud-/edge-edition provided... » more	Open source core with closed source clustering available either on-premise or on... » more	F ree Tier and Enterprise Edition » more
Related products and services We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
More resources
	Apache IoTDB	InfluxDB	SingleStore former name was MemSQL
DB-Engines blog posts