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 > QuestDB vs. Spark SQL vs. STSdb

System Properties Comparison QuestDB vs. Spark SQL vs. STSdb

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameQuestDB  Xexclude from comparisonSpark SQL  Xexclude from comparisonSTSdb  Xexclude from comparison
DescriptionA high performance open source SQL database for time series dataSpark SQL is a component on top of 'Spark Core' for structured data processingKey-Value Store with special method for indexing infooptimized for high performance using a special indexing method
Primary database modelTime Series DBMSRelational DBMSKey-value store
Secondary database modelsRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.61
Rank#222  Overall
#15  Time Series DBMS
Score21.39
Rank#34  Overall
#20  Relational DBMS
Score0.18
Rank#297  Overall
#43  Key-value stores
Websitequestdb.iospark.apache.org/­sqlgithub.com/­STSSoft/­STSdb4
Technical documentationquestdb.io/­docs/­introductionspark.apache.org/­docs/­latest/­sql-programming-guide.html
DeveloperQuestDB LimitedApache Software FoundationSTS Soft SC
Initial release201420142011
Current release3.1.1, March 20214.0.8, September 2015
License infoCommercial or Open SourceOpen Source infoApache 2.0Open Source infoApache 2.0Open Source infoGPLv2, commercial license available
Cloud-based only infoOnly available as a cloud servicenonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaScalaC#
Server operating systemsLinux
macOS
Windows
Linux
OS X
Windows
Windows
Data schemeyes infoschema-free via InfluxDB Line Protocolyesyes
Typing infopredefined data types such as float or dateyesyesyes infoprimitive types and user defined types (classes)
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.nono
Secondary indexesnonono
SQL infoSupport of SQLSQL-like query languageSQL-like DML and DDL statementsno
APIs and other access methodsHTTP REST
InfluxDB Line Protocol (TCP/UDP)
JDBC
JDBC
ODBC
.NET Client API
Supported programming languagesC infoPostgreSQL driver
C++
Go
Java
JavaScript (Node.js)
Python
Rust infoover HTTP
Java
Python
R
Scala
C#
Java
Server-side scripts infoStored proceduresnonono
Triggersnonono
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioning (by timestamps)yes, utilizing Spark Corenone
Replication methods infoMethods for redundantly storing data on multiple nodesConfigurable consistency for N replicasnonenone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency
Foreign keys infoReferential integritynonono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACID for single-table writesnono
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yes infothrough memory mapped filesno
User concepts infoAccess controlnono
More information provided by the system vendor
QuestDBSpark SQLSTSdb
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

QuestDB 6.0.4 July release, Prometheus metrics support
16 July 2021

How databases handle 10 million devices in high-cardinality benchmarks
16 June 2021

How we achieved write speeds of 1.4 million rows per second
10 May 2021

QuestDB version 6.0 alpha
20 April 2021

QuestDB release January 2021
5 February 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
QuestDBSpark SQLSTSdb
Recent citations in the news

QuestDB has built a lightning fast time series database. Can it build a business to match?
16 February 2021, TechRepublic

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

Open-source growth and venture capital investment: Data, databases, challenges, and opportunities
7 July 2021, ZDNet

Altinity grabs $4M seed to build cloud version of ClickHouse open-source data warehouse
1 October 2020, TechCrunch

provided by Google News

2015 - Spark Takes the Big Data World by Storm
1 July 2021, Datanami

Beginner's Guide To Machine Learning With Apache Spark
16 July 2021, Analytics India Magazine

Microsoft : Accelerate big data analytics with Spark 3.0 connector for SQL Server—now generally available
13 July 2021, marketscreener.com

Start artificial intelligence for IoT in bite-size pieces
15 July 2021, TechTarget

IBM Expands Access and Value of z Systems Mainframe Data with Apache Spark – FINCHANNEL
31 March 2016, The FINANCIAL

provided by Google News

Job opportunities

Sr. SSIS package/ SQL developers
Intone Networks, Boston, MA

Backline Spark TSE
Databricks, Remote

AWS Data Lake Big Data Engineer - Spark SQL, Data Steward, Scala, Terraform, Data Bricks
Nasdaq, Inc., Rockville, MD

DataBricks/Spark Engineer
Bigbear.ai, McLean, VA

Senior Data Engineer - Scala/Spark/SQL
Hewlett Packard Enterprise, San Jose, CA

jobs by Indeed



Share this page

Featured Products

Vertica logo

The fastest unified analytical warehouse at extreme scale with in-database machine learning. Try Vertica for free with no time limit.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

Neo4j logo

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

Datastax Astra logo

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

Present your product here