This sounds quite useful and is something I haven't thought of yet. I  
was rather thinking of problems with connection pooling and similar  
things. Some time ago I have seen some posts concerning issues with  
mod_python+sqlobject but this seems to be solved. As mod_wsgi is  
similar to mod_python I didn't know if there may be issues.

Is your middleware tied to pylons or could it be used on any  
wsgi-compliant framework?
>
> 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.
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> sqlobject-discuss mailing list
> sqlobject-discuss@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>




------------------------------------------------------------------------------
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to