allensr
2nd October 2006, 20:14
I am building a Qt/MySQL application that will visualize data stored in a MySQL database. The app now works as a post-process application (ie a simulation runs, dumps all of its data to database, and then my app visualizes the data). We want to make the app into a real-time visualizer. Is there a mechanism in MySQL that can send a message when a table/column has a record added/updated (ie time is changed, position has updated)?? My observers of my platforms need to be updated when their data has changed. I've read some on MySQL Triggers/Stored Procedures, but not sure if this is the right approach. Any help here would be greatly appreciated.