In my work there is a database where a ratchet system inserts new fields into the table and the NodeJS application needs to check when new fields are inserted.
What is the best way to monitor a table in real time?
I researched and saw that creating a trigger would not be a good option, I would have to use a socket.io to give a real-time watch in the table?