ClickHouse Reviews

I used ClickHouse to collect data, put it in the database, and then analyze it to find insights. The main advantage is that I can install it on my computer instead of using cloud-based solutions, so I don't have to pay for every query like with Google or Amazon cloud services.

The best thing about the tool is that I can set it up on my computer and run queries without depending on the cloud. This is why I use it every day.

Our company had about nine platforms, each with its own database and data. We had to gather all these data in one database and just one table. We used Apache Superset to integrate this database with the business intelligence tool. We had too many choices or options initially for the database engine.

We initially tested a database, and its performance was good. When we tried ClickHouse, we switched to it immediately because the performance was really amazing. When we had a huge amount of data, about five or six gigabytes in just one table, and we used ClickHouse to deduplicate some duplicated entries or records.

Clickhouse helped us to achieve our use cases with simple steps and good performance as mentioned previously

I use ClickHouse to collect and analyze data from Ethereum. We primarily use it for data classification and occasionally for machine learning with GPT, but that's minimal. The primary use case is classification; sometimes, we use it for applications similar to OLTP scenarios. All of our data is stored in ClickHouse. We are customers of ClickHouse, not partners. It's an easy tool to use if you know SQL databases.

The aggregation capability is a valuable feature. It's highly efficient, allowing us to review entire transaction histories and user activities in the market. We've tried MongoDB, Postgres, MariaDB, and BigQuery, but ClickHouse is the most cost-efficient solution for collecting data at high speeds with minimal cost. We even used ClickHouse Cloud for a month, and it proved to be a great setup, especially for startups looking to handle big data. For example, if there is a need for 2-4 terabytes of data and around 40 billion rows with reasonable computing speed and latency, ClickHouse is ideal.

Regarding the real-time query performance of ClickHouse, when using an API server to query it, I achieved query results in less than twenty milliseconds in some of my experiments with one billion rows. However, it depends on the scenario since ClickHouse has limitations in handling mutations. 

Additionally, one of ClickHouse's strengths is its compression capability. Our experimental server has only four terabytes, and ClickHouse effectively compresses data, allowing us to store large amounts of data at high speed. This compression efficiency is a significant advantage of using ClickHouse.

We use the solution not just as an analytics database but also as a data warehouse. A lot of our internal services communicate with the tool. Our analytics and ML teams also use the solution. It's the hub of our company.

It's easier to work with big data and calculations using the product. For example, we can easily calculate metrics around terabytes of data using ClickHouse. The dictionaries help us to make our analysts’ jobs faster and easier and give value to the business faster.

Our use cases are for data analytics, both real-time and batch, and also for logging Clickstream data.

We use it in our organization. We have it in our production environment.

The query engine is super fast. We deploy ClickHouse on our Kubernetes cluster, not as a cloud subscription, so it's easy to scale with the deployment.

We use it to store live data and for tracking and monitoring every action on a PC, like which websites are opened, through Kubernetes and Google Chrome. Data is sent every second from ActiveMQ, and ClickHouse can insert millions of data points per millisecond.

ClickHouse is much faster than traditional databases like MySQL and MongoDB. Its column-row searching strategy makes it very efficient. With ClickHouse, we can manage multiple databases, automatically insert data from other databases and delete data as needed. It supports real-time query performance, allowing simultaneous data insertion and retrieval. ClickHouse has improved significantly over the past two years, adding more functions and queries, as well as top functionality.

During my experience Clickhouse was used primary for companies analytics. At the same time I had a chance to apply it for various other use-case, such as log and storage metrics, Clickhouse as an ETL engine, monitorin, alerting and many more