How can I communicate with other client connections on a MySQL server using python?
How can I communicate with other client connections on a MySQL server using python? I have multiple computers running python applications, each using the same MySQL server. Each of the applications contains a tkinter GUI that allows editing of a set of data (corresponding to data in a table in the MySQL server). Whenever the data is updated one machine (and in turn updated on the MySQL server), I would like the other machines to be prompted to update there displayed data by pulling from the server. I know I could simply have the applications self-update after a given interval, but I would prefer to only update when there is new data to pull. How should I go about this? sounds like you need to dig into MySql Triggers, maybe this answer would help stackoverflow.com/questions/17336804/… – kztd Jul 1 at 2:37 2 An...