# Python

## 2025
- [Escaping Python's Type Resolution Hell: How pydantic-graph Solved the Forward Reference Nightmare](/p/escaping-python-type-resolution-hell/llms.txt)
- [When Python's Top-to-Bottom Execution Bites Back: A Deep Dive into Forward Reference Mysteries](/p/python-forward-reference-execution-order-debugging/llms.txt)
- [Understanding Graph-Based AI Agents: From Concept to Code](/p/graph-based-ai-agent-workflows/llms.txt)
- [Wait, Even SELECT Starts a Transaction?—A Curious Tour of DB Locks, MVCC, and SQLAlchemy's 'Magic' Sessions](/p/wait-even-select-starts-a-transaction/llms.txt)
- [Async SQLAlchemy Journey: From Confusion to Clarity](/p/async-sqlalchemy-journey/llms.txt)
- [Understanding FastAPI Parameters: A Complete Guide](/p/understanding-fastapi-parameters/llms.txt)
- [Understanding the Event Loop: Python's Asynchronous Engine](/p/python-asyncio-event-loop-explained/llms.txt)
- [Running Parallel Operations with Asyncio Gather](/p/python-asyncio-gather-explained/llms.txt)
- [Python's GIL and Asyncio: Understanding the Relationship](/p/python-gil-asyncio-relationship/llms.txt)
- [Python Asyncio: Coroutines Explained](/p/python-asyncio-coroutines-explained/llms.txt)
- [Processing Results as They Arrive with as_completed](/p/python-asyncio-as-completed-explained/llms.txt)
- [Cooperative Multitasking: The Core of Python Asyncio](/p/python-asyncio-cooperative-multitasking/llms.txt)
- [Asyncio Tasks: Managing Concurrent Operations](/p/python-asyncio-tasks-explained/llms.txt)
- [Asyncio Best Practices and Common Pitfalls](/p/python-asyncio-best-practices-pitfalls/llms.txt)
- [Effortless Video Transcription with OpenAI Whisper](/p/auto-video-transcription-with-whisper/llms.txt)