I'm writing a relatively simple multi-user public Web application with Python. It's a rewrite of a similar application which used PHP+MySQL (not particularly clean code, either). My opinions on various Web frameworks tends to vary with the phase of the moon, but currently, I'm planning to use Quixote.
Good choice, IMO! And while you're using Quixote, you might want to look at QLime [1] for all your data storage needs :)
I've looked at SQLObject, and it's very nice, but it doesn't provide certain features I really want, like the ability to store lists of strings or integers directly in the database (using commas in a varchar column or something).
In any mapper that lets you set attributes for storing columns (such as QLime), this should be fairly simple using properties.
My ideal solution would be an object database (or object-relational mapper, I guess) which provided total transparency in all but a few places, built-in indexing, built-in features for handling schema changes, the ability to create attributes which are required to be unique among other instances, and built-in querying with pretty syntax.
Briefly, QLime uses RDBMS indexing, automatically handles schema changes (in fact you don't define the schema in Python at all, you just create the table). For uniqueness you'd have to set the constraint on the table. To look at the query syntax avaialable, (and OR mapping features) see http://www.qlime.org/0.5.1/qlime_or_mapping.html.
Cheers, Shalabh
[1] http://www.qlime.org/
-- http://mail.python.org/mailman/listinfo/python-list
