DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Datomic vs. DuckDB vs. QuestDB vs. RocksDB vs. SiriDB

System Properties Comparison Datomic vs. DuckDB vs. QuestDB vs. RocksDB vs. SiriDB

Editorial information provided by DB-Engines
NameDatomic  Xexclude from comparisonDuckDB  Xexclude from comparisonQuestDB  Xexclude from comparisonRocksDB  Xexclude from comparisonSiriDB  Xexclude from comparison
DescriptionDatomic builds on immutable values, supports point-in-time queries and uses 3rd party systems for durabilityAn embeddable, in-process, column-oriented SQL OLAP RDBMSA high performance open source SQL database for time series dataEmbeddable persistent key-value store optimized for fast storage (flash and RAM)Open Source Time Series DBMS
Primary database modelRelational DBMSRelational DBMSTime Series DBMSKey-value storeTime Series DBMS
Secondary database modelsRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.74
Rank#130  Overall
#65  Relational DBMS
Score0.23
Rank#282  Overall
#131  Relational DBMS
Score1.14
Rank#163  Overall
#12  Time Series DBMS
Score3.70
Rank#88  Overall
#15  Key-value stores
Score0.01
Rank#347  Overall
#35  Time Series DBMS
Websitewww.datomic.comduckdb.orgquestdb.iorocksdb.orgsiridb.net
Technical documentationdocs.datomic.comduckdb.org/­docsquestdb.io/­docs/­introductiongithub.com/­facebook/­rocksdb/­wikidocs.siridb.net
DeveloperCognitectQuestDB LimitedFacebook, Inc.Transceptor Technology
Initial release20122018201420132017
Current release0.9.5951, July 20190.2, August 20206.27.3, December 2021
License infoCommercial or Open Sourcecommercial infolimited edition freeOpen Source infoMIT LicenseOpen Source infoApache 2.0Open Source infoBSDOpen Source infoMIT License
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJava, ClojureC++JavaC++C
Server operating systemsAll OS with a Java VMserver-lessLinux
macOS
Windows
Linux
Data schemeyesyesyes infoschema-free via InfluxDB Line Protocolschema-freeyes
Typing infopredefined data types such as float or dateyesyesyesnoyes infoNumeric data
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.nonononono
Secondary indexesyesyesnonoyes
SQL infoSupport of SQLnoyesSQL-like query languagenono
APIs and other access methodsRESTful HTTP APICLI Client
JDBC
HTTP REST
InfluxDB Line Protocol (TCP/UDP)
JDBC
C++ API
Java API
HTTP API
Supported programming languagesClojure
Java
C
C++
Go info3rd party driver
Java
Python
R
Ruby info3rd party driver
C infoPostgreSQL driver
C++
Go
Java
JavaScript (Node.js)
Python
Rust infoover HTTP
C++
Java
C
C++
Go
Python
Server-side scripts infoStored proceduresyes infoTransaction Functionsnononono
TriggersBy using transaction functionsnononono
Partitioning methods infoMethods for storing different data on different nodesnone infoBut extensive use of caching in the application peersnonehorizontal partitioning (by timestamps)noneSharding
Replication methods infoMethods for redundantly storing data on multiple nodesnone infoBut extensive use of caching in the application peersnoneConfigurable consistency for N replicasnoneyes
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonononono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDACID for single-table writesyesno
Concurrency infoSupport for concurrent manipulation of datayesyes, multi-version concurrency control (MVCC)yesyesyes
Durability infoSupport for making data persistentyes infousing external storage systems (e.g. Cassandra, DynamoDB, PostgreSQL, Couchbase and others)yesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yes inforecommended only for testing and developmentyesyes infothrough memory mapped filesyesyes
User concepts infoAccess controlnononosimple rights management via user accounts
More information provided by the system vendor
DatomicDuckDBQuestDBRocksDBSiriDB
Specific characteristicsRelational model with native time series support Column based storage and time partitioned...
» more
Competitive advantagesReal-time data ingestion and istant SQL queries for time series High performance...
» more
Typical application scenariosApplication metrics Financial market data and algo trading DevOps monitoring Real-time...
» more
Licensing and pricing modelsApache 2.0.
» more
News

How we built a SIMD JIT compiler for SQL in QuestDB
12 January 2022

Our two-year journey to raise $15m in venture capital
3 January 2022

QuestDB 6.1.3 December release, Prometheus improvements
20 December 2021

Why I joined QuestDB as a core database engineer
9 November 2021

How we built inter-thread messaging from scratch
3 November 2021

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
DatomicDuckDBQuestDBRocksDBSiriDB
Recent citations in the news

Lucas Cavalcanti on Using Clojure, Microservices, Hexagonal Architecture and Public Cloud at Nubank
16 August 2021, InfoQ.com

Architecting Software for Leverage
13 November 2021, InfoQ.com

Brazil's Nubank Acquires US Software Firm Cognitect
30 July 2020, Nearshore Americas

Nubank buys firm behind Clojure programming language
28 July 2020, Finextra

Homoiconicity: It Is What It Is
31 October 2017, InfoQ.com

provided by Google News

New CWI spin-off company DuckDB Labs: Solutions for fast database analytics
14 July 2021, Centrum Wiskunde & Informatica (CWI)

Apache Arrow 6 Improves Support For R and Rust
22 November 2021, iProgrammer

Apache Arrow 5 Improves Asynchronous Scanner
16 August 2021, iProgrammer

Beyond the mainstream database offerings
26 March 2020, TechCentral.ie

4 predictions for open source in 2021
29 December 2020, IDG Connect

provided by Google News

QuestDB snares $12M Series A with hosted version coming soon
3 November 2021, TechCrunch

QuestDB Raises $12M in Series A Funding
8 November 2021, FinSMEs

Build a Real-time Stock Price Dashboard With Python, QuestDB and Plotly
6 November 2021, hackernoon.com

QuestDB nabs $2.3M seed to build open source time series database
2 July 2020, TechCrunch

Q&A: Nicolas Hourcard, QuestDB: The advantages of a time-series database
3 December 2020, Developer Tech

provided by Google News

Did Rockset Just Solve Real-Time Analytics?
25 August 2021, Datanami

Toshiba Memory America Optimizes RocksDB for SSDs
5 August 2019, Business Wire

Facebook Open Sources MyRocks DB Engine And ZStandard Compression Algorithm
3 September 2016, Fossbytes

provided by Google News

Job opportunities

Backend Software Engineer
Shortcut, New York State

Senior Backend Software Engineer
Shortcut, New York State

Backend Software Engineer
Shortcut Engineering, New York State

Senior Backend Software Engineer
Shortcut Engineering, New York State

Crypto Product Manager
Parkside, San Francisco, CA

Senior Data Engineer
Solidigm, Folsom, CA

Software Engineer
DataDog, New York, NY

Backend Engineer
KlearNow, United States

Software Engineer- Detections
DFLabs, Austin, TX

Software Development Manager III
Discovery, Inc., San Francisco, CA

Staff Software Engineer- Detections/Kafka Streams
DFLabs, Austin, TX

jobs by Indeed



Share this page

Featured Products

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 80GB free.

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started today.

Present your product here