/blog

I can't believe it's been over a month since the last post. Not very good for someone who's supposed to be back. Still, I've also been struggling to get back to making music again; I've had a couple of ideas and put them on SoundCloud but then not got to building on them despite wanting to.

I know that it's, in part, down to going back to work with the phased return ramping up. I'm currently on 75% of full-time hours and am exhausted at the end of the day.

Hopefully, the two weeks off over Christmas and New Year will give me the chance to reset before returning full time in 2025. I'm also hoping to get some quality music time in, especially with the new gear I'll be getting.

While it hasn't really impacted me, I've had issues with "too many connections" errors being logged by the site.

I've tried a few different solutions including persistent connections and checking for existing ones but still get some errors.

Two separate classes (DBR and DBW) handle queries for reading and writing from/to the database so it was imperative that any solution didn't change this, otherwise every page that needed a connection would have to be changed.

Previous asks of ChatGPT and Claude have resulted in proposed solutions that would effectively need an entire rewrite — not happening. This time I asked Gemini and was a bit more specific. It returned a fairly simple solution for pooled connections that supported the existing ways I query the database and didn't require too much change.

Things seem to be going okay thus far so I'll keep an eye on it. Next up will be looking at why it (very) occasionally creates an empty draft when I log in.