Benjamin Wootton

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.

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...

14.07.2025 19:44 — 👍 0    🔁 0    💬 0    📌 0

I think ClickHouse has been viable for trad data warehousing for a while now, but this jump in join performance removes one of the main objections.

14.07.2025 19:40 — 👍 0    🔁 0    💬 0    📌 0

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.

14.07.2025 19:40 — 👍 0    🔁 0    💬 1    📌 0

Feel free to ping me.

08.07.2025 21:05 — 👍 1    🔁 0    💬 0    📌 0

Later on, if your app throws a frontend error it can go digging around the database and executing queries to understand what is happening before fixing the app. It's crazy to see it building an app in say React then dropping down to the database layer to sling some SQL for debugging purposes.

08.07.2025 21:04 — 👍 0    🔁 0    💬 0    📌 0

Here, I've asked it to build a low code app and just given it a hint at the database table. Gemini CLI logs into the database, locates the relevant table, identifies the fields and then builds the app based on what it finds.

08.07.2025 21:04 — 👍 0    🔁 0    💬 1    📌 0

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

08.07.2025 21:04 — 👍 0    🔁 0    💬 1    📌 0

Analysing FIX Data With ClickHouse | BenjaminWootton.com Using ClickHouse String and Array Processing functions to analyse FIX Protocol data.

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...

12.06.2025 09:56 — 👍 1    🔁 0    💬 0    📌 0

Comparing ClickHouse Cloud With Snowflake Pricing | BenjaminWootton.com In this article we analyse the differences in pricing between Snowflake and ClickHouse Cloud

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...

04.06.2025 23:15 — 👍 0    🔁 0    💬 0    📌 0

Securing Cloud Databases: Best Practices with ClickHouse and Wiz | Wiz Blog How to protect sensitive data in cloud-hosted databases with built-in security controls, best practices, and continuous risk monitoring.

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

22.03.2025 08:58 — 👍 7    🔁 1    💬 0    📌 0

Not only is it the fastest open source way to do CDC from Postgres, it's also been integrated directly into ClickHouse Cloud, meaning that with a few clicks you can subscribe to a change feed from your Postgres database and begin ingesting streaming updates.

09.12.2024 22:16 — 👍 0    🔁 0    💬 0    📌 0