CODEWITHSUNDEEP
pythondatabaseweb
jlengrand
jlengrand

Reputation: 12827

Update webpage based on sql database

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

Upvotes: 0

Views: 1194

Answers (3)

aychedee
aychedee

Reputation: 25609

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.

Upvotes: 0

Diego Allen
Diego Allen

Reputation: 4653

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.

Upvotes: 1

Daniel Roseman
Daniel Roseman

Reputation: 599778

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.

Upvotes: 2

Related Questions