DB-EnginesExtremeDB for everyone with an RTOSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > ClickHouse vs. CockroachDB vs. EXASOL vs. FeatureBase vs. FileMaker

System Properties Comparison ClickHouse vs. CockroachDB vs. EXASOL vs. FeatureBase vs. FileMaker

Editorial information provided by DB-Engines
NameClickHouse  Xexclude from comparisonCockroachDB  Xexclude from comparisonEXASOL  Xexclude from comparisonFeatureBase  Xexclude from comparisonFileMaker  Xexclude from comparison
DescriptionA high-performance, column-oriented SQL DBMS for online analytical processing (OLAP) that uses all available system resources to their full potential to process each analytical query as fast as possible. It is available as both an open-source software and a cloud offering.CockroachDB is a distributed database architected for modern cloud applications. It is wire compatible with PostgreSQL and backed by a Key-Value Store, which is either RocksDB or a purpose-built derivative, called Pebble.High-performance, in-memory, MPP database specifically designed for in-memory analytics.Real-time database platform that powers real-time analytics and machine learning applications by simultaneously executing low-latency, high-throughput, and highly concurrent workloads.FileMaker is a cross-platform RDBMS that includes a GUI frontend.
Primary database modelRelational DBMSRelational DBMSRelational DBMSRelational DBMSRelational DBMS
Secondary database modelsTime Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score15.55
Rank#38  Overall
#23  Relational DBMS
Score5.73
Rank#58  Overall
#34  Relational DBMS
Score1.76
Rank#139  Overall
#62  Relational DBMS
Score0.31
Rank#292  Overall
#135  Relational DBMS
Score47.91
Rank#20  Overall
#14  Relational DBMS
Websiteclickhouse.comwww.cockroachlabs.comwww.exasol.comwww.featurebase.comwww.claris.com/­filemaker
Technical documentationclickhouse.com/­docswww.cockroachlabs.com/­docswww.exasol.com/­resourcesdocs.featurebase.comwww.claris.com/­resources/­documentation
DeveloperClickhouse Inc.Cockroach LabsExasolMolecula and Pilosa Open Source ContributorsClaris infoa subsidiary of Apple
Initial release20162015200020171983
Current releasev24.4.1.2088-stable, May 202424.1.0, May 20242022, May 202219.4.1, November 2021
License infoCommercial or Open SourceOpen Source infoApache 2.0Open Source infoApache 2.0, commercial license availablecommercialcommercialcommercial
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.
  • Aiven for Clickhouse: Managed cloud data warehousing with high-speed analytics.
  • DoubleCloud: Fully managed ClickHouse alongside best-in-class managed open-source services to build analytics at scale.
  • ClickHouse Cloud: Get the performance you love from open source ClickHouse in a serverless offering that takes care of the details so you can spend more time getting insight out of the fastest database on earth.
Implementation languageC++GoGo
Server operating systemsFreeBSD
Linux
macOS
Linux
macOS
Windows
Linux
macOS
iOS infoclient part only
Linux
OS X
Windows
Data schemeyesdynamic schemayesyesyes
Typing infopredefined data types such as float or dateyesyesyesyesyes
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.nonononoyes infoA http query request can return the data in XML format
Secondary indexesyesyesyesnoyes
SQL infoSupport of SQLClose to ANSI SQL (SQL/JSON + extensions)yes, wire compatible with PostgreSQLyesSQL queriesyes infovia plugins
APIs and other access methodsgRPC
HTTP REST
JDBC
MySQL wire protocol
ODBC
PostgreSQL wire protocol
Proprietary protocol
JDBC.Net
JDBC
ODBC
WebSocket
gRPC
JDBC
Kafka Connector
ODBC
Filemaker WebDirect
JDBC
ODBC
Supported programming languagesC# 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
Rust
Scala info3rd party library
C#
C++
Clojure
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Rust
Java
Lua
Python
R
Java
Python
PHP
Server-side scripts infoStored proceduresyesnouser defined functionsyes
Triggersnonoyesnoyes
Partitioning methods infoMethods for storing different data on different nodeskey based and customhorizontal partitioning (by key range) infoall tables are translated to an ordered KV store and then broken down into 64MB ranges, which are then used as replicas in RAFTShardingShardingnone
Replication methods infoMethods for redundantly storing data on multiple nodesAsynchronous and synchronous physical replication; geographically distributed replicas; support for object storages.Multi-source replication using RAFTyesSource-replica replication, warm standby infosince Version 14
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyes infoHadoop integrationno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesyesyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDACIDyesno
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes, using Linux fsyncyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnoyesyes
User concepts infoAccess controlAccess rights for users and roles. Column and row based policies. Quotas and resource limits. Pluggable authentication with LDAP and Kerberos. Password based, X.509 certificate, and SSH key authentication.Role-based access controlAccess rights for users, groups and roles according to SQL-standardsimple rights management via user accounts and connection to external directory services

More information provided by the system vendor

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
3rd partiesAiven for Clickhouse: Managed cloud data warehousing with high-speed analytics.
» more

DoubleCloud: Fully managed ClickHouse alongside best-in-class managed open-source services to build analytics at scale.
» more

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

More resources
ClickHouseCockroachDBEXASOLFeatureBaseFileMaker
Recent citations in the news

Why Clickhouse Should Be Your Next Database
6 July 2023, The New Stack

ClickHouse Cloud & Amazon S3 Express One Zone: Making a blazing fast analytical database even faster | Amazon ...
28 November 2023, AWS Blog

Intel Xeon 6766E/6780E Sierra Forest vs. Ampere Altra Performance & Power Efficiency Review
5 June 2024, Phoronix

A 1000x Faster Database Solution: ClickHouse’s Aaron Katz
1 November 2023, GrowthCap

From Open Source to SaaS: the Journey of ClickHouse
16 January 2024, InfoQ.com

provided by Google News

Cockroach Labs Deepens Partnership with Google Cloud, CockroachDB Selected to Join Google Distributed Cloud
9 April 2024, PR Newswire

CockroachDB tempts legacy databases to crawl into the cloud age
29 January 2024, The Register

How DoorDash Migrated from Aurora Postgres to CockroachDB
5 December 2023, The New Stack

DoorDash Uses CockroachDB to Create Config Management Platform for Microservices
14 February 2024, InfoQ.com

How to Unlock Real-Time Data Streams with CockroachDB and Amazon MSK | Amazon Web Services
6 November 2023, AWS Blog

provided by Google News

It's Back to the Database Future for Exasol CEO Tewes
26 October 2023, Datanami

Exasol Finds AI Underinvestment Leads to Business Failure, But Data Challenges Stall Rapid Adoption
20 March 2024, Business Wire

Exasol gets jolt of AI with Espresso suite of capabilities
26 February 2024, TechTarget

Mathias Golombek, Chief Technology Officer of Exasol – Interview Series
21 May 2024, Unite.AI

Exasol Unveils New Suite of AI Tools to Turbocharge Enterprise Data Analytics
22 February 2024, AiThority

provided by Google News

Get Your Infrastructure Ready for Real-Time Analytics
9 March 2022, Built In

Pilosa: A Scalable High Performance Bitmap Database Index
17 June 2019, hackernoon.com

The 10 Coolest Big Data Tools Of 2021
7 December 2021, CRN

32 Data and Analytics Startups That Will Go Big, According to VCs
28 September 2021, Business Insider

provided by Google News

Reviews - Features
1 March 2024, Reverse Shot

New customizable ERP platform based on Claris FileMaker released
11 June 2024, openPR

Tilda Swinton on 'Problemista' Fan Horror Stories About Her Character
1 March 2024, IndieWire

Apple Subsidiary to Face Worker's Job Loss Claims, but Not Apple
14 February 2024, Bloomberg Law

Apple Filed for new Trademarks in the U.S. and Hong Kong this week for the Figurative Version of 'Reality Composer ...
15 October 2023, Patently Apple

provided by Google News



Share this page

Featured Products

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Neo4j logo

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

Present your product here