{"id":52888,"date":"2019-03-29T15:00:53","date_gmt":"2019-03-29T09:30:53","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=52888"},"modified":"2021-06-21T12:19:38","modified_gmt":"2021-06-21T06:49:38","slug":"django-database","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/django-database\/","title":{"rendered":"Django Database – How to Connect MySQL Database with Django Project"},"content":{"rendered":"

In the previous tutorial, we learned the concept of Django Models<\/strong><\/a>, now, we will discuss the process to connect database with Django project.<\/p>\n

Whenever we are creating a web project or any kind of project, we want some kind of input by our end-users or consumers. All that data\/ input is handled by a Database. In today\u2019s scenario, whenever we are developing a website, we will need a database, whether it\u2019s a blog site or highly interactive ones like Instagram which is based on Django.<\/p>\n

To achieve that you would need some software, which can store that data efficiently and also some middleware which can let you communicate with the database.<\/p>\n

\"Django<\/a><\/p>\n

Connecting Databases with Django Project<\/h2>\n

By default, when we made our first app and started the server you must have seen a new file in your project directory, named as \u2018db.sqlite3\u2019. The file is database file where all the data that you will be generating will be stored. It is a local file as Django is a server-side framework<\/a><\/strong> and it treats your computer as the host when you actually run the server in command line\/terminal.<\/p>\n

\"Django<\/a><\/p>\n

This file is generated automatically because Django has a default setting of the database set to the SQLite, which is although fine for testing and provides lots of features but if you want your website to be scalable, you need to change it to any other efficient database.<\/p>\n

In our case, we will be using MySQL and this tutorial will help you to integrate your project with MySQL.<\/p>\n

In the Django Installation tutorial<\/a><\/strong>, we installed Xampp, it\u2019s a great tool and is a prerequisite for MySQL.<\/p>\n

Don\u2019t worry you won\u2019t need to learn SQL for that, all the backend code will be done in python, that is the advantage of Django Model.<\/p>\n

1. DATABASES Dictionary Indexes<\/h3>\n

Firstly, open the settings.py file of your web-application\/ project and there find this part.<\/p>\n

\"Django<\/a><\/p>\n

This partition has information regarding the connection to the database.<\/p>\n

DATABASES is a pre-defined dictionary in Django Framework with the \u2018default\u2019 as an index having the value for the main database where all the data is to be stored.<\/p>\n

There can be multiple databases as we need data backups too but there is only one default database, although we won\u2019t be adding multiple databases now.<\/p>\n

The default is holding a dictionary where there are 2 indexes:<\/p>\n