Blog

Articles and updates

Optimizing ClickHouse Queries: Adding and Benchmarking Projections

Learn how to optimize ClickHouse queries by adding and benchmarking projections with before-and-after performance comparisons.

Reshma MMarch 10, 20265 min read
clickhouseperformancebenchmarking performance

Operating ClickHouse on Kubernetes

Learn why running ClickHouse on Kubernetes requires the Altinity Operator, and why StatefulSets alone are not enough for production clusters.

Sanjeev Kumar GMarch 10, 20266 min read
clickhousekubernetesperformance

Massive Tech Vendor Breach Exposes 25 Million People and Raises Global Cybersecurity Alarm

A tech vendor data breach exposed 25 million users’ personal data, highlighting rising cybersecurity threats, supply chain risks, and privacy concerns.

Kanishga SubramaniMarch 7, 20264 min read
aiprivacycloud security

Lightweight Delete in ClickHouse®

Learn how Lightweight DELETE works in ClickHouse®, including its internal masking mechanism, background merges, performance trade-offs, limitations, and when to

Sanjeev Kumar GFebruary 28, 20264 min read
clickhouseperformanceclickhouse internals

Data Disaster: How a Single Telecom Hack Put Millions at Risk

A breach at Odido exposed millions of sensitive data, raising serious concerns about cybersecurity, identity theft, and digital privacy.

Kanishga SubramaniFebruary 28, 20264 min read
aiprivacydata breach

ClickHouse® table-scoped replication architecture

Explore ClickHouse table-scoped replication architecture and its distributed coordination model for scalable analytical systems.

Mohamed Hussain SFebruary 24, 20265 min read
clickhousedata replicationdistributed systems

When Should High-Cardinality Columns Come First in ClickHouse ORDER BY?

Learn when high-cardinality columns improve ClickHouse ORDER BY performance and how to choose correctly.

Mohamed Hussain SFebruary 19, 20265 min read
clickhouseperformanceanalytics databases

Privacy Collapse: The Spyware Scandal That Revealed a Hidden Digital Underworld

A major data leak at Struktura exposed sensitive user and surveillance data, sparking global debates about spyware risks,and digital privacy.

Kanishga SubramaniFebruary 19, 20264 min read
aiprivacycybersecurity

Google’s Personal Intelligence: AI Personalization vs Privacy Risks

Google’s Personal Intelligence feature delivers personalized responses using user data, raising both convenience and privacy concerns.

Kanishga SubramaniFebruary 18, 20264 min read
aiprivacy

Date Partitioning Strategies for High-Performance ClickHouse Queries

ClickHouse date partitioning strategies to improve query performance, enable partition pruning, and efficiently manage large time-based data.

GayathriFebruary 11, 20267 min read
clickhouseperformancesql