>I've been looking at the pool module for keeping my MySQL connection
>alive. I understand how to do it, but how do I keep my connection safe
>from other users on the server?
To the best of my knowledge, Python does not currently support
sandboxing (aka restricted execution, isolation) like Java and many
other safe languages do. Therefore, it's difficult, and perhaps not even
possible, to separate multiple untrusting users/scripts within the same
Spyce engine. There was some effort to create a restricted execution
environment in Python (search for python with one of rexec, Bastion,
sandbox), but flaws were discovered in each of the designs.
If the users are trusted, you could certainly place the username as part
of the key used to access the pool, thus sharing the namespace. If you
have suggestions on how to make things "safer" in multi-user
environments, I'd be interested to hear about them.
All the best,