Thanks Stephen.
From what I've been able to find (i.e. Google) there may be a way to
run a Python or Perl script on the server that would query the database
manager for whatever change is being monitored, and then somehow (insert
magic beans here) signal back to 'interested workstations' (i.e.
subscribers) that things have changed.
Based on my limited knowledge of network protocols, I'm beginning to
think that if the workstation simply checks for changes in the data (via
timestamp or some trigger as you mentioned), the traffic is about as low
as possible.
If I'm not mistaken, the VFP SPT process is always initiated from the
workstation...never from the server.
Stephen Russell wrote:
On Tue, Jun 24, 2014 at 2:12 PM, Mike Copeland <[email protected]> wrote:
Excellent question! Can MySQL or MariaDB initiate contact with and
"signal" a connected user's process?
It just occurred to me that IF this is possible, I'll also need to keep a
list on the server of "subscribers" that should be contacted.
---------------------
Back in the dark ages you just tested if the same data was there. Now we
have disconnected systems.
Now you want 1 computer to rule them all? Lets make a move and make
millions off it?
Why not have a column with an update trigger for a timestamp. You pass to
a sproc the parameters for your update and iit checks if the timestamp is
still valid. If so it updates and if not it replies back that it failed to
update because of new data in place.
Those of you you use an int key just return a negative of the key back.
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
