CentOS - Feb 2018 - OT - pushing database updates to web browser

This is O/T apart from the fact that the server is Centos running Apache / 
Postgresql.

I want to develop a real time (ish) dashboard type web page showring extracts 
of the contents of a table.  I would like any changes that occur to be pushed 
to the web clients rather than have the clients poll the database.

Based on the fact that I have not managed to come up with a successful Google 
search phrase I think this may not be possible, but just in case I thought 
I'd ask here.

If it's not possible, can anyone suggest the most efficient / responsive 
polling techniques?

Hello Gary,
> I want to develop a real time (ish) dashboard type web page showring 
> extracts
> of the contents of a table.  I would like any changes that occur to be 
> pushed
> to the web clients rather than have the clients poll the database.
> 
> Based on the fact that I have not managed to come up with a successful 
> Google
> search phrase I think this may not be possible, but just in case I 
> thought
> I'd ask here.
Search for websockets and html5.

eg. 
http://srchea.com/build-a-real-time-application-using-html5-websockets

all the best,
   Timotheus

----------------------------------------------------------------
Diese Nachricht wurde versandt mit Webmail von www.tbits.net.
This message was sent using webmail of www.tbits.net.

> Am 07.02.2018 um 14:53 schrieb Gary Stainburn <gary at
ringways.co.uk>:
> 
> This is O/T apart from the fact that the server is Centos running Apache / 
> Postgresql.
> 
> I want to develop a real time (ish) dashboard type web page showring
extracts
> of the contents of a table.  I would like any changes that occur to be
pushed
> to the web clients rather than have the clients poll the database.
> 
> Based on the fact that I have not managed to come up with a successful
Google
> search phrase I think this may not be possible, but just in case I thought 
> I'd ask here.
> 
> If it's not possible, can anyone suggest the most efficient /
responsive
> polling techniques?
A combination of javascript (client-side) and XMLHttpRequest (interaction) ...

--
LF

On Wednesday 07 February 2018 14:57:47 Timotheus Pokorra
wrote:
> Search for websockets and html5.
>
> eg.
> http://srchea.com/build-a-real-time-application-using-html5-websockets
>
> all the best,
>    Timotheus
Thanks for this. Looks a very interesting article, and exactly what I'm 
looking for.

Thanks Leon for your reply too.  I do already make use of JS and 
XMLHttpRequest in my pages but they are all driven by the client / JS code.

The new project will see 20+ users all managing a jobs list status page. 
Rather than have all 20+ browsers poll the server every n seconds, I want a 
method where if one user updates a job status it updates the server, and the 
server then kicks the other clients into pulling the update.

The websockets above may well be the answer I need.