Skip to content

Support SQLAlchemy dialect with asyncpg #79

@amotl

Description

@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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions