Python, Postgres and Ajax/ Jquery update page realtime with databse values

Question

I'm familiar with PHP and MySQL, however I need to find a way to update a web page each time a value changes in my database asynchronously, with a Python backend, a Postgres database, and maybe Jquery / Ajax to handle the asynchronous part. I know MySQL doesn't support triggers on database changes and I believe Postgres does. Can anyone point me in the right direction? I think polling would be a resource expensive method of doing this.

You can use triggers and the PostgreSQL notification system to get async notices whenever anything happens, but I don't know how to integrate this with your frontend. — Daniel Lyons
– Daniel Lyons, Commented Mar 8, 2012 at 7:03

Community · Accepted Answer · 2017-05-23 12:07:25Z

3

At a specific interval of time, send a jquery ajax request from client browser and get the latest data from server. If data have been changed, then display the new data else leave it. You can do all this stuff in client side.

Here is is the thread that explains setting timer and doing a ajax call.

edited May 23, 2017 at 12:07

CommunityBot

11 silver badge

answered Mar 8, 2012 at 7:26

thavan

2,48924 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python, Postgres and Ajax/ Jquery update page realtime with databse values

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related