Snowflake is now the most popular SQL data warehouse according to the influential DB Engines site. That said, ClickHouse is catching up rapidly and is now the leading open source competitor. ClickHouse offers consistent low latency response, freedom to run anywhere, and outstanding cost efficiency. …

As countless ClickHouse users have learned, Kubernetes is a great platform for data. It’s portable to almost every IT environment. Managed Kubernetes services like Amazon EKS simplify operation. And the Altinity Kubernetes Operator for ClickHouse lets you start complex ClickHouse clusters from a single resource file. But there’s still the…

A few weeks ago the SingleStore team published interesting research in their blog. They demonstrated how to load 100 billion rows in a database in 10 minutes. …

Written with Lead Support Engineer Mikhail Filimonov. And in such indices, although small pricks To their subsequent volumes, there is seen The baby figure of the giant mass Of things to come at large. -William Shakespeare ClickHouse indices are different from traditional relational database management systems (RDMS) in that: Primary…

If you are a technical person and use a Mac, it is virtually a given that the first thing you do on a fresh machine is install the Homebrew package manager. Nearly everything that is available through Homebrew can be installed manually by building from sources or just unpacking the…

There’s no better place to learn about databases on the web than the awesome CMU Database Group YouTube channel maintained by Andy Pavlo. Fall 2021 was no exception with the Vaccination Database Talks, Second Dose series. …

Like a bridge over troubled water I will lay me down Paul Simon ClickHouse is a piece of art. It is very fast and efficient. In real applications, however, ClickHouse is never used as a standalone — it integrates with other data sources and exposes query results to applications. OLAP…

2021 has been a great year for Altinity.Cloud. Cloud users have grown to almost a third of our total subscription base. During that time both we and our customers have absorbed lessons on using ClickHouse effectively in the cloud. So what have we learned? …

ARM processors are hot. Amazon AWS and Apple have been building their own ARM processors for a few years already. They use them in servers and notebooks and get outstanding results. Ampere builds server-class ARM processors for everybody else. At Altinity we could not stand aside from this A-march. …