Django ORM: A Guide to Database Management in Django

Subtitle: Understanding the Basics of Django ORM and Database Models

1. The Django ORM: An Overview

Django, a high-level Python web framework, is well-known for its simplicity and ease of use. One of its key features is the Object-Relational Mapping (ORM) system, which allows developers to interact with databases in a simple and intuitive manner. The Django ORM provides a high-level, Pythonic abstraction for database management, hiding the complexities of SQL queries and database connections.

2. Why Use Django ORM?

Some of the benefits of using Django ORM include:

a. Abstraction: Django ORM enables developers to work with databases using Python objects and methods, rather than writing raw SQL queries. This abstraction reduces the likelihood of SQL injection attacks and simplifies code readability.

b. Portability: The ORM system works with multiple database systems, such as PostgreSQL, MySQL, SQLite, and Oracle. This means that developers can switch between different databases without having to rewrite their code.

c. Maintainability: Django ORM promotes the Don’t Repeat Yourself (DRY) principle, which encourages code reusability and modularity. This makes the code easier to maintain and extend.

d. Query Optimization: The Django ORM automatically optimizes queries to improve database performance. It does this by employing lazy loading, caching, and other techniques.

3. Setting up the Database

To get started with Django ORM, you first need to set up the database. In your Django project’s file, you’ll find the DATABASES configuration dictionary. By default, Django uses SQLite as the database backend. However, you can change this by modifying the ‘ENGINE’ and other relevant settings within the DATABASES dictionary.

Example of a PostgreSQL configuration:

    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'mydatabase',
        'USER': 'myuser',
        'PASSWORD': 'mypassword',
        'HOST': 'localhost',
        'PORT': '5432',
4. Defining Models

In Django, models are Python classes that represent database tables. Each attribute in a model class corresponds to a field in the table, and each instance of the class represents a row in the table. To create a model, you need to define a class that inherits from django.db.models.Model and define fields as class attributes.

For example, let’s create a model for a simple blog application:

from django.db import models

class Author(models.Model):
    first_name = models.CharField(max_length=30)
    last_name = models.CharField(max_length=30)
    email = models.EmailField(unique=True)

class Post(models.Model):
    title = models.CharField(max_length=100)
    content = models.TextField()
    pub_date = models.DateTimeField()
    author = models.ForeignKey(Author, on_delete=models.CASCADE)

In this example, we have two models: Author and Post. The Author model has three fields: first_name, last_name, and email. The Post model has four fields: title, content, pub_date, and author. The ForeignKey field in the Post model creates a one-to-many relationship between Author and Post, meaning that each Post is associated with one Author, but an Author can have multiple Posts.

Exploring Field Options, Model Relationships, and Model Inheritance

5. Field Options in Models

Django provides several field options that can be used to customize the behavior of a field. Some of the most common field options include:

a. default: Specifies a default value for the field when a new instance is created.

b. null: Determines if the field can store NULL values. If set to True, the field will accept NULL values.

c. blank: Determines if the field can be left empty. If set to True, the field will accept empty values.

d. unique: Ensures that each value in the field is unique across all instances of the model.

e. verbose_name: Provides a human-readable name for the field, which is used in Django’s admin interface and other places where the field is displayed.

Here’s an example of how to use these field options in the Author model from Part 1:

class Author(models.Model):
    first_name = models.CharField(max_length=30, verbose_name='First Name')
    last_name = models.CharField(max_length=30, verbose_name='Last Name')
    email = models.EmailField(unique=True, verbose_name='Email Address')
6. Model Relationships

Django supports three types of model relationships: one-to-one, one-to-many, and many-to-many. These relationships can be implemented using the following fields:

a. OneToOneField: Represents a one-to-one relationship between two models. Each instance of the first model is related to exactly one instance of the second model.

b. ForeignKey: Represents a one-to-many relationship between two models. Each instance of the first model can be related to multiple instances of the second model, while each instance of the second model is related to exactly one instance of the first model.

c. ManyToManyField: Represents a many-to-many relationship between two models. Each instance of the first model can be related to multiple instances of the second model, and vice versa.

7. Model Inheritance

Django supports three types of model inheritance:

a. Abstract Base Classes: These are base classes that are not meant to be instantiated on their own but are used as a base for other models. To create an abstract base class, set the abstract attribute in the model’s Meta class to True.

b. Multi-table Inheritance: This is when a model inherits from another model, and each model has its own database table. Django automatically creates a one-to-one relationship between the two models.

c. Proxy Models: These are models that inherit from another model but do not create a new database table. They can be used to change the behavior of the original model or provide different default manager methods.

Example of abstract base class:

class NamedModel(models.Model):
    name = models.CharField(max_length=100)

    class Meta:
        abstract = True

class Category(NamedModel):

class Product(NamedModel):
    category = models.ForeignKey(Category, on_delete=models.CASCADE)

In this example, we have an abstract base class NamedModel with a single ‘name’ field. Both Category and Product models inherit from NamedModel, which results in both models having a ‘name’ field without duplicating the field definition.

Working with Data – Creating, Updating, Deleting, and Querying

In this section, we will cover working with data using the Django ORM, including creating, updating, and deleting instances, as well as querying the database.

8. Creating Model Instances

To create a new instance of a model, you can use the model’s constructor, passing the necessary field values as keyword arguments. After creating an instance, you can save it to the database by calling the save() method.


from myapp.models import Author, Post
from datetime import datetime

author = Author(first_name='John', last_name='Doe', email='')

post = Post(title='My First Post', content='Hello, world!',, author=author)
9. Updating Model Instances

To update an existing model instance, simply modify the instance’s attributes and call the save() method to persist the changes to the database.


author = Author.objects.get(email='')
author.first_name = 'Jane'
10. Deleting Model Instances

To delete a model instance, call its delete() method. This will remove the instance from the database.


author = Author.objects.get(email='')
11. Querying the Database

Django provides a powerful and flexible API for querying the database. The main entry point for querying is the model’s manager, which is usually named “objects”. Some common query methods include:

a. all(): Returns a QuerySet containing all instances of the model.

b. filter(**kwargs): Returns a QuerySet containing instances that match the specified filters.

c. exclude(**kwargs): Returns a QuerySet containing instances that do not match the specified filters.

d. get(**kwargs): Returns a single instance that matches the specified filters. Raises a DoesNotExist exception if no instances are found, and a MultipleObjectsReturned exception if multiple instances are found.

e. create(**kwargs): Creates and saves a new instance with the specified field values.

Example of querying:

# Get all authors
authors = Author.objects.all()

# Get authors with the last name 'Doe'
authors = Author.objects.filter(last_name='Doe')

# Get authors with a first name other than 'John'
authors = Author.objects.exclude(first_name='John')

# Get the author with the email ''
author = Author.objects.get(email='')

# Create a new author
new_author = Author.objects.create(first_name='Alice', last_name='Smith', email='')

Advanced Querying Techniques and Working with Related Objects

In the final section, we will discuss advanced querying techniques, including aggregations, annotations, and custom query expressions, as well as working with related objects.

12. Aggregations and Annotations

Django’s ORM provides a powerful aggregation API that allows you to perform calculations on your data, such as counting, summing, or averaging values. To perform an aggregation, use the aggregate() method on a QuerySet and pass in an aggregation function from the django.db.models module.

Annotations are similar to aggregations, but instead of returning a single result, they add calculated values to each instance in the QuerySet. To perform an annotation, use the annotate() method on a QuerySet and pass in an annotation function from the django.db.models module.

Example of aggregation and annotation:

from django.db.models import Count, Avg
from myapp.models import Author, Post

# Calculate the total number of posts
total_posts = Post.objects.aggregate(Count('id'))

# Calculate the average number of posts per author
average_posts = Author.objects.annotate(posts_count=Count('post')).aggregate(Avg('posts_count'))
13. Custom Query Expressions

Django’s ORM allows you to create custom query expressions to perform complex calculations or transformations on your data. To create a custom query expression, you can subclass the django.db.models.Expression class and implement the required methods.

Example of a custom query expression:

from django.db.models import Expression, fields

class Length(Expression):
    def __init__(self, field):
        self.field = field

    def as_sql(self, compiler, connection):
        sql, params = compiler.compile(self.field)
        return f'LENGTH({sql})', params

    def output_field(self):
        return fields.IntegerField()

# Get all posts with their title length
posts = Post.objects.annotate(title_length=Length('title'))
14. Working with Related Objects

Django’s ORM makes it easy to work with related objects, such as those connected by ForeignKey, OneToOneField, or ManyToManyField relationships. Some common ways to work with related objects include:

a. Accessing related objects directly: You can access related objects using the field names defined in your models.

b. Using the related_name option: By setting the related_name option on a ForeignKey, OneToOneField, or ManyToManyField, you can customize the name of the reverse relationship between models.

c. Querying related objects: You can use the double underscore (__) syntax in filter(), exclude(), and get() methods to query related objects.

Example of working with related objects:

# Accessing related objects directly
post = Post.objects.get(title='My First Post')
author =

# Using the related_name option
class Post(models.Model):
    author = models.ForeignKey(Author, on_delete=models.CASCADE, related_name='posts')

# Now you can access an author's posts using the 'posts' attribute
author_posts = author.posts.all()

# Querying related objects
posts_by_john_doe = Post.objects.filter(author__first_name='John', author__last_name='Doe')

This concludes our post on Django ORM. We hope you now have a better understanding of how to manage databases in Django using the powerful and flexible ORM system. We have explored the various aspects of Django ORM, from its basic concepts and setting up databases, to creating and manipulating data, as well as understanding advanced querying techniques and working with related objects. Django ORM provides an efficient and Pythonic way to manage databases, making it an essential tool for any Django developer.

By leveraging the power of Django ORM, you can create complex web applications with ease, while ensuring that your code remains maintainable, secure, and portable across different database systems. As you continue to work with Django ORM, you will discover even more advanced features and techniques that will further enhance your capabilities as a web developer. Happy coding, and we hope this guide has set you on the path to mastering database management in Django!

Related Posts