DB-EnginesInfluxDB download bannerEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > BoltDB vs. ClickHouse vs. SAP SQL Anywhere vs. TimescaleDB

System Properties Comparison BoltDB vs. ClickHouse vs. SAP SQL Anywhere vs. TimescaleDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameBoltDB  Xexclude from comparisonClickHouse  Xexclude from comparisonSAP SQL Anywhere infoformerly called Adaptive Server Anywhere  Xexclude from comparisonTimescaleDB  Xexclude from comparison
DescriptionAn embedded key-value store for Go.Column-oriented Relational DBMS powering YandexRDBMS database and synchronization technologies for server, desktop, remote office, and mobile environmentsA time series DBMS optimized for fast ingest and complex queries, based on PostgreSQL
Primary database modelKey-value storeRelational DBMSRelational DBMSTime Series DBMS
Secondary database modelsRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.64
Rank#209  Overall
#36  Key-value stores
Score6.60
Rank#58  Overall
#32  Relational DBMS
Score6.79
Rank#54  Overall
#31  Relational DBMS
Score2.73
Rank#105  Overall
#6  Time Series DBMS
Websitegithub.com/­boltdb/­boltclickhouse.techwww.sap.com/­products/­sql-anywhere.htmlwww.timescale.com
Technical documentationclickhouse.tech/­docshelp.sap.com/­sql-anywheredocs.timescale.com
DeveloperYandex LLCSAP infoformerly SybaseTimescale
Initial release2013201619922017
Current releasev20.3.17.173, August 202017, July 2015
License infoCommercial or Open SourceOpen Source infoMIT LicenseOpen Source infoApache 2.0commercialOpen Source infoApache 2.0
Cloud-based only infoOnly available as a cloud servicenononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageGoC++C
Server operating systemsBSD
Linux
OS X
Solaris
Windows
FreeBSD
Linux
macOS
AIX
HP-UX
Linux
OS X
Solaris
Windows
Linux
OS X
Windows
Data schemeschema-freeyesyesyes
Typing infopredefined data types such as float or datenoyesyesnumerics, strings, booleans, arrays, JSON blobs, geospatial dimensions, currencies, binary data, other complex data types
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.nonoyesyes
Secondary indexesnonoyesyes
SQL infoSupport of SQLnoClose to ANSI SQLyesyes infofull PostgreSQL SQL syntax
APIs and other access methodsHTTP REST
JDBC
ODBC
Proprietary protocol
ADO.NET
HTTP API
JDBC
ODBC
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
Supported programming languagesGoC# info3rd party library
C++
Elixir info3rd party library
Go info3rd party library
Java info3rd party library
JavaScript (Node.js) info3rd party library
Kotlin info3rd party library
Nim info3rd party library
Perl info3rd party library
PHP info3rd party library
Python info3rd party library
R info3rd party library
Ruby info3rd party library
Scala info3rd party library
C
C#
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
.Net
C
C++
Delphi
Java infoJDBC
JavaScript
Perl
PHP
Python
R
Ruby
Scheme
Tcl
Server-side scripts infoStored proceduresnonoyes, in C/C++, Java, .Net or Perluser defined functions, PL/pgSQL, PL/Tcl, PL/Perl, PL/Python, PL/Java, PL/PHP, PL/R, PL/Ruby, PL/Scheme, PL/Unix shell
Triggersnonoyesyes
Partitioning methods infoMethods for storing different data on different nodesnonenoneyes, across time and space (hash partitioning) attributes
Replication methods infoMethods for redundantly storing data on multiple nodesnoneSource-replica replication infoDatabase mirroringSource-replica replication with hot standby and reads on replicas info
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datayesnoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesyesno
User concepts infoAccess controlnoAccess rights for users and rolesfine grained access rights according to SQL-standardfine grained access rights according to SQL-standard
More information provided by the system vendor
BoltDBClickHouseSAP SQL Anywhere infoformerly called Adaptive Server AnywhereTimescaleDB
Specific characteristicsTimescale is the creator of TimescaleDB , the first open-source relational database...
» more
Competitive advantagesTimescaleDB is purpose-built to scale and handle time-series data workloads and is...
» more
Typical application scenariosDevOps and Infrastructure Monitoring All monitoring data is time-series data. Efficiently...
» more
Key customersTransferWise, Maersk, AppDynamics, Walmart, Comcast, LaunchDarkly, IBM, NOV, Cisco,...
» more
Market metricsWith over 9,000 GitHub stars and growing, 600,000 active databases, and an active...
» more
Licensing and pricing modelsTimescaleDB comes in 3 versions, including fully managed Cloud-hosted solutions*,...
» more

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
BoltDBClickHouseSAP SQL Anywhere infoformerly called Adaptive Server AnywhereTimescaleDB
Recent citations in the news

Software AG – The Daily Chronicle
10 September 2020, The Daily Chronicle

Key Value Database Market likely to touch new heights by end of forecast period
6 August 2020, News by aeresearch

Key Value Database Market Analysis & Technological Innovation by Leading Key Pla
11 August 2020, News.MarketSizeForecasters.com

Gartner Names Demisto 'Cool Vendor' in Security Ops & Vulnerability Mgt
15 May 2018, 107.180.56.147

Automate easier and build pipelines in Gaia
12 July 2018, JAXenter

provided by Google News

How Snowflake raised $3bn in a record software IPO
15 September 2020, The Economist

From Russia with OLAP: Percona uses ClickHouse analytics
10 October 2019, ComputerWeekly.com

ClickHouse - from website clicks to ultra-fast analytics solution -
27 April 2020, Enterprise Times

ClickHouse Experiencing Explosive Growth in EU, US and Asia in Q1 2018
23 April 2018, PR Newswire

Snowflake May Melt Before Your Eyes
18 September 2020, Seeking Alpha

provided by Google News

SAP SQL Anywhere
13 October 2016, TechTarget

SAP gives SQL Anywhere a new IoT injection
16 July 2015, Computerworld

Best Database Management Software 2020
14 July 2020, Datamation

Rimini Street expands support beyond SAP and Oracle
9 June 2017, Inside SAP Magazine

SAP IoT products: How do they work with ERP and big data?
28 December 2015, TechTarget

provided by Google News

TimescaleDB Delivers Another Option for Time-Series Analytics
17 October 2019, Datanami

Timescale Brings Powerful Time-Series Data Analysis to Developers Worldwide, Now Available in 75+ Cloud Regions
12 August 2020, Business Wire

Database Heterogeneity Helps Address IoT Analytics Challenges
22 September 2020, IoT World Today

Timescale Database Now Available in 76 Cloud Regions
12 August 2020, Datanami

The First Complete Life-Cycle Database Management Solution for TimescaleDB
16 April 2019, PRNewswire

provided by Google News

Job opportunities

MySQL Consultant
Percona, Remote

Sr. Timestream Specialist SA
Amazon Web Services, Inc., New York, NY

Systems Engineer - Database
Cloudflare, Austin, TX

DevOps Engineer
Yotascale, San Francisco Bay Area, CA

Senior Software Engineer at Databento
Databento, Boston, MA

Software Engineers Multiple Levels – Cloud Infrastructure Predictive Analytics
PCI, Fort Meade, MD

Hydrological Software Engineer
University of Massachusetts Amherst, Amherst, MA

Software Engineer Cloud Analytics
PCI, Fort Meade, MD

Systems Reliability Engineer
PacketFabric, Culver City, CA

Automation Developer / DevOps Engineer
NVIDIA, Santa Clara, CA

jobs by Indeed




Share this page

Featured Products

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

Datastax Astra logo

Cassandra made easy in the cloud. Build cloud-native applications faster with CQL, REST and GraphQL APIs.
Try for Free.

Couchbase logo

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

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!

Present your product here