MySQL db watcher
Posted 26 October 2006 - 04:00 AM
what I know that we can use file system watcher using VB.Net and watch the database files for change, but that would be very generic and any change in the database would refresh the page.
Posted 26 October 2006 - 04:30 AM
Or, building on the file system watcher, you could have the process which creates the new database record also create a file (or update a file). Then your file system watcher can be triggered.
Posted 26 October 2006 - 04:45 AM
Posted 26 October 2006 - 07:34 AM
What I was suggesting was to have something like
mysql_query("UPDATE ... "); touch("/tmp/database_is_updated");
The idea being to actively create/modify a file to indicate that an update has happened. It could also be done with a trigger depending on your DBMS. If you can have a trigger which modifies a file whenever the specific field is updated, and a file system watcher which notices that, then that file can be a method of signalling the watcher that a change has occurred.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users