Can a listener tell you when a database changes?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Kieren Bradley
am 2 Feb. 2018
Kommentiert: Kieren Bradley
am 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 Kommentare
Akzeptierte Antwort
Arpan Badeka
am 22 Jun. 2018
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
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Reporting and Database Access finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!