Hello Pyramid gurus,

I have been searching for quick tutorials on caching, background jobs
& ORM related topics. I found quite a few resources which seem to be
very informative. Since I am new to both Python & Pyramid, I thought I
will seek experienced people opinion, before I go ahead and use
anything I found on web. Any help is very much appreciated.

1. Caching:
    The simple use case is:- I want to show top 10 or 20 articles on
my wiki application. Before I render the data I would like to cache
the db result upon first query execution and cache it. Cache to
refresh automatically after every 1 hour or so.

2. Background Jobs:
    I am using SQLAlchemy in my application.
All the data needed for the application comes from XML/CSV files. Is
there any way in Pyramid I can create a background job and schedule it
to run every 30 minutes or so?. Job will look at one particular folder
everytime it is run, and if there are any xml/csv files job will pick
it up and process them. Since this is simple ETL job, SQLAlchemy is
not aware of the DB changes. So does this confuse any of the ORM
caching mechanism and show the dirty data? If so, how would I be able
to notify ORM to rebuild its caching?

Thanks for your time.

cheers
-Bkumar

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

Reply via email to