MATLAB Answers

0

Can a listener tell you when a database changes?

Asked by Kieren Bradley on 2 Feb 2018
Latest activity Commented on by Kieren Bradley on 25 Jun 2018
I wish to have a database that is accessed by multiple users and have a figure that will update a graph when another user changes the database. Can a listener be attached to a database object to tell when a particular table has been altered?

  0 Comments

Sign in to comment.

1 Answer

Answer by Arpan Badeka on 22 Jun 2018
 Accepted Answer

Hello Kieren
There is no specific way to achieve this. But what you can do is, have a timestamp column in the database table for which you want to keep the track and a trigger on insert and update that updates this row to now. Have a cron job running which is fetching the count based on the timestamp and updates the graph accordingly.
Thanks,
Arpan Badeka

  1 Comment

Thanks for answering, I was assuming this was the case but wanted confirmation as I may have missed something.

Sign in to comment.