2007/11/7, kettle <[EMAIL PROTECTED]>: > > Hi, I am fairly new to pylons and have what may be a simple > implementation question. I have an html table which displays the > (partial) contents of a database, and I would like to dynamically, and > parsimoniously update this table each time an entry is added to the > database. > (...) > The second solution that comes to mind is to use javascript and a > periodic xmlhttprequest to update the table every n seconds. This is > preferable to the first solution but it doesn't really get at my real > problem, which is how to achive immediate notification upon a state > change in the database. In order to duplicate the effect I have to > call the xmlhttprequest every second, which is quite wasteful. > I'm using mysql to store my data, and I know mysql supports a > TRIGGER function, and I wonder if there might be some way to use this > and a javascript connection that returns only upon timeout or a db > state change? Or maybe that makes no sense at all? I would prefer > not to require the client to install anything on his machine. > If anyone has any ideas about what is or is not possible any help is > welcome.
Forget about TRIGGER ;-) You could use a Comet approach (http://en.wikipedia.org/wiki/Comet_%28programming%29). Look at Orbited (http://orbited.org/) which makes it pretty easy. Orbited has bindings for Python and can be integrated with Pylons (http://orbited.org/tutorials/pylonschat.html). -- Marek Stępniowski email: [EMAIL PROTECTED] || [EMAIL PROTECTED] gg: 5354504 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en -~----------~----~----~----~------~----~------~--~---
