Python Django Models

Query optimization with `select_related` and `prefetch_related` reduces database hits by fetching related objects efficiently in a single query or batched queries. This Skill provides patterns and examples for applying these techniques to avoid N+1 performance issues in Django projects.

Use reusable base classes for consistent patterns: UUIDPrimaryKeyModelBase for unique identifiers, TimestampedModelBase for audit trails, DeletionTimestampModelBase for soft deletes, and EffectiveTimeRangeModelBase for temporal validity. This Skill provides these base classes and best practices to eliminate duplication.

Docker-based PostgreSQL testing with Factory-Boy fixtures validates models end-to-end against a live database, catching issues that sqlite migrations miss. This Skill covers setup, factory patterns, and test workflows for reliable model validation.

Yes. UUIDPrimaryKeyModelBase provides a drop-in base class for Django models that use UUID primary keys instead of auto-incrementing integers, improving security and distributed system compatibility. This Skill includes implementation and migration guidance.

DeletionTimestampModelBase adds a nullable deletion timestamp field to mark records as deleted without removing them from the database, preserving referential integrity and audit history. This Skill includes base class and query filtering examples.

TextChoices and IntegerChoices enforce type safety, prevent invalid enum values, and make constraints explicit in the database schema. This Skill demonstrates usage patterns for modeling constants and improving data consistency across Django projects.