Connectivity - Database Management in Django

Syntax

To connect Django with a database, you need to follow the below syntax:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.<database_engine>',
        'NAME': '<database_name>',
        'USER': '<database_username>',
        'PASSWORD': '<database_password>',
        'HOST': '<database_host>',
        'PORT': '<database_port>',
    }
}

Example

Here is an example of how to connect Django with a PostgreSQL database:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'mydatabase',
        'USER': 'mydatabaseuser',
        'PASSWORD': 'mypassword',
        'HOST': 'localhost',
        'PORT': '5432',
    }
}

Output

Once you have configured the database connection, Django will be able to read and write data to the specified database.

Explanation

Django supports multiple databases and provides a powerful and easy-to-use Object-Relational Mapping (ORM) system that allows you to work with databases using Python code. To connect Django with a database, you need to specify the database engine, name, user, password, host, and port in the DATABASES setting in your Django project's settings.py file.

Use

Connecting Django with a database is the first step towards managing data in your web application. You can use Django's ORM to create, retrieve, update and delete records in the database.

Important Points

• Django supports multiple databases.
• Django has built-in support for popular databases such as PostgreSQL, MySQL, SQLite, and Oracle.
• Django's ORM makes it easy to work with databases using Python code.
• You can specify the database connection details in the DATABASES setting in your Django project's settings.py file.

Summary

In this section, we learned how to connect Django with a database, the syntax to be used, an example, and important points to keep in mind. Connecting a database is the first step towards managing data in your web application, and Django's ORM makes it easy and convenient to work with databases.