Back
October 3, 2024
6
min read

Change Data Capture and Stream Processing in the Cloud

In this week’s episode of Simplyblock's Cloud Commute podcast, Chris Engelbert chats with Gunnar Morling about change data capture (CDC) and stream processing in the cloud. Gunnar is a software engineer at Decodable, a tech startup in the data streaming space, essentially helping customers with moving and processing their data. Gunnar also does outreach work, like doing blog posts, podcasts, and going to conferences. Before that, he was at Red Hat working on several projects, including Hibernate, Bean Validation (was the spec lead for Bean Validation 2.0), and also Debezium—a tool and platform for change data capture, which is what he’s most known for. Chris and Gunnar are also both Java champions.

Chris Engelbert: Hello everyone. Welcome back to the next episode of simplyblock's Cloud Commute podcast. Today I have a really good guest, and a really good friend with me. We’ve known each other for quite a while. I don't know, many, many, many years. Another fellow German. And I guess a lot of, at least when you're in the Java world, you must have heard of him. You must have heard him. Gunnar, welcome. Happy to have you.

Gunnar Morling: Chris, hello, everybody. Thank you so much, family. Super excited. Yes, I don't know, to be honest, for how long we have known each other. Yes, definitely quite a few years, you know, always running into each other in the Java community.

Chris Engelbert: So, well, we already heard who you are, but maybe you can give a little bit of a deeper introduction of yourself.

Gunnar Morling: Sure. So, I'm Gunnar. I work as a software engineer right now at a company called Decodable. We are a small startup in the data streaming space, essentially moving and processing your data. And I think we will talk more about what that means. So, that's my current role. And I have, you know, a bit of a mixed role between engineering and then also doing outreach work, like doing blog posts, podcasts, maybe sometimes, going to conferences, talking about things. So, that's what I'm currently doing.

Before that, I've been for exactly up to the day, exactly for 10 years at Red Hat, where I worked on several projects. So, I started working on different projects from the Hibernate umbrella. Yes, it's still a thing. I still like it. So, I was doing that for roughly five years working on Bean Validation. I was the spec lead for Bean Validation 2.0, for instance, which I think is also how we met or I believe we interacted somehow within the context of Bean Validation. I remember something there.

And then, well, I worked on a project which is called Debezium. It's a tool and a platform for change data capture (CDC). And again, we will dive into that. But I guess that's what people might know me for. I'm also a Java champion as you are, Chris. And I did this challenge. I need to mention it. I did this kind of viral challenge in the Java space. Some people might also have come across my name in that context.

Chris Engelbert: All right. Let's get back to the challenge in a moment. Maybe say a couple of words about Decodable.

Intro to Decodable

Gunnar Morling: Yes. So, essentially, we built a SaaS, a software as a service for stream processing. This means, essentially, it connects to all kinds of data systems, let's say databases like Postgres or MySQL, streaming platforms like Kafka, Apache Pulsar. It takes data from those kinds of systems. And in the simplest case, it just takes this data and puts it into something like Snowflake, like a search index, maybe another database, maybe S3, maybe something like Apache Pino or Clickhouse.

So, it's about data movement in the simplest case, taking data from one place to another. And very importantly, all this happens in real time. So, it's not batch driven, like, you know, running once per hour, once per day or whatever. But this happens in near real time. So, not in the hard, you know, computer science sense of the word, with a fixed SLA, but with a very low latency, like seconds, typically. But then, you know, going beyond data movement, there's also what we would call data processing. So, it's about filtering your data, transforming it, routing it, joining multiple of those real time data streams, doing things like groupings, real time analytics of this data, so you could gain insight into your data.

So, this is what we do. It's based on Apache Flink as a stream processing engine. It's based on Debezium as a CDC tool. So, this gives you source connectivity with all kinds of databases. And yeah, people use it for, as I mentioned, for taking data from one place to another, but then also for, I don't know, doing fraud detection, gaining insight into their purchase orders or customers, you know, all those kinds of things, really.

Chris Engelbert: All right, cool. Let's talk about your challenge real quick, because you already mentioned stream processing. Before we go on with, like, the other stuff, like, let's talk about the challenge. What was that about?

Gunnar Morling: What was that about? Yes, this was, to be honest, it was kind of a random thing, which I started over the holidays between, you know, Christmas and New Year's Eve. So, this had been on my mind for quite some time, doing something like processing one billion rows, because that's what it was, a one billion row challenge. And this had been on my mind for a while. And I know somehow, then I had this idea, okay, let me just put it out into the community, and let's make a challenge out of it and essentially ask people, so how fast can you be with Java to process one billion rows of a CSV file, essentially?

And the task was, you know, to take temperature measurements, which were given in that file, and aggregate them per weather station. So, the measurements or the rows in this file were essentially always like, you know, a weather station name and then a temperature value. And you had to aggregate them per station, which means you had to get the minimum, the maximum and the mean value per station. So, this was the task.

And then it kind of took off. So, like, you know, many people from the community entered this challenge and also like really big names like Aleksey Shipilëv, Cliff Click, Thomas Wuerthinger, the leads of GraalVm at Oracle and many, many others, they started to work on this and they kept working on it for the entire month of January. And like really bringing down those execution times, essentially, in the end, it was like less than two seconds for processing this file, which I had with 13 gigabytes of size on an eight core CPU configuration. 

Chris Engelbert: I think the important thing is he said less than a second, which is already impressive because a lot of people think Java is slow and everything. Right. We know those terms and those claims.

Gunnar Morling: By the way, I should clarify. So, you know, I mean, this is highly parallelizable, right? So, the less-than-a-second number, I think like 350 milliseconds or so, was an old 32 cores I had in this machine with hyperthreading, with turbo boost. So, this was the best I could get.

Chris Engelbert: But it also included reading those, like 13 gigs, right? And I think that is impressive. 

Gunnar Morling:  Yes. But again, then reading from memory. So, essentially, I wanted to make sure that disk IO is not part of the equation because it would be super hard to measure for me anyway. So, that's why I said, okay, I will have everything in a RAM disk. And, you know, so everything came out of memory for that context.

Chris Engelbert: Ok. Got it. But still, it got pretty viral. I've seen it from the start and I was kind of blown away by who joined that discussion. It was really cool to look after and to just follow up. I didn't have time to jump into that myself, but by the numbers and the results I've seen, I would have not won anyway. That was me not wasting time.

Gunnar Morling: Absolutely. I mean, people pulled off like really crazy tricks to get there. And by the way, if you're at JavaLand in a few weeks, I will talk about some of those things. 

Chris Engelbert: All right. So that was the challenge. Let's get back to Decodable. You mentioned Apache Flink being like the underlying technology it is built on. So how does that work?

Apache Flink and Flink SQL

Gunnar Morling: So Apache Flink, essentially, that's an open source project which concerns itself with real-time data processing. So it's essentially an engine for processing either bounded or unbounded streams of events. So there's also a way where you could use it in a batch mode. But this is not what we are too interested in so far. It's always about unbounded data streams coming from a Kafka topic, so it takes those event streams, it defines semantics on those event streams. Like what's an event time? What does it mean if an event arrives late or out of order? So you have the building blocks for all those kinds of things.

Then you have a stack, a layer of APIs, which allow you to implement stream processing applications. So there's more imperative APIs, which in particular is called the data streaming API. So there you really program in Java, typically, or Scala, I guess, your flow in an imperative way. Yeah Scala, I don't know who does it, but that may be some people. And then there's more and more abstract APIs. So there's a table API, which essentially gives you like a relational programming paradigm.

And finally, there's Flink SQL, which also is what Decodable employs heavily in the product. So there you reason about your data streams in terms of SQL. So let's say, you know, you want to take the data from an external system, you would express this as a create table statement, and then this table would be backed by a Kafka topic. And you can do a select from such a table. And then of course you can do, you know, projections by massaging your select clause. You can do filterings by adding where clauses, you can join multiple streams by using the join operator and you can do windowed aggregations. So I would feel that's the most accessible way for doing stream processing, because there's of course, a large number of people who can implement a SQL query, right?

Chris Engelbert: Right. And I just wanted to say, and it's all like a SQL dialect, it's pretty close as far as I've seen to the original like standard SQL.

Gunnar Morling: Yes, exactly. And then there's a few extensions, you know, because you need to have this notion of event time or what does it mean? How do you express how much lateness you would be willing to accept for an aggregation? So there's a few extensions like that. But overall, it's SQL. For my demos, oftentimes, I can start working on Postgres, developing, develop some queries on Postgres, and then I just take them, paste them into like the Flink SQL client, and they might just run as is, or they may need a little bit of adjustment, but it's pretty much standard SQL.

Debezium for Change Data Capture

Chris Engelbert: All right, cool. The other thing you mentioned was the Debezium. And I know you, I think you originally started Debezium. Is that true?

Gunnar Morling: It's not true. No, I did not start it. It was somebody else at Red Hat, Randall Hauck, he's now at Confluent. But I took over the project quite early on. So Randall started it. And I know I came in after a few months, I believe. And yeah, I think this is when it really took off, right? So, you know, I went to many conferences, I spoke about it. And of course, others as well. The team grew at Red Hat. So yeah, I was the lead for quite a few years.

Chris Engelbert: So for the people that don't know, maybe just give a few words about what Debezium is, what it does, and why it is so cool.

Gunnar Morling: Right. Yes. Oh, man, where should I start? In a nutshell, it's a tool for what's called change data capture. So this means it taps into the transaction log of your database. And then whenever there's an insert or an update or delete, it will capture this event, and it will propagate it to consumers. So essentially, you could think about it like the observer pattern for your database. So whenever there's a data change, like a new customer record gets created, or purchase order gets updated, those kinds of things, you can, you know, react and extract this change event from the database, push it to consumers, either via Kafka or via pullbacks in an API way, or via, you know, Google Cloud PubSub, Kinesis, all those kinds of things.

And then well, you can take those events and it enables a ton of use cases. So you know, in the simplest case, it's just about replication. So taking data from your operational database to your cloud data warehouse, or to your search index, or maybe to cache. But then also people use CDC for doing things like microservices, data exchange, because I mean, microservices, they, you want to have them self dependent, but still, they need to exchange data, right? So they don't exist in isolation, and change data capture can help with that in particular, with what's called the outbox pattern, just on the side note, people use it for splitting up monolithic systems into microservices, you can use this change event stream as an audit log.

I mean, if you kind of think about it, it's, you know, if you just keep those events, all the updates to purchase order, we put them into a database, it's kind of like a search index, right? Maybe you want to enrich it with a bit of metadata. You can do streaming queries. So if you want to spot specific patterns in your data as it changes, and then trigger some sort of alert. That's the use case, and many, many more, but really, it's a super versatile tool, I would say.

Chris Engelbert: Yeah, and I also have a couple of talks on that area. And I think my favorite example, that's something that everyone understands is that you have some order coming in, and now you want to send out invoices. Invoices don't need to be sent like, in the same operation, but you want to make sure that you only send out the invoice if the invoice was, or if the order was actually generated in the database. So that is where the outbox pattern comes in, or just looking at the order table in general, and filtering out all the new orders.

Gunnar Morling: Yes.

Chris Engelbert: So yeah, absolutely a great tool. Love it. It supports many, many databases. Any idea how many so far?

Gunnar Morling: It keeps growing. I know, certainly 10 or so or more. The interesting thing there is, well, you know, there is not a standardized way you could implement something like Debezium. So each of the databases have their own APIs, formats, their own ways for extracting those change events, which means there needs to be a dedicated Debezium connector for each database, which we want to support. And then the core team, you know, added support for MySQL, Postgres, SQL Server, Oracle, Cassandra, MongoDB, and so on.

But then what happened is that also other companies and other organizations picked up the Debezium framework. So for instance, now something like Google Cloud Spanner, it's also supported via Debezium, because the team at Google decided that they want to expose change events based on the Debezium event format and infrastructure of ScyllaDB. So they maintain their own CDC connector, but it's based on Debezium.

And the nice thing about that is that it gives you as a user, one unified change event format, right? So you don't have to care, which is the particular source database, does it come from Cloud Spanner, or does it come from Postgres? You can process those events in a unified way, which I think is just great to see that it establishes itself as a sort of a de facto standard, I would say.

Chris Engelbert: Yeah, I think that is important. That is a very, very good point. Debezium basically defined a JSON and I think Avro standard.

Gunnar Morling: Right. So I mean, you know, it defines the, let's say, the semantic structure, like, you know, what are the fields, what are the types, how are they organized, and then how you serialize it as Avro, JSON, or protocol buffers. That's essentially like a pluggable concern.

Managed Flink with Decodable

Chris Engelbert: Right. So we said earlier, Decodable is a cloud platform. So you basically have, in a little bit of a mean term, you have Apache Flink on steroids, ready to use, plus a couple of stuff on top of that. So maybe talk a little bit about that. 

Gunnar Morling: Right. So yes, that's the underlying tech, I would say. And then of course, if you want to put those things into production, there's so many things you need to consider. Right. So how do you just go about developing and versioning those SQL statements? If you iterate on a statement, you want to have maybe like a preview and get a feeling or maybe just validation of this. So we have all this editing experience, preview. Then maybe you don't want that all of your users in your organization can access all those streaming pipelines, which you have. Right. So you want to have something like role-based access control. You want to have managed connectors. You want to have automatic provisioning and sizing of your infrastructure.

So you don't want to think too much, "Hey, do I need to keep like five machines for this dataflow sitting around?" And what happens if I don't need them? Do I need to remove them and then scale them back up again? So all this auto scaling, auto provisioning, this is something which we do. Then we will primarily allow you to use SQL to define your queries, but then also we actually let you run your own custom Flink jobs. If that's something which you want to do, you can do this. We are very close. And again, by the time this will be released, it should be live already. We will have Python, PyFlink support, and yeah, many, many more things. Right. So really it's a managed experience for those dataflows.

Chris Engelbert: Right. That makes a lot of sense. So let me see. From a user's perspective, I'm mostly working with SQL. I'm writing my jobs and deploying those. Those jobs are everything from simple ETL to extract, translate, load. Nobody needs to load data. They just magically appear. But you can also do data enrichment. You said that earlier. You can do joins. So is there anything I have to be aware of that is very complicated compared to just using a standard database? 

Gunnar Morling: Yeah. I mean, I think this entire notion of event time, this definitely is something which can be challenging. So let's say you want to do some sort of windowed analysis, like, you know, how many purchase orders do I have per category and hour, you know, this kind of thing. And now, depending on what's the source of your data, those events might arrive out of order. Right. So it might be that your hour has closed. But then, like, five minutes later, because some event was stuck in some queue, you still get an event for that past hour. Right.

And of course, now the question is, there's this tradeoff between, okay, how accurate do you want your data to be? Essentially, how long do you want to wait for those late events versus, well, what is your latency? Right. Do you want to get out this updated count at the top of the hour? Or can you afford to wait for those five minutes? So there's a bit of a tradeoff. I think, you know, this entire complex of event time, I think that's certainly something where people often have at least some time to learn and grasp the concepts.

Chris Engelbert: Yeah, that's a very good one. In a previous episode, we had a discussion about connected cars. And connected cars may or may not have an internet connection all the time. So you like super, super late events sometimes. All right. Because we're almost running out of time.

Gunnar Morling: Wow. Ok.

Industry Trends

Chris Engelbert:  Yeah. 20 minutes is like nothing. What is the biggest trend you see right now in terms of database, in terms of cloud, in terms of whatever you like? 

Gunnar Morling: Right. I mean, that's a tough one. Well, I guess there can only be one answer, right? It has to be AI. I feel like it's boring—well, the trend is not boring, but saying it is kind of boring. But I mean, that's what I see. The way I could see this impact things like we do, I mean, it could help you just with like scaling, of course, like, you know, we could make intelligent predictions about what's your workload like, maybe we can take a look at the data and we can sense, okay, you know, it might make sense to scale out some more compute load already, because we will know with a certain likelihood that it may be needed very shortly.

I could see that then, of course, I mean, it could just help you with authoring those flows, right? I mean, with all those LLMs, it might be doable to give you some sort of guided experience there. So that's a big trend for sure. Then I guess another one, I would see more technical, I feel like that's a unification happening, right, of systems and categories of systems. So right now we have, you know, databases here, stream processing engines there. And I feel those things might come more closely together. And you would have real-time streaming capabilities also in something like Postgres itself. And maybe it would expose Postgres as a Kafka broker, in a sense. So I could also see some closer integration of those different kinds of tools. 

Chris Engelbert: That is interesting, because I also think that there is a general like movement to, I mean, in the past we had the idea of moving to different databases, because all of them were very specific. And now all of the big databases, Oracle, Postgres, well, even MySQL, they all start to integrate all of those like multi-model features. And Postgres, being at the forefront, having this like super extensibility. So yeah, that would be interesting.

Gunnar Morling: Right. I mean, it's always going in cycles, I feel right. And even having this trend to decomposition, like it gives you all those good building blocks, which you then can put together and I know create a more cohesive integrated experience, right. And then I guess in five years, we want to tear it apart again, and like, let people integrate everything themselves.

Chris Engelbert: In 5 to 10 years, we have the next iteration of microservices. We called it SOAP, we called it whatever. Now we call it microservices. Who knows what we will call it in the future.  All right. Thank you very much. That was a good chat. Like always, I love talking with you.

📫 Email signup 👇

Did you enjoy this issue of Checkpoint Chronicle? Would you like the next edition delivered directly to your email to read from the comfort of your own home?

Simply enter your email address here and we'll send you the next issue as soon as it's published—and nothing else, we promise!

👍 Got it!
Oops! Something went wrong while submitting the form.
David Fabritius

In this week’s episode of Simplyblock's Cloud Commute podcast, Chris Engelbert chats with Gunnar Morling about change data capture (CDC) and stream processing in the cloud. Gunnar is a software engineer at Decodable, a tech startup in the data streaming space, essentially helping customers with moving and processing their data. Gunnar also does outreach work, like doing blog posts, podcasts, and going to conferences. Before that, he was at Red Hat working on several projects, including Hibernate, Bean Validation (was the spec lead for Bean Validation 2.0), and also Debezium—a tool and platform for change data capture, which is what he’s most known for. Chris and Gunnar are also both Java champions.

Chris Engelbert: Hello everyone. Welcome back to the next episode of simplyblock's Cloud Commute podcast. Today I have a really good guest, and a really good friend with me. We’ve known each other for quite a while. I don't know, many, many, many years. Another fellow German. And I guess a lot of, at least when you're in the Java world, you must have heard of him. You must have heard him. Gunnar, welcome. Happy to have you.

Gunnar Morling: Chris, hello, everybody. Thank you so much, family. Super excited. Yes, I don't know, to be honest, for how long we have known each other. Yes, definitely quite a few years, you know, always running into each other in the Java community.

Chris Engelbert: So, well, we already heard who you are, but maybe you can give a little bit of a deeper introduction of yourself.

Gunnar Morling: Sure. So, I'm Gunnar. I work as a software engineer right now at a company called Decodable. We are a small startup in the data streaming space, essentially moving and processing your data. And I think we will talk more about what that means. So, that's my current role. And I have, you know, a bit of a mixed role between engineering and then also doing outreach work, like doing blog posts, podcasts, maybe sometimes, going to conferences, talking about things. So, that's what I'm currently doing.

Before that, I've been for exactly up to the day, exactly for 10 years at Red Hat, where I worked on several projects. So, I started working on different projects from the Hibernate umbrella. Yes, it's still a thing. I still like it. So, I was doing that for roughly five years working on Bean Validation. I was the spec lead for Bean Validation 2.0, for instance, which I think is also how we met or I believe we interacted somehow within the context of Bean Validation. I remember something there.

And then, well, I worked on a project which is called Debezium. It's a tool and a platform for change data capture (CDC). And again, we will dive into that. But I guess that's what people might know me for. I'm also a Java champion as you are, Chris. And I did this challenge. I need to mention it. I did this kind of viral challenge in the Java space. Some people might also have come across my name in that context.

Chris Engelbert: All right. Let's get back to the challenge in a moment. Maybe say a couple of words about Decodable.

Intro to Decodable

Gunnar Morling: Yes. So, essentially, we built a SaaS, a software as a service for stream processing. This means, essentially, it connects to all kinds of data systems, let's say databases like Postgres or MySQL, streaming platforms like Kafka, Apache Pulsar. It takes data from those kinds of systems. And in the simplest case, it just takes this data and puts it into something like Snowflake, like a search index, maybe another database, maybe S3, maybe something like Apache Pino or Clickhouse.

So, it's about data movement in the simplest case, taking data from one place to another. And very importantly, all this happens in real time. So, it's not batch driven, like, you know, running once per hour, once per day or whatever. But this happens in near real time. So, not in the hard, you know, computer science sense of the word, with a fixed SLA, but with a very low latency, like seconds, typically. But then, you know, going beyond data movement, there's also what we would call data processing. So, it's about filtering your data, transforming it, routing it, joining multiple of those real time data streams, doing things like groupings, real time analytics of this data, so you could gain insight into your data.

So, this is what we do. It's based on Apache Flink as a stream processing engine. It's based on Debezium as a CDC tool. So, this gives you source connectivity with all kinds of databases. And yeah, people use it for, as I mentioned, for taking data from one place to another, but then also for, I don't know, doing fraud detection, gaining insight into their purchase orders or customers, you know, all those kinds of things, really.

Chris Engelbert: All right, cool. Let's talk about your challenge real quick, because you already mentioned stream processing. Before we go on with, like, the other stuff, like, let's talk about the challenge. What was that about?

Gunnar Morling: What was that about? Yes, this was, to be honest, it was kind of a random thing, which I started over the holidays between, you know, Christmas and New Year's Eve. So, this had been on my mind for quite some time, doing something like processing one billion rows, because that's what it was, a one billion row challenge. And this had been on my mind for a while. And I know somehow, then I had this idea, okay, let me just put it out into the community, and let's make a challenge out of it and essentially ask people, so how fast can you be with Java to process one billion rows of a CSV file, essentially?

And the task was, you know, to take temperature measurements, which were given in that file, and aggregate them per weather station. So, the measurements or the rows in this file were essentially always like, you know, a weather station name and then a temperature value. And you had to aggregate them per station, which means you had to get the minimum, the maximum and the mean value per station. So, this was the task.

And then it kind of took off. So, like, you know, many people from the community entered this challenge and also like really big names like Aleksey Shipilëv, Cliff Click, Thomas Wuerthinger, the leads of GraalVm at Oracle and many, many others, they started to work on this and they kept working on it for the entire month of January. And like really bringing down those execution times, essentially, in the end, it was like less than two seconds for processing this file, which I had with 13 gigabytes of size on an eight core CPU configuration. 

Chris Engelbert: I think the important thing is he said less than a second, which is already impressive because a lot of people think Java is slow and everything. Right. We know those terms and those claims.

Gunnar Morling: By the way, I should clarify. So, you know, I mean, this is highly parallelizable, right? So, the less-than-a-second number, I think like 350 milliseconds or so, was an old 32 cores I had in this machine with hyperthreading, with turbo boost. So, this was the best I could get.

Chris Engelbert: But it also included reading those, like 13 gigs, right? And I think that is impressive. 

Gunnar Morling:  Yes. But again, then reading from memory. So, essentially, I wanted to make sure that disk IO is not part of the equation because it would be super hard to measure for me anyway. So, that's why I said, okay, I will have everything in a RAM disk. And, you know, so everything came out of memory for that context.

Chris Engelbert: Ok. Got it. But still, it got pretty viral. I've seen it from the start and I was kind of blown away by who joined that discussion. It was really cool to look after and to just follow up. I didn't have time to jump into that myself, but by the numbers and the results I've seen, I would have not won anyway. That was me not wasting time.

Gunnar Morling: Absolutely. I mean, people pulled off like really crazy tricks to get there. And by the way, if you're at JavaLand in a few weeks, I will talk about some of those things. 

Chris Engelbert: All right. So that was the challenge. Let's get back to Decodable. You mentioned Apache Flink being like the underlying technology it is built on. So how does that work?

Apache Flink and Flink SQL

Gunnar Morling: So Apache Flink, essentially, that's an open source project which concerns itself with real-time data processing. So it's essentially an engine for processing either bounded or unbounded streams of events. So there's also a way where you could use it in a batch mode. But this is not what we are too interested in so far. It's always about unbounded data streams coming from a Kafka topic, so it takes those event streams, it defines semantics on those event streams. Like what's an event time? What does it mean if an event arrives late or out of order? So you have the building blocks for all those kinds of things.

Then you have a stack, a layer of APIs, which allow you to implement stream processing applications. So there's more imperative APIs, which in particular is called the data streaming API. So there you really program in Java, typically, or Scala, I guess, your flow in an imperative way. Yeah Scala, I don't know who does it, but that may be some people. And then there's more and more abstract APIs. So there's a table API, which essentially gives you like a relational programming paradigm.

And finally, there's Flink SQL, which also is what Decodable employs heavily in the product. So there you reason about your data streams in terms of SQL. So let's say, you know, you want to take the data from an external system, you would express this as a create table statement, and then this table would be backed by a Kafka topic. And you can do a select from such a table. And then of course you can do, you know, projections by massaging your select clause. You can do filterings by adding where clauses, you can join multiple streams by using the join operator and you can do windowed aggregations. So I would feel that's the most accessible way for doing stream processing, because there's of course, a large number of people who can implement a SQL query, right?

Chris Engelbert: Right. And I just wanted to say, and it's all like a SQL dialect, it's pretty close as far as I've seen to the original like standard SQL.

Gunnar Morling: Yes, exactly. And then there's a few extensions, you know, because you need to have this notion of event time or what does it mean? How do you express how much lateness you would be willing to accept for an aggregation? So there's a few extensions like that. But overall, it's SQL. For my demos, oftentimes, I can start working on Postgres, developing, develop some queries on Postgres, and then I just take them, paste them into like the Flink SQL client, and they might just run as is, or they may need a little bit of adjustment, but it's pretty much standard SQL.

Debezium for Change Data Capture

Chris Engelbert: All right, cool. The other thing you mentioned was the Debezium. And I know you, I think you originally started Debezium. Is that true?

Gunnar Morling: It's not true. No, I did not start it. It was somebody else at Red Hat, Randall Hauck, he's now at Confluent. But I took over the project quite early on. So Randall started it. And I know I came in after a few months, I believe. And yeah, I think this is when it really took off, right? So, you know, I went to many conferences, I spoke about it. And of course, others as well. The team grew at Red Hat. So yeah, I was the lead for quite a few years.

Chris Engelbert: So for the people that don't know, maybe just give a few words about what Debezium is, what it does, and why it is so cool.

Gunnar Morling: Right. Yes. Oh, man, where should I start? In a nutshell, it's a tool for what's called change data capture. So this means it taps into the transaction log of your database. And then whenever there's an insert or an update or delete, it will capture this event, and it will propagate it to consumers. So essentially, you could think about it like the observer pattern for your database. So whenever there's a data change, like a new customer record gets created, or purchase order gets updated, those kinds of things, you can, you know, react and extract this change event from the database, push it to consumers, either via Kafka or via pullbacks in an API way, or via, you know, Google Cloud PubSub, Kinesis, all those kinds of things.

And then well, you can take those events and it enables a ton of use cases. So you know, in the simplest case, it's just about replication. So taking data from your operational database to your cloud data warehouse, or to your search index, or maybe to cache. But then also people use CDC for doing things like microservices, data exchange, because I mean, microservices, they, you want to have them self dependent, but still, they need to exchange data, right? So they don't exist in isolation, and change data capture can help with that in particular, with what's called the outbox pattern, just on the side note, people use it for splitting up monolithic systems into microservices, you can use this change event stream as an audit log.

I mean, if you kind of think about it, it's, you know, if you just keep those events, all the updates to purchase order, we put them into a database, it's kind of like a search index, right? Maybe you want to enrich it with a bit of metadata. You can do streaming queries. So if you want to spot specific patterns in your data as it changes, and then trigger some sort of alert. That's the use case, and many, many more, but really, it's a super versatile tool, I would say.

Chris Engelbert: Yeah, and I also have a couple of talks on that area. And I think my favorite example, that's something that everyone understands is that you have some order coming in, and now you want to send out invoices. Invoices don't need to be sent like, in the same operation, but you want to make sure that you only send out the invoice if the invoice was, or if the order was actually generated in the database. So that is where the outbox pattern comes in, or just looking at the order table in general, and filtering out all the new orders.

Gunnar Morling: Yes.

Chris Engelbert: So yeah, absolutely a great tool. Love it. It supports many, many databases. Any idea how many so far?

Gunnar Morling: It keeps growing. I know, certainly 10 or so or more. The interesting thing there is, well, you know, there is not a standardized way you could implement something like Debezium. So each of the databases have their own APIs, formats, their own ways for extracting those change events, which means there needs to be a dedicated Debezium connector for each database, which we want to support. And then the core team, you know, added support for MySQL, Postgres, SQL Server, Oracle, Cassandra, MongoDB, and so on.

But then what happened is that also other companies and other organizations picked up the Debezium framework. So for instance, now something like Google Cloud Spanner, it's also supported via Debezium, because the team at Google decided that they want to expose change events based on the Debezium event format and infrastructure of ScyllaDB. So they maintain their own CDC connector, but it's based on Debezium.

And the nice thing about that is that it gives you as a user, one unified change event format, right? So you don't have to care, which is the particular source database, does it come from Cloud Spanner, or does it come from Postgres? You can process those events in a unified way, which I think is just great to see that it establishes itself as a sort of a de facto standard, I would say.

Chris Engelbert: Yeah, I think that is important. That is a very, very good point. Debezium basically defined a JSON and I think Avro standard.

Gunnar Morling: Right. So I mean, you know, it defines the, let's say, the semantic structure, like, you know, what are the fields, what are the types, how are they organized, and then how you serialize it as Avro, JSON, or protocol buffers. That's essentially like a pluggable concern.

Managed Flink with Decodable

Chris Engelbert: Right. So we said earlier, Decodable is a cloud platform. So you basically have, in a little bit of a mean term, you have Apache Flink on steroids, ready to use, plus a couple of stuff on top of that. So maybe talk a little bit about that. 

Gunnar Morling: Right. So yes, that's the underlying tech, I would say. And then of course, if you want to put those things into production, there's so many things you need to consider. Right. So how do you just go about developing and versioning those SQL statements? If you iterate on a statement, you want to have maybe like a preview and get a feeling or maybe just validation of this. So we have all this editing experience, preview. Then maybe you don't want that all of your users in your organization can access all those streaming pipelines, which you have. Right. So you want to have something like role-based access control. You want to have managed connectors. You want to have automatic provisioning and sizing of your infrastructure.

So you don't want to think too much, "Hey, do I need to keep like five machines for this dataflow sitting around?" And what happens if I don't need them? Do I need to remove them and then scale them back up again? So all this auto scaling, auto provisioning, this is something which we do. Then we will primarily allow you to use SQL to define your queries, but then also we actually let you run your own custom Flink jobs. If that's something which you want to do, you can do this. We are very close. And again, by the time this will be released, it should be live already. We will have Python, PyFlink support, and yeah, many, many more things. Right. So really it's a managed experience for those dataflows.

Chris Engelbert: Right. That makes a lot of sense. So let me see. From a user's perspective, I'm mostly working with SQL. I'm writing my jobs and deploying those. Those jobs are everything from simple ETL to extract, translate, load. Nobody needs to load data. They just magically appear. But you can also do data enrichment. You said that earlier. You can do joins. So is there anything I have to be aware of that is very complicated compared to just using a standard database? 

Gunnar Morling: Yeah. I mean, I think this entire notion of event time, this definitely is something which can be challenging. So let's say you want to do some sort of windowed analysis, like, you know, how many purchase orders do I have per category and hour, you know, this kind of thing. And now, depending on what's the source of your data, those events might arrive out of order. Right. So it might be that your hour has closed. But then, like, five minutes later, because some event was stuck in some queue, you still get an event for that past hour. Right.

And of course, now the question is, there's this tradeoff between, okay, how accurate do you want your data to be? Essentially, how long do you want to wait for those late events versus, well, what is your latency? Right. Do you want to get out this updated count at the top of the hour? Or can you afford to wait for those five minutes? So there's a bit of a tradeoff. I think, you know, this entire complex of event time, I think that's certainly something where people often have at least some time to learn and grasp the concepts.

Chris Engelbert: Yeah, that's a very good one. In a previous episode, we had a discussion about connected cars. And connected cars may or may not have an internet connection all the time. So you like super, super late events sometimes. All right. Because we're almost running out of time.

Gunnar Morling: Wow. Ok.

Industry Trends

Chris Engelbert:  Yeah. 20 minutes is like nothing. What is the biggest trend you see right now in terms of database, in terms of cloud, in terms of whatever you like? 

Gunnar Morling: Right. I mean, that's a tough one. Well, I guess there can only be one answer, right? It has to be AI. I feel like it's boring—well, the trend is not boring, but saying it is kind of boring. But I mean, that's what I see. The way I could see this impact things like we do, I mean, it could help you just with like scaling, of course, like, you know, we could make intelligent predictions about what's your workload like, maybe we can take a look at the data and we can sense, okay, you know, it might make sense to scale out some more compute load already, because we will know with a certain likelihood that it may be needed very shortly.

I could see that then, of course, I mean, it could just help you with authoring those flows, right? I mean, with all those LLMs, it might be doable to give you some sort of guided experience there. So that's a big trend for sure. Then I guess another one, I would see more technical, I feel like that's a unification happening, right, of systems and categories of systems. So right now we have, you know, databases here, stream processing engines there. And I feel those things might come more closely together. And you would have real-time streaming capabilities also in something like Postgres itself. And maybe it would expose Postgres as a Kafka broker, in a sense. So I could also see some closer integration of those different kinds of tools. 

Chris Engelbert: That is interesting, because I also think that there is a general like movement to, I mean, in the past we had the idea of moving to different databases, because all of them were very specific. And now all of the big databases, Oracle, Postgres, well, even MySQL, they all start to integrate all of those like multi-model features. And Postgres, being at the forefront, having this like super extensibility. So yeah, that would be interesting.

Gunnar Morling: Right. I mean, it's always going in cycles, I feel right. And even having this trend to decomposition, like it gives you all those good building blocks, which you then can put together and I know create a more cohesive integrated experience, right. And then I guess in five years, we want to tear it apart again, and like, let people integrate everything themselves.

Chris Engelbert: In 5 to 10 years, we have the next iteration of microservices. We called it SOAP, we called it whatever. Now we call it microservices. Who knows what we will call it in the future.  All right. Thank you very much. That was a good chat. Like always, I love talking with you.

📫 Email signup 👇

Did you enjoy this issue of Checkpoint Chronicle? Would you like the next edition delivered directly to your email to read from the comfort of your own home?

Simply enter your email address here and we'll send you the next issue as soon as it's published—and nothing else, we promise!

David Fabritius