Gold Lapel
How it works
Integrations
The Study
The Book Get Started
← The Grounds

Django & Python

Django's ORM is capable of remarkable things when properly directed — and remarkable damage when left to its defaults. FastAPI, SQLAlchemy async, psycopg3, and the patterns that separate production Python from tutorial Python.

1 Django PostgreSQL Optimization: Beyond the ORM2 Django ORM N+1 Queries: Detection and Prevention3 Why Django's ORM Duplicates Your Subqueries: Fixing Slow Annotate Chains with CTEs4 Django Custom Managers for Optimal PostgreSQL: Encapsulating the Queries Your Database Deserves5 DRF Nested Serializer N+1 Queries: Fixing Prefetch Invalidation in Django REST Framework6 PostgreSQL Full-Text Search in Django: From 45ms to 1ms with SearchVectorField and GIN Indexes7 PostgreSQL Table Partitioning in Django: A Production Guide with django-postgres-extra8 Django Multi-Database Routing with PostgreSQL Read Replicas: Solving the Replication Lag Consistency Bug9 Zero-Downtime Django Migrations on Million-Row PostgreSQL Tables10 asyncpg or psycopg3 for FastAPI? Allow Me to Present the Evidence.11 Migrating from psycopg2 to psycopg3: A Guided Transition, with Performance Benchmarks12 SQLAlchemy Async Relationship Loading: Escaping the MissingGreenlet and the N+113 Your SQLAlchemy 2.0 Async Sessions Are Slower Than Sync. Allow Me to Explain Why.14 Tortoise ORM and PostgreSQL: A Performance Guide for the Async-First ORM
Gold Lapel © 2026 Gold Lapel
The Waiter's correspondence
Company About Press thewaiter@goldlapel.com
Legal Terms Privacy