DBMS > QuestDB vs. RocksDB vs. TimescaleDB
System Properties Comparison QuestDB vs. RocksDB vs. TimescaleDB
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||QuestDB Xexclude from comparison||RocksDB Xexclude from comparison||TimescaleDB Xexclude from comparison|
|Description||A high performance open source SQL database for time series data||Embeddable persistent key-value store optimized for fast storage (flash and RAM)||A time series DBMS optimized for fast ingest and complex queries, based on PostgreSQL|
|Primary database model||Time Series DBMS||Key-value store||Time Series DBMS|
|Secondary database models||Relational DBMS||Relational DBMS|
|Developer||QuestDB Limited||Facebook, Inc.||Timescale|
|Current release||7.10.2, March 2023||2.6.0, February 2022|
|License Commercial or Open Source||Open Source Apache 2.0||Open Source BSD||Open Source Apache 2.0|
|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.
|Server operating systems||Linux|
|Data scheme||yes schema-free via InfluxDB Line Protocol||schema-free||yes|
|Typing predefined data types such as float or date||yes||no||numerics, strings, booleans, arrays, JSON blobs, geospatial dimensions, currencies, binary data, other complex data types|
|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||yes|
|SQL Support of SQL||SQL-like query language||no||yes full PostgreSQL SQL syntax|
|APIs and other access methods||HTTP REST|
InfluxDB Line Protocol (TCP/UDP)
native C library
streaming API for large objects
|Supported programming languages||C PostgreSQL driver|
Rust over HTTP
|Server-side scripts Stored procedures||no||no||user defined functions, PL/pgSQL, PL/Tcl, PL/Perl, PL/Python, PL/Java, PL/PHP, PL/R, PL/Ruby, PL/Scheme, PL/Unix shell|
|Partitioning methods Methods for storing different data on different nodes||horizontal partitioning (by timestamps)||horizontal partitioning||yes, across time and space (hash partitioning) attributes|
|Replication methods Methods for redundantly storing data on multiple nodes||Configurable consistency for N replicas||yes||Source-replica replication with hot standby and reads on replicas|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||no||no||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID for single-table writes||yes||ACID|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes||yes||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes through memory mapped files||yes||no|
|User concepts Access control||no||fine grained access rights according to SQL-standard|
|More information provided by the system vendor|
|Specific characteristics||Relational model with native time series support Column based storage and time partitioned...|
|Competitive advantages||Real-time data ingestion and istant SQL queries for time series High performance...|
|Typical application scenarios||Application metrics Financial market data and algo trading DevOps monitoring Real-time...|
|Licensing and pricing models||Apache 2.0.|
MongoDB Time Series Benchmark and Review
Loading Pandas DataFrames into QuestDB
How Reliable is Your Distributed Database?
Running Databases on Kubernetes
The Tale of Troubleshooting: Unstable Builds and Open Source Infrastructure
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||Speedb: A high performance RocksDB-compliant key-value store optimized for write-intensive workloads.|
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|Recent citations in the news|
QuestDB snares $12M Series A with hosted version coming soon
QuestDB nabs $2.3M seed to build open source time series database
Read the Pitch Deck Database Startup QuestDB Used to Raise $12 ...
MindsDB is now the leading and fastest growing applied ML platform in the world
Build a Real-time Stock Price Dashboard With Python, QuestDB and ...
provided by Google News
New TDengine Benchmark Results Show Up to 37.0x Higher Query ...
Timescale Valuation Rockets to Over $1B with $110M Round ...
Timescale Announces OpenTelemetry Tracing Support for Promscale
Timescale Releases Third State of PostgreSQL Report
Timescale launches the new Timescale Cloud, a hosted relational ...
provided by Google News
AWS Data Engineer
Search Engineer - Back End
Search Engineer - Back End
Data Engineer (Kafka & Databricks)
Full Stack Developer - Crypto
Full Stack Developer
Full Stack Software Engineer
Share this page