Can you explain what the select_related() method does in Django and how it helps when working with a database?

The select_related() method in Django is used to optimize database queries when working with related models through ForeignKey or OneToOneField.

By default, when accessing related objects, Django performs a separate SQL query for each access (lazy loading). This can lead to the N+1 query problem, where many additional queries are executed for a list of objects.

select_related() solves this problem by executing a single SQL query with a JOIN, which loads the related objects along with the main objects. This significantly reduces the number of queries and improves performance.

Example:

# Without select_related
books = Book.objects.all()
for book in books:
    print(book.author.name)  # Each book will trigger a separate query to author

# With select_related
books = Book.objects.select_related('author').all()
for book in books:
    print(book.author.name)  # All data is loaded with one query

Thus, select_related() is useful for "eager" loading of related objects and reducing the number of database queries.