Also, I am using sqlalchemy with pylons. kettle wrote: > 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 first, simplest, crudest solution that came to mind was > implementing an html refresh option directly in the html for the > template. This is not very nice. > 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. > > thanks!
--~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
