Re: [SQLObject] wsgi and sqlobject

[David T. <no...@op...>]

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.