Can a listener tell you when a database changes?

1 次查看(过去 30 天)
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?

采纳的回答

Arpan Badeka
Arpan Badeka 2018-6-22
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 个评论
Kieren Bradley
Kieren Bradley 2018-6-25
Thanks for answering, I was assuming this was the case but wanted confirmation as I may have missed something.

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Reporting and Database Access 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by