I’ve pushed some code that, I think, will take care of the web-server crashes you may have experienced on the site. They were due to some thread-unsafe code on my part.

While deciding on some way to correctly handle DB connection pooling, I tried to dig into SQLAlchemy. I’ve heard really great things about it, so I really put an effort to work my way trough it’s massive documentation. After some hours of pain and frustration, I pretty much realized the thing is overkill for simple connection pooling.

In the end, I decided to go with  DBUtils. Little overhead and seems to be working great so far.



2 Responses to “More bugs squashed”  

  1. 1 mike

    did you read :

    http://www.sqlalchemy.org/docs/05/pooling.html#pooling_establishing ?

    Usage of SQLA’s pool alone is literally a matter of one line of code.

  2. No, I didn’t even get to that part of the docs. Thanks for the link :-) I’m going to give it another stab more calmly over the weekend.


Leave a Reply