select_related and prefetch_related

# Bad: 1 query for tasks + N queries for each project
tasks = Task.objects.all()
for task in tasks:
    print(task.project.name)  # a new SQL query every time!

# Good: one query with JOIN
tasks = Task.objects.select_related('project', 'owner')
for task in tasks:
    print(task.project.name)  # already loaded
    print(task.owner.username)  # already loaded

# Two queries: tasks + all tags
tasks = Task.objects.prefetch_related('tags')
for task in tasks:
    for tag in task.tags.all():  # already loaded
        print(tag.name)

tasks = Task.objects.select_related('project', 'owner').prefetch_related('tags')

from django.db.models import Prefetch

projects = Project.objects.prefetch_related(
    Prefetch(
        'tasks',
        queryset=Task.objects.filter(status='todo').order_by('priority'),
        to_attr='todo_tasks',  # store in attribute
    )
)

for project in projects:
    print(project.todo_tasks)  # list, not a queryset