Just noticed this not responded topic... maybe I can still help.. The Pylons session (nor even Java/Hibernate) DOES NOT have any knowledge of any parallel changes to underlying database that you use. So you a) shouldn't do concurrent modifications on database b) if you have to, then like you suggested: pool some DB info with some frequency.
T. On Nov 10, 2007 9:13 AM, kettle <[EMAIL PROTECTED]> wrote: > > Maybe I can rephrase this more simply. I want to know if my pylons/ > sqlalchemy session has realtime knowledge of the database it is > working with, or if the only way to achieve this is through a stored > procedure or constant polling. -joe > > > On Nov 10, 4:57 pm, kettle <[EMAIL PROTECTED]> wrote: > > Hi, > > I am new to pylons/sqlalchemy, and not sure whether this question > > belongs in a sqlalchemy forum or this pylons forum but... basically > > I'd like to know what kind of awareness the sqlalchemy model for my > > pylons application has of the database. Specifically, does it have > > any kind of realtime knowledge of the database with regard to table > > updates or row insertions? If I want to know about updates to the > > database (many of which are coming from remote clients) and convey > > this information or log it in my pylons application, is there any way > > to do this without constantly polling the database, and if possible, > > also without implementing a trigger in the db, or an in memory copy of > > the latest updates/insertions? > > If sqlalchemy already has this awareness, how can access it/leverage > > it for my application? > > -joe > > > > > -- _i______'simplicity_is_the_key'__________tomasz_nazar _ii____'i_am_concern_oriented'________________JKM-UPR _iii__'patsystem.sf.net'___________________linux_user _'aspectized.com'___________________________prevayler --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to pylons-discuss@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
