How to use SQLAlchemy in this context

Question

I want to do the following:

• Have a software running written in Python 2.7
• This software connects to a database (Currently a MySQL database)
• This software listen for connections on a port X on TCP
• When a connection is established, a client x request or command something, then the software use the database to store, remove or fetch information (Based on the request or command).

What I currently have in head is the classic approach of connecting to the database, store the connection to the database in an object (as a variable) that is passed in the threads that are spawned by the connection listener, then these threads use the variable in the object to do what they need to do with the database connection. (I know that multi-processing is better then multi-threading in Python, but it's not related to my question at this time)

Now my question, how should I use SQLAlchemy in this context? I am quite confused even although I have been reading quite a lot of documentation about it and there doesn't seem to be "good" examples on how to handle this kind of situation specifically even although I have been searching quite a lot.

Answer 1

What is the problem here? SQLAlchemy maintains a thread-local connection pool..what else do you need?