thanks a bunch. that was a great lead! On Nov 7, 7:33 pm, "Marek Stępniowski" <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
