Re: Realtime connection to postgres database

--0000000000002b4f5f05b285b231
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Another way to do this is to have an ajax call on timeout to an update
endpoint, if there is an update inject that update on the page (or refresh
it).

Some js examples (both short/long polling):

https://stackoverflow.com/questions/42825972/update-html-when-change-is-not=
iced-in-mysql-database
https://stackoverflow.com/questions/22577457/update-data-on-a-page-without-=
refreshing
https://stackoverflow.com/questions/8100594/refresh-content-automatically-i=
f-the-database-changes


On Sun, Oct 25, 2020 at 5:18 PM Rodrigo S=C3=A1nchez <[email protected]=
>
wrote:

> Hi everyone,
>
>   I made a table in html that reads a table from a postgres database
> (easy part).  The postgres database grows every time an earthquake
> occurs. What is the best way to keep the table updated automatically,
> each time a new earthquake is added to the database? (I mean, not having
> to update by clicking on the browser). The ugly way to do it is by using
> something like header ("refresh: 3"); for example ... but isn't there
> something better?
>
>   Excuse the question if it is very obvious, but I am not a "full" time
> php programmer.
>
>   (PHP 7.4.11, postgresql 9.6.19)
>
>
> --
> ++++++++++++++++++++++++++++++++++++++++
>   Rodrigo S=C3=A1nchez-Olavarr=C3=ADa
>   CSN, Centro Sismologico Nacional
>   Universidad de Chile
>   Celular : +56 9 42137243
> ++++++++++++++++++++++++++++++++++++++++
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

--0000000000002b4f5f05b285b231--