Re: Realtime connection to postgres database

Sounds like a good cron job candidate.=20

Best,
Karl

Sent from losPhone

> On Oct 25, 2020, at 4:43 PM, Aziz Saleh <[email protected]> wrote:
>=20
> =EF=BB=BFAnother way to do this is to have an ajax call on timeout to an u=
pdate
> endpoint, if there is an update inject that update on the page (or refresh=

> it).
>=20
> Some js examples (both short/long polling):
>=20
> https://stackoverflow.com/questions/42825972/update-html-when-change-is-no=
ticed-in-mysql-database
> https://stackoverflow.com/questions/22577457/update-data-on-a-page-without=
-refreshing
> https://stackoverflow.com/questions/8100594/refresh-content-automatically-=
if-the-database-changes
>=20
>=20
>> On Sun, Oct 25, 2020 at 5:18 PM Rodrigo S=C3=A1nchez <[email protected].=
cl>
>> wrote:
>>=20
>> Hi everyone,
>>=20
>>  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?
>>=20
>>  Excuse the question if it is very obvious, but I am not a "full" time
>> php programmer.
>>=20
>>  (PHP 7.4.11, postgresql 9.6.19)
>>=20
>>=20
>> --
>> ++++++++++++++++++++++++++++++++++++++++
>>  Rodrigo S=C3=A1nchez-Olavarr=C3=ADa
>>  CSN, Centro Sismologico Nacional
>>  Universidad de Chile
>>  Celular : +56 9 42137243
>> ++++++++++++++++++++++++++++++++++++++++
>>=20
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>=20
>>=20

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php