[Feature] mypy typings

[bryanforbes]

Currently, asyncpg is untyped and has to be ignored as an import when using mypy. Because of this, I created an asyncpg-stubs package generated from stubgen that I use in my own projects as a git dependency, but it would be great to have these in the main library (and verified by the developers). If this is something that is desired, I would be willing to create the initial PR.

[1st1]

Yeah, we would love to see typing support in asyncpg.

[cstigen]

Any update on whether asyncpg-stubs is planned to get merged into asyncpg?

[DanielNoord]

@1st1 #577 seems a bit too big to merge and review, but there is lots of stuff in that PR that can easily be merged and will help reduce the noise around the more critical/problematic changes. To give an example def _check_conn_validity(self, meth_name: str) -> None:.

Does it make sense to start splitting off some of those contributions into separate PRs so that they can be merged and users can benefit from improved IDE suggestions as well as get #577 more manageable (and therefore more mergeable)?

[DanielNoord]

@elprans I know maintainers time is limited, but you just made a release and therefore seem the most active.

I would like to dedicate time to getting type annotations for asyncpg to at least partially work, but it seems there is limited time to review PRs. Is there anyway that would make it feasible for you to review PRs that add type stubs without changing features of the package?

[elprans]

Happy to review if the typing-adding PR is split. It's nearly impossible to confidently review #577 as-is.

[DanielNoord]

Cool! I made a first PR to test the waters here: #1197

Let me know if there is anything you need from my side.

[nicholas-johnson-techxcel]

The Pool in asyncpg-stubs does not match the Pool in this package, they need to be unified.

[nicholas-johnson-techxcel]

Okay have to use psycopg. It's a bit weird to show off in the README.md about performing 5x as fast as psycopg when this asyncpg cannot even be imported and compiled and run.

[nicholas-johnson-techxcel]

I can pull request this and bring this up to py313 syntax with py.typed if you are willing to accept.