Clickhouse logo

Clickhouse

A column-oriented database management system
125
149
+ 1
40

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
34 companies reportedly use Clickhouse in their tech stacks, including bigin, useinsider, and Avito.

Developers
89 developers on StackShare have stated that they use Clickhouse.
Public Decisions about Clickhouse

Here are some stack decisions, common use cases and reviews by companies and developers who chose Clickhouse in their tech stack.

Shared insights
on
ClickhouseClickhouse
at

In today’s technology, there are thousands and millions of data streams per second. Everything is now done digitally, including smartphones, smartwatches, wristbands, beacon technologies, money transfers, and millions of data as a result of this digitalization.

In solutions with legacy databases, growing data increased the processing power of the servers, and increased computing power resulted in more servers, more space, and more cost. As this problem required a solution, methods of approach to the database have also changed.

At this stage, there has been a change in the way we access stored data (access through more than one layer – cache mechanisms). It created the need for the development of immediate solutions for data storage and improvements to ensure continuous access. Eventually, some new systems have been developed to store the data with different methods, enabling quicker access through various layers.

When we started experiencing problems with understanding the data, storing it according to its content, accessing it, and doing all these instantaneously for millions of data, Clickhouse emerged as the solution of many of our problems.

Please read our blog post for more details.

See more

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
149 developers follow Clickhouse to keep up with related blogs and decisions.
Umang Dhiman
Prakshi Yadav
谷歌 宋
Albert Maranian Jr.
Ilia Mikhailov
Pavel Savelyev
Vunene Maboya
Виктор Носенко
Lucas Porto
Thierry Hanot