tags:

views:

610

answers:

3
+1  Q: 

jQuery - If a database is updated, update the page...

Righteo, Just started messing with Jquery, and I can update a database etc with it, but I want to know if there is a way to display new info posted into a database (even if it is not what was just posted) without a reload etc.

Don't write it out for me, just point me in the right direction... I want to pull it together myself.. best way to learn :D

A: 

The only way is to have the web page regularly poll the server for new info.

There is no way to initiate interaction from the server side.

Edit:

No way except to use a framework that handles the polling for your.

Kris  2009-05-31 15:34:28
Would this be extremely bandwidth hungry?
Oliver Stubley  2009-05-31 15:35:07
Yes, it would. (15)
Daniel  2009-05-31 15:35:42
Right, I might have to find an alternate method. I was working with a friend of on a project a while back and I cannot remember how it was done - He did all the AJAX while i did php... Maybe he just did refreshes and fooled me o.O
Oliver Stubley  2009-05-31 15:38:37
Yes, it's bandwidth heavy, so the longer you can spread out your updates, the better.
Nosredna  2009-05-31 15:38:46
This need not be very bandwidth heavy. Typical usage will have polling run every 1-5 seconds at most (longer if 'immediate' notice isn't needed. A poll that finds no new data should only require a minute amount of bandwidth (the request is not probably under 1 KiB and the response is tiny).
Kris  2009-05-31 15:43:39
Ah thanks Kris, I will give this a trial run and have a look how it goes, if its not that heavy then i guess it will do :D
Oliver Stubley  2009-05-31 15:48:35
Nosredna  2009-05-31 15:49:22
+1  A: 

Easiest solution is to poll to server periodically.

If you want the server to push to you, use Comet.

Nosredna  2009-05-31 15:37:11
Thanks, I will take a look.
Oliver Stubley  2009-05-31 15:39:53
A: 

You might also want to see http://stackoverflow.com/questions/136012/comet-and-jquery

Darth  2009-05-31 15:38:37

related questions

What language do you use for Postgresql triggers and stored procedures?
Are Multiple DataContext classes ever appropriate?
Which tools do people use to create Data Dictionaries?
Any experiences with Protocol Buffers?
Mechanisms for tracking DB schema changes
How big can a MySQL database get before performance starts to degrade.
How do I index a database field
How does database indexing work?
How do I connect to a database and loop over a recordset in C#?
Editing database records by multiple users
Object Oriented vs Relational Databases
VFP .NET OLEdb provider does not work in Win 64-Bits. Help
Embedded Database for .net that can run off a network
Connect PHP to an AS/400
Swap unique indexed column values in database.
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?
.NET Migrations Engine
Is there a version control system for database structure changes?
SQLite and XSD
How do I version my MS SQL database in SVN?
XSD DataSets and ignoring foreign keys
Flat File Databases in PHP
Throw Error In MySQL Trigger
Binary Data in MySQL