a more erganomic connection pool

[graingert]

something that automaticly connects, reconnects, and checks out connections with optional pessimistic connection checking. With options for connection recycling, size, overflow, lifo/fifo. Similar to https://docs.sqlalchemy.org/en/latest/core/pooling.html#sqlalchemy.pool.QueuePool

[wulczer]

I have to say that would be useful, but I'm not sure it txpostgres is the right project to implement a more featureful connection pool.

The existing implementation exists mostly to be able to easily port from Twisted upstream adbapi.ConnectionPool. I found some generic Python object pool implementations that could maybe be used to build a txpostgres connection pool...

I'll look at the SQLAlchemy pool features, maybe it's not too hard to port it for txpostgres, but I'm afraid it would expand the scope of this project too much.