django

Fix Django ORM N+1 query issues by applying select_related for foreign key joins and prefetch_related for reverse relationships to batch database queries and eliminate redundant lookups.

Handle Django migrations for large tables with zero downtime by applying safe schema change patterns and database-level constraints to prevent table locks during production deployments.

Secure Django REST Framework serializers for production by validating model inputs through database-level constraints and enforcing robust permission settings across API endpoints.

Django ORM query optimization reduces database bottlenecks by replacing redundant single-row fetches with predictable query counts using select_related and prefetch_related for related object lookups.

Implement database-level constraints in Django models when you need robust validation and data integrity enforcement during large-scale migrations or production security audits.

Audit your Django querysets for performance issues by analyzing model definitions and queryset logic to identify N+1 query patterns and predict query counts before production deployment.