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.comAlasdair on Threads: https://www.threads.net/@sdairsabAlasdair on LinkedIn https://www.linkedin.com/in/alasdair-brownKris 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)
