Change Data Capture (CDC) Confluent + PostgreSQL Project with Docker and API Consumer

Setup and Run

1. Install Docker.

2. Start all services:

   docker compose up --build -d

   To stop:

   docker-compose down -v

3. The PostgreSQL service will be initialized with a products table and CDC publication already enabled.

4. For running Kafka Consumer locally

   cd app
   pip install --force-reinstall -r requirements.txt
   uvicorn main:app

Notes

• The Kafka topic streaming the changes is dbserver1.public.products.
• You can use Kafka CLI tools or the Control Center to monitor the topic.
• For production use, make sure passwords and configurations are properly secured.