Home
Application and Data
Data Stores
Databases

Clickhouse vs RethinkDB

Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Clickhouse
418
531
+ 1
85
RethinkDB
299
406
+ 1
307
Add tool

Clickhouse vs RethinkDB: What are the differences?

What is Clickhouse? A column-oriented database management system. It allows analysis of data that is updated in real time. It offers instant results in most cases: the data is processed faster than it takes to create a query.

What is RethinkDB? JSON. Scales to multiple machines with very little effort. Open source. RethinkDB is built to store JSON documents, and scale to multiple machines with very little effort. It has a pleasant query language that supports really useful queries like table joins and group by, and is easy to setup and learn.

Clickhouse and RethinkDB can be primarily classified as "Databases" tools.

RethinkDB is an open source tool with 22.5K GitHub stars and 1.75K GitHub forks. Here's a link to RethinkDB's open source repository on GitHub.

According to the StackShare community, RethinkDB has a broader approval, being mentioned in 53 company stacks & 166 developers stacks; compared to Clickhouse, which is listed in 22 company stacks and 11 developer stacks.

Manage your open source components, licenses, and vulnerabilities
Learn More
Pros of Clickhouse
Pros of RethinkDB
  • 21
    Fast, very very fast
  • 11
    Good compression ratio
  • 7
    Horizontally scalable
  • 6
    Utilizes all CPU resources
  • 5
    RESTful
  • 5
    Open-source
  • 5
    Great CLI
  • 4
    Great number of SQL functions
  • 4
    Buggy
  • 3
    Server crashes its normal :(
  • 3
    Highly available
  • 3
    Flexible connection options
  • 3
    Has no transactions
  • 2
    ODBC
  • 2
    Flexible compression options
  • 1
    In IDEA data import via HTTP interface not working
  • 48
    Powerful query language
  • 46
    Excellent dashboard
  • 42
    JSON
  • 41
    Distributed database
  • 38
    Open source
  • 25
    Reactive
  • 16
    Atomic updates
  • 15
    Joins
  • 9
    MVCC concurrency
  • 9
    Hadoop-style map/reduce
  • 4
    Geospatial support
  • 4
    Real-time, open-source, scalable
  • 2
    YC Company
  • 2
    A NoSQL DB with joins
  • 2
    Great Admin UI
  • 2
    Changefeeds: no polling needed to get updates
  • 2
    Fast, easily scalable, great customer support

Sign up to add or upvote prosMake informed product decisions

Cons of Clickhouse
Cons of RethinkDB
  • 5
    Slow insert operations
    Be the first to leave a con

    Sign up to add or upvote consMake informed product decisions

    117
    2K
    5.1K
    1.4K
    1.4K
    - No public GitHub repository available -
    26.9K
    1.9K
    6y

    What is Clickhouse?

    It allows analysis of data that is updated in real time. It offers instant results in most cases: the data is processed faster than it takes to create a query.

    What is RethinkDB?

    RethinkDB is built to store JSON documents, and scale to multiple machines with very little effort. It has a pleasant query language that supports really useful queries like table joins and group by, and is easy to setup and learn.

    Need advice about which tool to choose?Ask the StackShare community!

    Jobs that mention Clickhouse and RethinkDB as a desired skillset
    Manager I, Site Reliability Engineering
    Pinterest
    San Francisco, CA, US; , CA, US
    View Job Details
    DreamLinuxEnvoy+18
    Manager I, Site Reliability Engineering
    Pinterest
    San Francisco, CA, US; , CA, US
    View Job Details
    DreamLinuxEnvoy+18
    Senior Software Engineer, Big Data
    Pinterest
    San Francisco, CA, US; , CA, US
    View Job Details
    DreamTrinoAirflow+11
    Staff Software Engineer - Site Reliability
    Pinterest
    Toronto, ON, CA
    View Job Details
    SpeedDreamLinux+20
    Staff Software Engineer - Site Reliability
    Pinterest
    Toronto, ON, CA
    View Job Details
    SpeedDreamLinux+20
    Staff Software Engineer - Site Reliability
    Pinterest
    Toronto, ON, CA
    View Job Details
    SpeedDreamLinux+20
    Sr. Machine Learning Engineer
    Pinterest
    Toronto, ON, CA
    View Job Details
    DreamHadoop+2
    Staff Software Engineer, Ads Serving Platform
    Pinterest
    San Francisco, CA, US; , US
    View Job Details
    guidanceInfraDream+9
    What companies use Clickhouse?
    What companies use RethinkDB?
    Manage your open source components, licenses, and vulnerabilities
    Learn More

    Sign up to get full access to all the companiesMake informed product decisions

    What tools integrate with Clickhouse?
    What tools integrate with RethinkDB?

    Sign up to get full access to all the tool integrationsMake informed product decisions

    What are some alternatives to Clickhouse and RethinkDB?
    Cassandra
    Partitioning means that Cassandra can distribute your data across multiple machines in an application-transparent matter. Cassandra will automatically repartition as machines are added and removed from the cluster. Row store means that like relational databases, Cassandra organizes data by rows and columns. The Cassandra Query Language (CQL) is a close relative of SQL.
    Elasticsearch
    Elasticsearch is a distributed, RESTful search and analytics engine capable of storing data and searching it in near real time. Elasticsearch, Kibana, Beats and Logstash are the Elastic Stack (sometimes called the ELK Stack).
    MySQL
    The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
    InfluxDB
    InfluxDB is a scalable datastore for metrics, events, and real-time analytics. It has a built-in HTTP API so you don't have to write any server side code to get up and running. InfluxDB is designed to be scalable, simple to install and manage, and fast to get data in and out.
    Druid
    Druid is a distributed, column-oriented, real-time analytics data store that is commonly used to power exploratory dashboards in multi-tenant environments. Druid excels as a data warehousing solution for fast aggregate queries on petabyte sized data sets. Druid supports a variety of flexible filters, exact calculations, approximate algorithms, and other useful calculations.
    See all alternatives

    Related Comparisons

    MongoDB vs RethinkDBCouchDB vs MongoDB vs RethinkDBMySQL vs RethinkDBMongoDB vs PostgreSQL vs RethinkDBMongoDB vs MySQL vs RethinkDB

    Trending Comparisons

    Django vs Laravel vs Node.jsBootstrap vs Foundation vs Material-UINode.js vs Spring BootFlyway vs LiquibaseAWS CodeCommit vs Bitbucket vs GitHub

    Top Comparisons

    Postman vs Swagger UIHipChat vs Mattermost vs SlackBitbucket vs GitHub vs GitLabBootstrap vs Materialize