How do I get my system after sending a record to the bd, users who are online receive such notification by action. Example: User added a client to a queue, at which point the system writes this record to the queue table, in the next action the system would send to a determine user group (online) that such a client is in the queue. queue.
I've also been through this when trying to implement a feature that changes the front-end in real time.
What I found interesting to solve this problem was about sockets. As you have the PHP and javascript tags I suppose it is for web, so more specifically you can search for WebSockets.
There are ready-made (hosted) and self-hosted tools. Of the hosted ones, the one I liked the most was the Pusher. Already of self-hosted I found Ratchet, for PHP, very good and easier to work, however there is a more complete call ReactPHP.
You can also use Firebase, a Google service that has real-time database functionality. Tailoring it to your needs can also be used for this purpose.
