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?
댓글 수: 0
채택된 답변
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
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Reporting and Database Access에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!