Backlog

1. Missing test cases

C'est la vie. Please use the provided example programs until we have them.

2. Still using PGDDLCompiler

There is more work to do, to make the hybrid dialect use theCrateDDLCompiler instead of thePGDDLCompiler. Otherwise, when defining a column withautoincrement=True, it will obviously croak, because it will render theSERIAL type, which CrateDB does not understand.

sa.Column("x",sa.Integer,primary_key=True,autoincrement=True)

CREATETABLEtestdrive (xSERIALNOT NULL,yINT,PRIMARY KEY (x))

sqlalchemy.exc.InternalError: (psycopg.errors.InternalError_)Cannotfinddata type:serial

3. ErrorCannot find portal: c_10479c0a0_1 withpsycopg3

This flaw has been observed with thepsycopg driver in asynchronous mode when using result streaming based on server-side cursors. It can be exercised using theasync_streaming.py example program.

python examples/async_streaming.py psycopg

The same program works fine when using theasyncpg driver.

python examples/async_streaming.py asyncpg

Introduction

Bug

References

• https://docs.sqlalchemy.org/en/20/orm/extensions/asyncio.html#synopsis-core
• https://docs.sqlalchemy.org/en/20/_modules/examples/asyncio/basic.html

This patch has been replaced by two others.

• Dialect: Add support forasyncpg andpsycopg3 drivers sqlalchemy-cratedb#11
• Python/SQLAlchemy: Demonstrate support forasyncpg andpsycopg3 cratedb-examples#201

/cc@SStorm,@surister