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 -~----------~----~----~----~------~----~------~--~---
