How can I understand in NodeJS that the table has changed (and notify the client further)?

Question

MySQL

Those. about the client/server connection itself, I understand how it's done and how I can send requests.
But how to run a function on the server that will determine that the table has changed, and immediately send the information to the client? Those. how to me to track the fact of change of the table.
PS: I want a way without using timers and reading / comparing with the old timer data, the only way that comes to my mind is to track all INSERT / UPDATE / DELETE (and then immediately send information after them that the table has changed), but if I manually change the data in the SQL editor, it won't work anymore :)

Answer 1

Use RethinkDB , it was created just for this purpose.

Answer 2

Do you only have a node in charge of database modifications? if yes, then in the code where you do this, add the dispatch of the event, add the dispatch of the event myemitter('emit'..... and hang up myemitter.on('emit'... event handling.
Docs for reading here

Answer 3

Ideally, to work with the base, you need to create a separate class in which you can call anything on the corresponding methods.

Answer 4

As already suggested above, rethinkDB is an ideal option.
But if relationals are fundamental, then we write triggers on the necessary tables, which add up the necessary changes separately, and the script periodically checks them