[Tech] The Origin of Clickhouse - Aaron Katz

<p>Source: the Analytics Engineering Podcast: <a href="https://roundup.getdbt.com/p/aaron-katz-clickhouse">https://roundup.getdbt.com/p/aaron-katz-clickhouse</a> (2mins in)</p><p>Feedback/Discuss on Twitter: <a href="https://twitter.com/swyx/status/1552835669373894656">https://twitter.com/swyx/status/1552835669373894656</a></p><p><strong>Survey</strong></p><ul> <li>Fill out our 2022 Survey! <a href="https://forms.gle/g2s1Np9wS5qmrKSRA">https://forms.gle/g2s1Np9wS5qmrKSRA</a>!</li> <li>Survey context: <a href="https://mixtape.swyx.io/episodes/swyx-mixtape-survey-refactor-and-deadpool-swyx">https://mixtape.swyx.io/episodes/swyx-mixtape-survey-refactor-and-deadpool-swyx</a> </li> </ul><p><br><strong>More on Clickhouse</strong></p><p>Our previous episode on Clickhouse: <a href="https://twitter.com/swyx/status/1502129209111576577?s=20&amp;t=bvjrALnEoJhIEn65h00y8g">https://twitter.com/swyx/status/1502129209111576577</a></p><p>HN comments on Clickhouse: https://news.ycombinator.com/item?id=28595419</p>I'd like to thank the creators of ClickHouse as i hope they are reading here. We've been using it since 2019 in a single server setup with billions of rows. No problems at all. And query speeds that seem unreal compared to MySQL and pg.<p><br>https://news.ycombinator.com/item?id=26316401 </p>Also wanted to share my overall positive experience with Clickhouse.<p>UPSIDES</p><p>* started a 3-node cluster using the official Docker images super quickly</p><p>* ingested billions of rows super fast</p><p>* great compression (of course, depends on your data's characteristics)</p><p>* features like <a href="https://clickhouse.tech/docs/en/engines/table-engines/mergetree-family/aggregatingmergetree/">https://clickhouse.tech/docs/en/engines/table-engines/merget...</a> are amazing to see</p><p>* ODBC support. I initially said "Who uses that??", but we used it to connect PostgreSQL and so we can keep the non-timeseries data in PostgreSQL but still access PostgreSQL tables in Clickhouse (!)</p><p>* you can go the other way too: