how to handle CDC(change data capture) in spring boot

[subtle ermine]

I am using postgresql so any solution for it I want to send the message to the Websockets whenever there is an update in database any sort of like any CRUDE operation

[rustic whale]

<@&1004656351647117403> please have a look, thanks.

[lost pond]

I'm using debezium for postgresql connector.
When data change, it will send event messages to Kafka.
https://debezium.io/documentation/reference/2.7/connectors/postgresql.html#postgresql-events

And then, u can consume these messages and resend to Websockets in your spring boot application.

[subtle ermine]

Thanks bro

[subtle ermine]

What if there is any update and I want to fetch all the data with that change event not just the changed data

[lost pond]

What does 'fetch all the data with that change event' mean? Do you want to retrieve both the data before and after the change?