I recently bought a couple of Arenti baby cams. They are cheap, have good image quality, and are easy to set up. I also wanted to integrate them into Home Assistant. This is how I did it.

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.