I simplify a complex system of gevent with sqlachemy to a simple demo code <https://gist.github.com/tonywangcn/6dadbd58d7778063b0c7969f62505537>.
Before using of sqlachemy, pymysql is my best choice for communication between MySql and gevent because of its easy and direct usage. But now I feel a little confusing, what's the best way to make the two (gevent and sqlachemy) work efficiently. In pymysql case, though some "_io.BufferedReader " errors would happen, it doesn't affect the INSERT or UPDATE operations. In sqlalchemy case, it's quite different in the opposite. Much more errors and little success. After searching around for such errors, some solutions[ https://groups.google.com/forum/#!searchin/gevent/SQLAlchemy/gevent/eGLfR7JV0kk/hg1kicBJeQkJ] for similar error didn't work. Demo code : https://gist.github.com/tonywangcn/6dadbd58d7778063b0c7969f62505537 More details for error https://stackoverflow.com/questions/45113145/the-right-way-to-use-gevent-with-sqlalchemy Thanks! -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.