-> >as long as I'm in the middle of Quixote programming (fixing one project's
-> >session handling & adding it to another project) I was wondering if there
-> >were any example apps out there demonstrating how to do session persistence
-> >with an SQL database?  A 30 second Google search found nothing, and I'd
-> >be happy to make a simple example app.
-> >
-> >(This would have the additional advantage of my code being brutally peer-
-> >reviewed, which I suspect it could use ;).
->
-> Did someone say "brutal peer-review"? What's the smiley for a shark
-> smelling blood in the water?
->
-> Just kidding, I think this would be a great sample to have.

OK, I've got something that's moderately presentable.

Source:

        http://issola.caltech.edu/~t/transfer/sql_example-28.2.04.tar.gz

(unbundled in http://issola.caltech.edu/~t/transfer/sql_example/).

Documentation:

        http://issola.caltech.edu/~t/transfer/sql_example/README.html

Running server:

        http://issola.caltech.edu/sql_example/

Constructive comments, brutal and otherwise, appreciated -- nay, requested.

Notes:

* couldn't figure out a nice way to do transaction handling; will think on it.

* no caching is done.  I believe that with the multi-process model that SCGI
        uses, it wouldn't work properly anyway (or am I wrong?)

* I implemented some changes to the Quixote Session class __init__ function
        that I think should be introduced into the code base; check out the
        'qxsession.py' file.

cheers,
--titus