I used both Gemini and Claude to query ClickHouse using natural language. I used a simple SQL test found online to try to compare them objectively. I think being able to do this type of generative BI is really becoming viable nowadays. benjaminwootton.com/insights/cli...

Using Gemini and Claude For SQL Analytics - A Bake Off | BenjaminWootton.com

A bake off of Claude and Gemini in order to test their SQL performance against a ClickHouse database.

benjaminwootton.com

Traditionally, ClickHouse hasn't been that fast when it comes to joins. However, in recent releases it is now performing 20x faster in a TPC-H benchmark. Using another public benchmark a set of join heavy queries over a 500m row dataset now smokes Databricks and Snowflake.

Connecting Gemini CLI or Claude Code to your back end database via an MCP server is a really remarkable development experience.

New article on ClickHouse in Capital Markets, where I show how we can investigate a realistic trading scenario to understand the PnL impact of trades being rejected. benjaminwootton.com/insights/ana...

Analysing FIX Data With ClickHouse | BenjaminWootton.com

Using ClickHouse String and Array Processing functions to analyse FIX Protocol data.

benjaminwootton.com

I'm increasingly seeing ClickHouse Cloud being compared with Snowflake for DWH/BI use cases. I ran this analysis last year and found that CH had a 50% lower cost for equivalent compute, before even accounting for it's better performance/scalability. benjaminwootton.com/insights/com...

Comparing ClickHouse Cloud With Snowflake Pricing | BenjaminWootton.com

In this article we analyse the differences in pricing between Snowflake and ClickHouse Cloud

benjaminwootton.com

Good article about ClickHouse security: www.wiz.io/blog/clickho...