Re: [sqlalchemy] QueuePool overflowing with websocket server

2017-11-28 Thread Mike Bayer
On Tue, Nov 28, 2017 at 8:12 PM, Colton Allen wrote: > I'm receiving this error: > > sqlalchemy.exc.TimeoutError: QueuePool limit of size 5 overflow 10 reached, > connection timed out, timeout 30 > > > I'm curious how SQLAlchemy manages database connections. I've pasted below > some psuedo-code to

[sqlalchemy] QueuePool overflowing with websocket server

2017-11-28 Thread Colton Allen
I'm receiving this error: sqlalchemy.exc.TimeoutError: QueuePool limit of size 5 overflow 10 reached, connection timed out, timeout 30 I'm curious how SQLAlchemy manages database connections. I've pasted below some psuedo-code to simplify the application. # Create an engine engine =

Re: [sqlalchemy] How to implement a conditional insert (MySQL)

2017-11-28 Thread Mike Bayer
On Nov 28, 2017 12:13 AM, wrote: Hah 🤔 Boy this is (not really) funny. Thank you for digging into this, Mike! I had to make two minor import adjustments from sqlalchemy.sql.elements import quoted_name from sqlalchemy.sql.expression import literal_column but otherwise the code works now. I st