Is it safe to use SQLalchemy with gevent?

python thread-safety sqlalchemy gevent
dpq picture dpq · Oct 27, 2010 · Viewed 9.7k times · Source

I know that some database drivers and other libraries providing connection to external services are incompatible with coroutine-based network libraries. However, I couldn't find out if SQLAlchemy can be safely used with such libraries (namely, gevent), and if any workarounds should be applied to exclude possible errors.

Can you either tell me that or point me to an article where I can read this information? An additional 'thank you' if the provided answer also contains explanation of the mechanics of why it is okay or why it isn't. :-)

Answer

Denis Bilenko picture Denis Bilenko · Oct 29, 2010

Did you try searching gevent google group for SQLAlchemy?

I found this report of using SQLAlchemy + mysql-connector successfully and this of using SQLAlchemy + psycopg2 successfully (make sure you've read this)

I would think SQLAlchemy should be safe to use with gevent as long as the database driver that SQLAlchemy uses is safe, but I've not tried it myself and only basing this on the reports from other users.

Related questions

Thread Safety in Python's dictionary

I have a class which holds a dictionary class OrderBook: orders = {'Restaurant1': None, 'Restaurant2': None, 'Restaurant3': None, 'Restaurant4': None} @staticmethod def addOrder(restaurant_name, orders): OrderBook.orders[restaurant_name] = orders And I am running 4 threads (one …

Read More
Queue.Queue vs. collections.deque

I need a queue which multiple threads can put stuff into, and multiple threads may read from. Python has at least two queue classes, Queue.Queue and collections.deque, with the former seemingly using the latter internally. Both claim to …

Read More
Are global variables thread-safe in Flask? How do I share data between requests?

In my application, the state of a common object is changed by making requests, and the response depends on the state. class SomeObj(): def __init__(self, param): self.param = param def query(self): self.param += 1 return self.param global_obj = …

Read More