Home
Application and Data
Data Stores
Databases

Clickhouse vs TiDB

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

Clickhouse
279
375
+ 1
58
TiDB
57
133
+ 1
16
Add tool

Clickhouse vs TiDB: What are the differences?

Developers describe Clickhouse as "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. On the other hand, TiDB is detailed as "A distributed NewSQL database compatible with MySQL protocol". Inspired by the design of Google F1, TiDB supports the best features of both traditional RDBMS and NoSQL.

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

TiDB is an open source tool with 20.1K GitHub stars and 2.92K GitHub forks. Here's a link to TiDB's open source repository on GitHub.

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

Get Advice from developers at your company using Private StackShare. Sign up for Private StackShare.
Learn More
Pros of Clickhouse
Pros of TiDB
  • 15
    Fast, very very fast
  • 10
    Good compression ratio
  • 5
    Horizontally scalable
  • 4
    RESTful
  • 4
    Utilizes all CPU resources
  • 4
    Great CLI
  • 3
    Has no transactions
  • 3
    Great number of SQL functions
  • 2
    Buggy
  • 2
    Open-source
  • 1
    Highly available
  • 1
    Flexible compression options
  • 1
    Server crashes its normal :(
  • 1
    ODBC
  • 1
    In IDEA data import via HTTP interface not working
  • 1
    Flexible connection options
  • 7
    Open source
  • 5
    Horizontal scalability
  • 3
    Strong ACID
  • 1
    HTAP

Sign up to add or upvote prosMake informed product decisions

Cons of Clickhouse
Cons of TiDB
  • 3
    Slow insert operations
    Be the first to leave a con

    Sign up to add or upvote consMake informed product decisions

    - No public GitHub repository available -

    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 TiDB?

    Inspired by the design of Google F1, TiDB supports the best features of both traditional RDBMS and NoSQL.

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

    Jobs that mention Clickhouse and TiDB as a desired skillset
    Software Engineer, Business Intelligence
    Pinterest
    Dublin, IE
    View Job Details
    DreamPrestoTableau+5
    University Grad Machine Learning Engineer - MASTERS ONLY (USA)
    Pinterest
    San Francisco, CA, US; Palo Alto, CA, US
    View Job Details
    DreamCollectScope+8
    Staff Software Engineer, Ads Infrastructure
    Pinterest
    San Francisco, CA, US
    View Job Details
    DreamPyTorchVitess+9
    Staff Software Engineer, Ads Infrastructure
    Pinterest
    San Francisco, CA, US
    View Job Details
    DreamPyTorchVitess+9
    Staff Software Engineer, Ads Infrastructure
    Pinterest
    San Francisco, CA, US
    View Job Details
    DreamPyTorchVitess+9
    Software Engineer, Stream Processing Platform
    Pinterest
    Palo Alto, CA, US
    View Job Details
    DreamApache FlinkSamza+11
    Software Engineer, Stream Processing Platform
    Pinterest
    Palo Alto, CA, US
    View Job Details
    DreamApache FlinkSamza+11
    Software Engineer, Signal Delivery
    Pinterest
    Toronto, ON, CA
    View Job Details
    DreamApache FlinkKafka+7
    What companies use Clickhouse?
    What companies use TiDB?
    See which teams inside your own company are using Clickhouse or TiDB.
    Sign up for Private StackShareLearn More

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

    What tools integrate with Clickhouse?
    What tools integrate with TiDB?

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

    What are some alternatives to Clickhouse and TiDB?
    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

    PostgreSQL vs TiDBMongoDB vs TiDBFoundationDB vs TiDBMySQL vs TiDBMariaDB vs TiDB

    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

    Bootstrap vs MaterializePostman vs Swagger UIHipChat vs Mattermost vs SlackBitbucket vs GitHub vs GitLab