Clickhouse logo

Clickhouse

A column-oriented database management system
278
375
+ 1
58

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.
Clickhouse is a tool in the Databases category of a tech stack.

Who uses Clickhouse?

Companies
69 companies reportedly use Clickhouse in their tech stacks, including Groww, Postclick, and Avito.

Developers
203 developers on StackShare have stated that they use Clickhouse.

Clickhouse Integrations

dbt, Rudderstack, Percona Monitoring and Management, Sematext, and Ebean are some of the popular tools that integrate with Clickhouse. Here's a list of all 18 tools that integrate with Clickhouse.
Pros of Clickhouse
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

Jobs that mention Clickhouse as a desired skillset

See all jobs

Clickhouse Alternatives & Comparisons

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

Clickhouse's Followers
375 developers follow Clickhouse to keep up with related blogs and decisions.