Robin Moffatt articles - 103 total
Kicking the tyres on the new DuckDB UI
I wrote a couple of weeks ago about using DuckDB and Rill Data to explore a new data source that I’m...
Creating an HTTP Source connector on Confluent Cloud from the CLI
In this blog article I'll show you how you can use the confluent CLI to set up a Kafka cluster on...
Why is kcat showing the wrong topics?
Much as I love kcat (🤫 it’ll always be kafkacat to me…), this morning I nearly fell out with it 👇 😖...
Write more blog articles, not fewer (Don't leave the scraps on the cutting floor)
The perfect blog article takes the reader on a journey that some would say looks like...
Data Wrangling with Flink SQL
The UK Government publishes a lot of its data as open feeds. One that I keep coming back to is the...
Joining two streams of data with Flink SQL
There was a useful question on the Apache Flink Slack recently about joining data in Flink SQL: How...
How to explode nested arrays with Flink SQL
Let’s imagine we’ve got a source of data with a nested array of multiple values. The data is from an...
Exploring UK Environment Agency data in DuckDB and Rill
The UK Environment Agency publishes a feed of data relating to rainfall and river levels. As a...
DuckDB tricks - renaming fields in a SELECT * across tables
I was exploring some new data, joining across multiple tables, and doing a simple SELECT * as I’d not...
Interesting links - February 2025
Here’s a bunch of interesting links and articles about data that I’ve come across recently. Martin...
How I Try To Keep Up With The Data Tech World (A List of Data Blogs)
I do my best to try and keep, if not abreast of, then at least aware of what’s going on in the world...
Blog Writing for Developers
Writing is one of the most powerful forms of communication, and it’s useful in a multitude of roles...
Building Better Docs - Automating Jekyll Builds and Link Checking for PRs
One of the most important ways that a project can help its developers is providing them good...
Making the move from Alfred to Raycast
It all started with a tweet. Raycast is blowing my mind. It's the 20% of macOS I didn't realize was...
Hanging up my Boarding Passes and Jetlag…for now
I recently started writing an abstract for a conference later this year and realised that I’m not...
Remote-First Developer Advocacy
I’m convinced that a developer advocate can be effective remotely. As a profession, we’ve all spent...
Kafka Summit London 2022- Call for Papers closes soon
Kafka Summit is the fandabidoziest conference dedicated to Apache Kafka® and event streaming. The...
Kafka Summit - Office Hours for Abstract Writing
We are keen to hear from as many people at Kafka Summit, and are offering an "Office Hours" session...
A bash script to deploy ksqlDB queries automagically
There’s a bunch of improvements in the works for how ksqlDB handles code deployments and migrations....
🤖Building a Telegram bot with Apache Kafka, Go, and ksqlDB
📔 Slides 👾 Code Imagine you’ve got a stream of data; it’s not “big data,” but it’s certainly a...
Loading CSV data into Confluent Cloud using the FilePulse connector
The FilePulse connector from Florian Hussonnois is a really useful connector for Kafka Connect which...
Connecting to managed ksqlDB in Confluent Cloud with REST and ksqlDB CLI
Using ksqlDB in Confluent Cloud makes things a whole bunch easier because now you just get to build...
Kafka Connect JDBC Sink deep-dive: Working with Primary Keys
The Kafka Connect JDBC Sink can be used to stream data from a Kafka topic to a database such as...
Quick profiling of data in Apache Kafka using kafkacat and visidata
ksqlDB is a fantastically powerful tool for processing and analysing streams of data in Apache Kafka....
Using Open Sea Map data in Kibana maps
Kibana’s map functionality is a powerful way to visualise data that has a location element in it. I...
📼 ksqlDB HOWTO - A mini video series 📼
Some people learn through doing - and for that there’s a bunch of good ksqlDB tutorials here and...
Performing a GROUP BY on data in bash
One of the fun things about working with data over the years is learning how to use the tools of the...
Running as root on Docker images that don't use root
tl;dr: specify the --user root argument: docker exec --interactive \ --tty \ ...
Running a self-managed Kafka Connect worker for Confluent Cloud
Confluent Cloud is not only a fully -managed Apache Kafka service, but also provides important...
Kafka Connect - Deep Dive into Single Message Transforms
KIP-66 was added in Apache Kafka 0.10.2 and brought new functionality called Single Message...