Need advice about which tool to choose?Ask the StackShare community!
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.
Pros of Clickhouse
- Fast, very very fast15
- Good compression ratio10
- Horizontally scalable5
- RESTful4
- Utilizes all CPU resources4
- Great CLI4
- Has no transactions3
- Great number of SQL functions3
- Buggy2
- Open-source2
- Highly available1
- Flexible compression options1
- Server crashes its normal :(1
- ODBC1
- In IDEA data import via HTTP interface not working1
- Flexible connection options1
Pros of TiDB
- Open source7
- Horizontal scalability5
- Strong ACID3
- HTAP1
Sign up to add or upvote prosMake informed product decisions
Cons of Clickhouse
- Slow insert operations3