feat: add support for asyncpg driver

[jackwotherspoon]

Todo:

• Wait for 0.26.0 release of asyncpg
• Determine how to use creator argument or similar for SQLAlchemycreate_async_engine
• Update README with asyncpg connection example

Closes#218

[kurtisvg]

nit: this connection should probably use an async with

[jackwotherspoon]

the connector or connection itself? async with create_async_connector() or async with connector.connect_async(...) ?

[kurtisvg]

The connection itself.

Do we support async enters and exit with the Connector?

[jackwotherspoon]

not currently, we don't have an __aenter__ or __aexit__ implemented.

[jackwotherspoon]

I added the ability to create an async context manager with Connector and added example to README. I can't use async with for the connection because the asyncpg.Connection class does not have an __aenter__ or __aexit__. We could potentially create a Connection wrapper class of our own to implement an async context manager for the database connection. (Example). However, if in a future PR we are going to support connection pools (either through SQLAlchemy or native asyncpg.Pool then they will have context manager built in so not sure it is worth it to create the wrapper class.

[kurtisvg]

Ok, this is surprising to me that they don't support those two functions. I think it's fine to leave for now (maybe worth asking why they haven't?)

[jackwotherspoon]

Seems like there is an open issue for it actually, if I have some spare time I will try and put up another PR to asyncpg and add the two functions.

[kurtisvg]

Ok, this is surprising to me that they don't support those two functions. I think it's fine to leave for now (maybe worth asking why they haven't?)