Re: scaffold/cpdeploy.py - cherryd - DeployTemplate

On Nov 24, 2:26 pm, dundeemt <dunde...@...> wrote:
> On Nov 24, 3:32 am, Pete H <pe...@...> wrote:
<snip>

>
> Pete,
> Thank you for your example.  I'm just starting to go over it now.  I
> am sure to learn much from it.
>
> Do you know if subscribing to 'start_thread'/'stop_thread' needs any
> modification over the different deployment scenarios?  I will be using
> mysql and I'd like to explicitly close down db connections before
> threads go away.http://tools.cherrypy.org/wiki/Databases

Not as far as I know, though it's only been live with cgi and
mod_wsgi. Obviously the threads issue doesn't arise with cgi.

I'm using the recipe in the wiki with the psycopg2 driver - seems to
be the only one that's current at the moment anyway. So far it 'just
works'.

I should add that so far my database is read-only - though when it
does become read/write I don't expect many concurrent connections
since the only write operations will be by the society secretary and
those members registering stock - and out of say 1000 members there
won't be many doing that at the same time.

In fact since mod_wsgi works so well (thanks Graham!) I can't really
envisage ever going back to mod_python since it's no good for me in a