![Clickhouse: Faster Queries, Faster Answers (with Alasdair Brown) image](https://media.zencastr.com/cdn-cgi/image/width=640,quality=85/image-files/619e48a9649c44004c5a44e8/96973d74-2516-4e2d-9d94-649aee1838f7.jpg)
![](https://media.zencastr.com/cdn-cgi/image/width=640,quality=85/image-files/619e48a9649c44004c5a44e8/96973d74-2516-4e2d-9d94-649aee1838f7.jpg)
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
![](https://media.zencastr.com/cdn-cgi/image/width=640,quality=85/image-files/619e48a9649c44004c5a44e8/96973d74-2516-4e2d-9d94-649aee1838f7.jpg)
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