On Thu, 2010-04-29 at 21:16 +0200, Markus W. Barth wrote:
> I'll be shortly starting a new project and I am thinking of using a rather
> light-weight framework like the werkzeug-based flask. Could anybody on the list
> with wsgi+sqlobject tell me about his/her (positive/negative) experience with
> this combination. As pylons and turbogears2 are wsgi compliant and both are
> supposed to support sqlobject, there shouldn't be any issues, or am I wrong?
I've successfully built a few Pylons apps with sqlobject. One slightly
unusual thing I did was to create a middleware that would catch run each
entire request in a transaction. On error, it would roll back the
transaction and, if the error was possibly recoverable, retry it. This
allowed me to transparently handle things like checking to see if a
username was available, then creating the user if so without worrying
about race conditions.
|