Insights
Sharing knowledge and lessons learnt based on my ClickHouse engagements.
-
Comparing The TCO Of ClickHouse Cloud vs Open SourceBenjamin Wootton
July 24, 2025
Exploring the TCO when deciding between ClickHouse Cloud vs Open Source.
Read More
-
Using Gemini and Claude For SQL Analytics - A Bake OffBenjamin Wootton
July 8, 2025
A bake off of Claude and Gemini in order to test their SQL performance against a ClickHouse database.
Read More
-
Using ClickHouse Cloud For Real Time Sports AnalyticsBenjamin Wootton
July 3, 2025
A demonstration of a real time sports analytics use case powered by ClickHouse.
Read More
-
Simplifying Your Data Stack With ClickHouse CloudBenjamin Wootton
June 12, 2025
How ClickHouse can simplify your data estate and technology stack.
Read More
-
Analysing FIX Data With ClickHouseBenjamin Wootton
June 11, 2025
Using ClickHouse String and Array Processing functions to analyse FIX Protocol data.
Read More
-
Reliably Replicating Data Between PostgreSQL and ClickHouse Part 3 - DemoBenjamin Wootton
February 7, 2025
A video walkthrough of PeerDB open source and ClickPipes for Postgres CDC.
Read More
-
Reliably Replicating Data Between PostgreSQL and ClickHouse Part 2 - ClickPipes For PostgreSQL CDCBenjamin Wootton
January 24, 2025
Using ClickPipes to reliably replicate data from PostgreSQL to ClickHouse.
Read More
-
Reliably Replicating Data Between PostgreSQL and ClickHouse Part 1 - PeerDB Open SourceBenjamin Wootton
January 23, 2025
Using PeerDB open source to reliably replicate data from PostgreSQL to ClickHouse.
Read More
-
Time Series Classification Using ClickHouse Machine Learning FunctionsBenjamin Wootton
September 5, 2024
An example of how we can classify time series by leveraging machine learning functions baked into ClickHouse.
Read More
-
Optimising Vehicle Routing Using ClickHouse Cloud And Google OR-ToolsBenjamin Wootton
August 20, 2024
Operational Analytics is about using real time data to make better day to day decisions
Read More
-
Building A Recommendation System Using ClickHouse and SQLBenjamin Wootton
July 26, 2024
In recent blog posts we demonstrated how data science techniques such as forecasting and anomaly detection can be implemented entirely within ClickHouse using only SQL.
Read More
-
Combatting Out Of Memory Errors With ClickHouseBenjamin Wootton
July 11, 2024
Steps to take when you get an out of memory error on ClickHouse.
Read More
