Picking an async database driver in Python 2026. asyncpg vs psycopg 3 async, MySQL aiomysql / asyncmy, SQLite aiosqlite, libsql for Turso, and the performance / feature tradeoffs.
Practical asyncio debugging: detect blocking calls, find task leaks, diagnose slow callbacks, use asyncio’s debug mode, and the patterns that catch bugs before production.
Picking a Python background job system in 2026. arq for async-native + Redis, Dramatiq for simple + reliable, Taskiq for typed tasks across brokers, Celery for legacy and giant ecosystems. With code, patterns, and a clear decision rule.
Modern asyncio in 2026. Structured concurrency with TaskGroup, ExceptionGroup, timeout/cancellation done right, anyio for cross-runtime portability, and the patterns to use (and avoid).
What async Rust feels like once it clicks — Tokio’s runtime, tasks vs futures, JoinSet, channels, cancellation, select!, and the shape of every concurrency pattern you’ll need on the backend.
A from-scratch production Rust HTTP service. Axum 0.8, sqlx with compile-time-checked queries, structured errors, request tracing, layered middleware, and the exact project layout I use.
How async Django actually works in 2026 — async views, the async ORM, sync_to_async/async_to_sync gotchas, ASGI deployment with Daphne/Uvicorn, and where Channels still earns its keep.
A complete, opinionated production layout for FastAPI in 2026. Pydantic v2, async SQLAlchemy 2.0, Alembic, dependency injection, structured errors, settings, logging, and the project skeleton that survives the first 50 endpoints.
Build a production-ready FastAPI + SQLAlchemy 2.0 + PostgreSQL stack with async sessions, dependency-injected DB access, and Alembic migrations.
Async/await in Python explained from first principles — the event loop, what coroutines really are, when async helps, and how to avoid the foot-guns.