search

zillow / ctds

Python DB-API 2.0 library for MS SQL Server
MIT License
83 stars 12 forks source link

Asyncio support #21

Open sharkguto opened 6 years ago

sharkguto commented 6 years ago

Is there any plan to support asyncio for ctds, like asyncpg?

joshuahlang commented 6 years ago

Not currently. For real support, one would either have to implement the TDS protocol from scratch or use the async APIs in ODBC. I would guess Microsoft's ODBC driver supports the async APIs, though I haven't confirmed that. I would also guess that FreeTDS does not fully support the async ODBC APIs.

As a work-around, one could use an executor to offload the synchronous calls in ctds to a background thread.

kafran commented 4 years ago

Will this ever be possible?