I am using Quixote and SQLObject with MySQL underneath.
With the exception of session managemnt, which is lousy in Quixote, this works pretty well. I build a HTML-layout with an abstract Python class, coded in PTL. Every web page that is using the template, is a subclass of that abstract class, which results in structured, easy to maintain site. The startup code was bad in Quixote 1.x but is much improved in 2.x, giving me the opportunity to switch from medusa during development to apache + mod_scgi for deployment