Clickhouse: Faster Queries, Faster Answers (with Alasdair Brown)
In modern systems, the amount of data keeps getting larger, and the time available keeps getting shorter. So it's almost inevitable that we're augmenting our general-purpose databases with dedicated analytics databases. This week we dive into the world of OLAP with a thorough look at Clickhouse, a high-performance, columnar database designed to "query billions of rows in microseconds." Alasdair Brown joins us to discuss what Clickhouse is, how it performs queries so quickly, and where it fits into a wider system. We talk about its origins as a Google Analytics-like, and how it's grown into one of the most popular OLAP databases around. There's a lot of ground to cover, and a lot of questions to ask, all in the service of faster answers... -- Alasdair's Blog: alasdairb.com Alasdair on Threads: https://www.threads.net/@sdairsab Alasdair on LinkedIn https://www.linkedin.com/in/alasdair-brown Kris on Twitter: https://twitter.com/krisajenkins Kris on LinkedIn: https://www.linkedin.com/in/krisjenkins/ Clickhouse: https://clickhouse.com/ Tinybird: https://www.tinybird.co/ Birdhouse in your Soul: https://youtu.be/vn_or9gEB6g