Now that I’m storing my blog’s request logs in Clickhouse, I can do some fun things with the data without a ton of extra work. For instance, it’s not all that hard to draw a map that shows where in the world my traffic is coming from: Grafana can now render a heatmap of where my traffic comes from for me. To do this, you need to add a bunch of geolocation boilerplate to Clickhouse, but once that’s done mapping IPv4 or IPv6 addresses to points on a map is fast and easy.
