How to receive messages from the base?

Question

Database

I keep a snapshot of the table (obtained from the database via node.js) in memory. Each time after making changes to the database, you need to update the snapshot itself. How can this be done without querying the database? Is there a way for the base itself to tell Node that there are changes - and only then do I connect and update the data? For example, the database can write something to some buffer or environment variables.
Is there such a possibility? What words to google?

Answer 1

Can. You send POST/GET requests from the database to your node server:
https://stackoverflow.com/questions/17407338/how-c...
https://www.botreetechnologies.com/blog/how-to-fir. ..
Google for: "ms sql server post url"
Just keep in mind that this is an expensive operation and a relational database is not designed for such purposes. It is rarely possible to do this, under heavy load - it is impossible.