1
In my work there is a database where a turnstile system inserts new fields in the table and the Nodejs application needs to check when it has new fields inserted.
How best to monitor a table in real time?
I researched and saw that creating a Trigger would not be a good option, would have to use a socket. to give a watch in real time on the table?
You could add the code you tried?
– Lucas Kauer
And for fields Do you refer to table same fields or same records? Field is related to column in table, space to store data, already record is the data stored itself.
– Woss
I haven’t made any code yet, I’m new to Node js and I’m in doubt, like it would have to be a loop that keeps checking if there are new fields in the table.
– Norbert
How is the code of "a turnstile system inserts new fields in the table"? it is not possible for that code to share information with the code that checks entered fields?
– Sergio