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

2 views (last 30 days)

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

Products

Database Toolbox

1 Answer

Link

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

Kieren Bradley on 25 Jun 2018

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

Products

Database Toolbox

You are now following this question

Kieren Bradley (view profile)