Support SQLAlchemy dialect with asyncpg

[amotl]

Hi there,

after closing #100 and bringing in crate/crate-python#391, we may want to look at SQLAlchemy support for Python asyncio. Currently, trying to invoke the CrateDB driver like postgresql+asyncpg:// croaks like

>>> from sqlalchemy.ext.asyncio import create_async_engine
>>> create_async_engine("crate+asyncpg://crate@localhost/test")
sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:crate.asyncpg

So, the CrateDB dialect will have to be accompanied by a special asyncio mediation layer, like dialects/postgresql/asyncpg.py.

With kind regards,
Andreas.

[robd003]

Couldn't async be implemented with aiohttp so that support for connecting to a cluster instead of a single node would still be available?

Is there a way to connect to Crate from asyncpg so that it will round-robin requests between nodes?

[amotl]

Hi. This patch will add relevant support for asyncpg. It has been lingering for quite some time, we hope to be able to wrap it up soon.

• Dialect: Add support for asyncpg and psycopg3 drivers #11