# Logic & Legacy

> Master Python from the inside out. A technical deep dive covering CPython internals, memory management, and distributed backend system design.

## Recent Posts

- [FastAPI WebSockets: Async Connections, Scaling,   The Multi-Worker Nightmare (2026)](https://paragraph.com/@logic-and-legacy/fastapi-websockets-async-connections-scaling-the-multi-worker-nightmare-2026): FastAPI WebSockets crash silently in production due to unmanaged stateful connections.
- [The Offset Massacre — Why Cursor Pagination is Mandatory (2026)](https://paragraph.com/@logic-and-legacy/the-offset-massacre-%E2%80%94-why-cursor-pagination-is-mandatory-2026): Still burning CPU cycles on `OFFSET` queries, watching latency spike as your tables grow O(N) instead of O(log N)?
- [Database Connection Pooling — Why Your Serverless APIs Kill Postgres (2026)](https://paragraph.com/@logic-and-legacy/database-connection-pooling-%E2%80%94-why-your-serverless-apis-kill-postgres-2026)
- [Elasticsearch & Inverted Indices — The Death of SQL ILIKE (2026)](https://paragraph.com/@logic-and-legacy/elasticsearch-and-inverted-indices-%E2%80%94-the-death-of-sql-ilike-2026)
- [API Middlewares — The Bouncer at the Door (FastAPI & ASGI) (2026)](https://paragraph.com/@logic-and-legacy/api-middlewares-%E2%80%94-the-bouncer-at-the-door-fastapi-and-asgi-2026)
- [Python Background Tasks — Asyncio Traps, FastAPI & Celery (2026)](https://paragraph.com/@logic-and-legacy/python-background-tasks-%E2%80%94-asyncio-traps-fastapi-and-celery-2026)
- [Pydantic & Data Validation — Border Control for Python APIs (2026)](https://paragraph.com/@logic-and-legacy/pydantic-and-data-validation-%E2%80%94-border-control-for-python-apis-2026)
- [ Backend Serialization — JSON, Pickle Opcodes & The Universal Type Fallacy (2026)](https://paragraph.com/@logic-and-legacy/backend-serialization-%E2%80%94-json-pickle-opcodes-and-the-universal-type-fallacy-2026)
- [The Dharma of Performance: When Python Hits the Steel](https://paragraph.com/@logic-and-legacy/the-dharma-of-performance-when-python-hits-the-steel): Architecture first. Optimization second. Legacy always.

## Blog Information

- [Homepage](https://paragraph.com/@logic-and-legacy/): Main blog page
- [RSS Feed](https://api.paragraph.com/blogs/rss/@logic-and-legacy): Subscribe to updates

## Optional

- [All Posts](https://paragraph.com/@logic-and-legacy/): Complete post archive
- [Sitemap](https://paragraph.com/@logic-and-legacy/sitemap-index.xml): XML sitemap for crawlers