ClickHouse, Inc. (github.com)

Article summary

The article appears to announce the formation of ClickHouse, Inc., a company related to the open-source column-oriented database management system ClickHouse. The discussion reveals that the ClickHouse website is blocked by some ad blockers due to an outdated entry in a blocklist. The blocklist entry has been removed, and the website is now accessible. The formation of ClickHouse, Inc. is expected to grow the adoption of ClickHouse and benefit the entire ecosystem.

Main themes

• ClickHouse, Inc.
• database management systems
• ad blockers
• GDPR and data deletion
• TimescaleDB and Citus comparison
• ClickHouse limitations and workarounds
• database ecosystem and adoption

What commenters say

• ClickHouse is a columnar, analytic database management system that is 100x-1000x faster than row stores for certain queries.
• The formation of ClickHouse, Inc. will help grow the adoption of ClickHouse and benefit the entire ecosystem, including companies that provide enterprise support for ClickHouse.
• ClickHouse has limitations, such as not allowing direct DELETE or UPDATE operations, which can pose problems for GDPR and data deletion requests.
• Some users have found workarounds for the DELETE limitation, such as using partitions or row-level encryption.
• ClickHouse is compared to other database management systems, such as TimescaleDB and Citus, with each having its own strengths and weaknesses.
• The asynchronous deletion mechanism in ClickHouse should be tested to verify its resource efficiency and ensure it does not trigger on every delete.
• ClickHouse has a great data warehousing story, but its timeseries and clustering stories are average or limited.