Re: [PHP-DB] Realtime connection to postgres database

2020-11-09 Thread Karl DeSaulniers
Is this what you are looking for? https://www.postgresql.org/docs/9.6/monitoring-stats.html or maybe this? https://github.com/supabase/realtime Google Foo: real-time connection to postgresql

[PHP-DB] Realtime connection to postgres database

2020-11-09 Thread Rodrigo Sánchez
Hi everyone, I have a table (html), that is connected to postgresql database (v9.6). I want that every time there is a change in the database, the table changes immediately. I am talking about a realtime connection between html table and postgres database via php (v7.4). (without having to

Re: [PHP-DB] Realtime connection to postgres database

2020-10-26 Thread Karl DeSaulniers
Sounds like a good cron job candidate. Best, Karl Sent from losPhone > On Oct 25, 2020, at 4:43 PM, Aziz Saleh wrote: > > 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

Re: [PHP-DB] Realtime connection to postgres database

2020-10-25 Thread Aziz Saleh
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-noticed-in-mysql-database

[PHP-DB] Realtime connection to postgres database

2020-10-25 Thread Rodrigo Sánchez
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