Re: [sqlalchemy] Re: sqlalchemy + beaker cache

2011-07-29 Thread Michael Bayer
An association proxy is a Python descriptor attached to a class and by itself is not anything like the InstrumentedAttribute/relationship() object used for a relationship. So it cannot be passed to mapper options that expect InstrumentedAttribute, or those options need to be enhanced to

[sqlalchemy] Re: sqlalchemy + beaker cache

2011-07-29 Thread espresso maker
Thanks for the explanation. I think a .property accessor on AssociationProxy is the right solution. Right now I am doing something of this sort: User.groups._get_property().comparator but not sure if that's what should be done or not. On Jul 29, 7:20 am, Michael Bayer mike...@zzzcomputing.com

[sqlalchemy] Re: sqlalchemy + beaker cache

2011-07-28 Thread espresso maker
Anyone know of another sqlalchemy + beaker example I can look it? On Jul 27, 2:05 pm, espresso maker espressso.ma...@gmail.com wrote: Hi there, I am trying to follow the setup in this examplehttp://www.sqlalchemy.org/trac/browser/examples/beaker_cachingto enable beaker caching in

[sqlalchemy] Re: sqlalchemy + beaker cache

2011-07-27 Thread espresso maker
Another issue I run into intermittently is the following: TypeError: can't pickle function objects Module myproject.lib.account_api:98 in get_user view get(user_id) Module sqlalchemy.orm.query:637 in get view return self._get(key, ident) Module sqlalchemy.orm.query:1968 in

[sqlalchemy] Re: Sqlalchemy beaker cache and memcached

2011-06-09 Thread Łukasz Czuja
Thank you for a quick response. It's much appreciated. Let me be more specific: 1. Do you use the code provided in the above link? If not how do cache and retrieve results via query.options() or cache.get() and then session.merge() ? 2. Do you use it in any framework like pylons or diango? 3. My

[sqlalchemy] Re: Sqlalchemy beaker cache and memcached

2011-06-08 Thread BenH
Hi, I use Beaker in production to help speed up the delivery of game content. We've seen enormous (seconds to milliseconds) speed ups for caching large queries that don't change. We don't use it at the query level but as a way to cache whole results from sqlalchemy. As long as you remember to