Add async/asyncio support
Nobody has claimed this yet.
Assessment
- Difficulty
- 5/5
- Estimated time
- Over a week
- Newbie friendliness
- 25/100
Research direction
Start by mapping the existing Connection, Cursor.execute(), fetchall(), and BLOB API entry points to understand the synchronous surface. Review how these calls are used in the current driver and define what the first-class async interface must cover. Done means async Python callers can use awaitable equivalents without blocking the calling thread.
Written by the indexing model from the issue text.
Description
Summary
crate-python is entirely synchronous. Every call to Connection, Cursor.execute(), fetchall(), and the BLOB API blocks the calling thread. This makes the driver unusable in modern async Python stacks like FastAPI route handlers, Django async views, Starlette/Litestar, asyncio-based ETL pipelines, and LangChain/LlamaIndex tool integrations that all expect await-able database calls.
This issue tracks the design and implementation of a first-class async interface for crate-python.
Motivation
New support would increase use in:
- AI/ML backends: FastAPI services that call both a vector store and CrateDB in the same request handler
- Real-time dashboards: async WebSocket handlers that need concurrent DB queries
- High-throughput ingest: asyncio pipelines where thread-per-connection doesn't scale
- Dominant language
- Python
- Stars
- 85
- Forks
- 34
- Avg merge
- 3d 1h
- Merged PRs (30d)
- 4
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from crate/crate-python
-
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
crate/crate-python#794 · 2 comments ·
-
enhancement
crate/crate-python#833 · 1 assignee ·
-
bug
Difficulty 4/5 3-5 days Newbie friendliness 52/100
crate/crate-python#826 ·
-
Difficulty 5/5 Over a week Newbie friendliness 35/100
crate/crate-python#751 · 7 comments ·
-
Difficulty 3/5 1-2 days Newbie friendliness 35/100
crate/crate-python#729 · 1 comment ·
All issues in crate/crate-python
Similar issues
-
essnmx good first issue
Difficulty 1/5 Under an hour Newbie friendliness 95/100
-
[Feature] 奇物选择添加优先级 Open
Difficulty 2/5 1-3 hours Newbie friendliness 65/100
syfoud/Simulated_Scepter#174 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
Giskard-AI/giskard-oss#2840 · 1 comment ·
-
A claim comment carrying the issue number is silently declined while the workflow reports success Openarea: repo bug perceived difficulty: 2
Difficulty 2/5 1-3 hours Newbie friendliness 70/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
yeti-platform/yeti#1380 ·