So I have a windows app designed to monitor an integer value (simply 0 or 1) from my hosted database via my web api. So when a user changes this value from an android or ios app the value will be either a 0 or a 1, if it is a 1, the windows app will need to do something in my program and then change it back to a 0 to continue to monitor or poll for when this value changes again. I know I can do this through a timer and get that value every second or so but I feel there is a more efficient way to do this. Any help please?
Asked
Active
Viewed 35 times
0
-
1use a database trigger – Jason Aug 05 '22 at 15:53
-
Is this database trigger done in MSQL or in an SQL query on the server? Any examples? – aviles622 Aug 05 '22 at 20:17
-
1Your post doesn't provide any detail about the db you're using. Google "database trigger" and your DB platform – Jason Aug 05 '22 at 20:18
-
I suspect what you are looking for is a "push notification". Research that concept and see if it is what you want. – EddieLotter Aug 07 '22 at 18:23