Apologies in advance if this is not the right catagory but I’m looking for advise on push technology.
Currently have a Flash driven app with PHP middle tier and mySQL backend. At present I have a PHP script that runs a query to get the current status of beds in a hotel. I’m using a red, amber, green status type approach for bed volumes but as things grow I’ll end up with a lot of queries being fired off when there are’nt actally any changes to report. What I’d like to do is explore the possibility of pushing the data to users.
Scenario:- multiple hotels, multiple users per hotel. If a hotel bed status drops I need to push this data to the group of users in that hotel only.
I’ve read about Sockets, xml sockets, RTMP, Amfphp Adobe media server (very expensive for what I want) and node.js which looks promosing but have no experience whatsoever.
To be frank I’m drowning in a sea of information but its all very ‘bitty’ and very ‘game dev’ centric. I’m looking for meaningful guidance on how I could push the results of this current query to a group of users or doesn’t push work like that?
Thanks in advance