Socket.io + mysql how to sync?

Question

MySQL

I'm trying to make a react application in conjunction with sockets and a mysql database.
I wanted to do something after adding something to the database, threw everything that was added to React through the socket and output it there, but I don’t know how to implement it except as a timer and checking every N seconds

Answer 1

In the normal case, nothing else. In general, for good, there is such an approach as Event Sourcing when, after writing to the database (for simplicity), an event is sent to the queue, which is listened to by an independent handler and responds to the desired websocket pipe