SQLAlchemy and PgBouncer

At work we use SQLAlchemy as our ORM, and we were having issues with some connections getting stuck in the pool. We use PgBouncer as our connection pooler, so I started looking into the issue and I found that there's not a lot of information out there about how to configure SQLAlchemy and PgBouncer together. I found a few blog posts and StackOverflow answers, but they were all incomplete or outdated. So I decided to write this post to document what I've learned.

Read more  ↩︎

Smart home

Smart homes are all the rage these days. I've been tinkering with mine for a while now, and I've learned a few things that I'd like to share. This is a work in progress, I'll be adding more content as I go.

Read more  ↩︎