Is there a simple way to initiate packet transmissions to clients from the database level?
Here’s the scenario:
I have a plug-in that handles custom packets. While processing these incoming packets I update some data in a separate database (or private tables in the Openfire DB, doesn’t matter, just keeping it clean). Some of these updates launch triggers that may result in some updates I need to send out to other clients.
So far all I could come up with is a sort of “message pump”, meaning I’ll have a table that represents a message queue and some server process that will poll this table every x seconds and send the packets to the relevant clients. I don’t like this idea too much because it can be too slow.
So is there any other way to bubble up messages from the low DB level into an Openfire plug-in and out to clients?
Thanks in advance.