Streaming Data with Postgres + Kafka + Debezium: Part 2
By the end of this guide, we will have a functioning Streams app that will take input from a topic that Debezium feeds into, make a simple arithmetic operation on one of the columns, then output the result into a new topic.
Streaming Data with PostgreSQL + Kafka + Debezium: Part 1
In this guide, we will use Postgres, Kafka, Kafka Connect, Debezium, and ZooKeeper to create a small API that keeps track of your stock & crypto purchases over time.
Trigger Warning! Setting up Database Tracking with Triggers in Postgres
SQL triggers are less common but can be a great solution for certain situations. I'll provide examples for how to use triggers to enforce data integrity and track changes to a database.