Update webpage based on sql database

Question

As a non webdev, I'd really like if you could point me out to the 'correct' way to do this.

I built an application that populates and updates a database periodically (sqlite to be precise). I store leaderboards in my database, and would like to display them in a webpage.

As my leaderboards can change all the time, I need the webpage to be dynamic, either on a time based trigger or whenever the database changes.

I was about to use javascript for that, by realized that my database is hosted on my server, so client side js might not work.

Any ideas on that?

As my app is built in Python, I'd prefer avoid using php solutions but use more 'trendy' technologies (js, ruby, python, ? ? ? whatever)

Thanks!

Ok, given the keywords I got now here is an almost exact duplicate : Notify user on database change? JavaScript/AJAX

OP here. It's beautiful sometimes coming here later seeing how much I've learnt :). Much of it thanks to SO right there. Here's to daily learnings! — jlengrand
– jlengrand, Commented Feb 13, 2023 at 13:48

Daniel Roseman · Accepted Answer · 2013-01-14 13:41:15Z

2

This is what Ajax is for. You write Javascript on the front end that uses Ajax to call your server-side code to return the database content, then updates your HTML when it receives a response.

answered Jan 14, 2013 at 13:41

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

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

2 Comments

jlengrand Over a year ago

argh, yet another layer between my app and my user :s. Would you use AJAX directly, or through a framework or something ?

Daniel Roseman Over a year ago

If you're completely new to it, probably better to use something like jQuery which takes care of some of the complexities.

Diego Allen · Accepted Answer · 2013-01-14 13:48:16Z

1

You need to use javascript on the client side not on the server. Your javascript code will make async calls (using ajax) to check if the db changed and update the website accordingly.

answered Jan 14, 2013 at 13:48

Diego Allen

4,6535 gold badges32 silver badges33 bronze badges

Comments

aychedee · Accepted Answer · 2013-01-14 14:14:04Z

0

You can either use javascript to poll the server side periodically. Or you can use javascript to create (perhaps using a library like SockJS or SocketIO) a websocket connection that can actually push data to the client side when it changes. I do this on a number of projects using Tornado's websocket support on the server side.

answered Jan 14, 2013 at 14:14

aychedee

25.7k8 gold badges82 silver badges83 bronze badges

2 Comments

Shane Hsu Over a year ago

Sorry to bother, will creating a WebSocket for each user use up more resource than letting the client poll. What's the pros and cons for the two methods?

aychedee Over a year ago

More resources, it keeps a socket open on the server.

Collectives™ on Stack Overflow

Update webpage based on sql database

3 Answers 3

2 Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related