Cycloctane

@long2ice Current version of asyncmy is completely unusable with mysql server newer than v8.0.30 when secure transport is required. This pull request attempts to fix it. Could you please consider...

@long2ice Changelog updated.

It seems that uvicorn subprocess somehow crashes with SIGSEGV when setting up firefox for second test... It only happens on github action vm with python3.12+. Cannot figured out the root...

> Note that in the original failure that I reported though, Uvicorn did not segfault. (Different CPython and package versions were in use.) > > I'll check if there are...

> Hm, you may be right @Cycloctane, we might have missed that. OTOH, we do assert the retval to fall within the expected values, so we should have captured that,...

`ClientSession()._request()` creates a temporary CookieJar `tmp_cookie_jar` to handle the cookies from the `request()` parameters. This `tmp_cookie_jar` only uses default (`quote_cookie=True`). https://github.com/aio-libs/aiohttp/blob/24b0e6f7c9d5a0815aebdc0dde5ff9a860a550d9/aiohttp/client.py#L576-L583 If cookies are directly passed to the manually created...

> So, perhaps we should be reusing the settings from the global CookieJar. Think you could turn that into a full test? I wonder how we should implement this. Is...

Sorry for the delay. I've checked codspeed docs. Benchmarking can be done separately with pytest-codespeed. But codspeed's github action does not to support skipping uploading. Codspeed token seems not necessary...

pypy test is failing. Because pyo3 has dropped support for pypy3.10.

> Is the Komi image AI? It is from the magazine cover. Certainly not AI generated.