Installing and Connecting to SQLite3

Welcome to the first unit of our course on managing data with SQLite and Django ORM. Here, we will start with the fundamentals. You will learn how to install and set up a database with SQLite3 and connect it to your Django application. This is a foundational step that will set the stage for more complex data management tasks.

In this section, you will:

1. Set up and configure an SQLite3 database for your Django project.
2. Learn to create and execute raw SQL queries within your Django views.

These steps are crucial because they form the backbone of any data-driven application. By the end of this section, you will be able to configure your database and perform basic data operations.

The first step in configuring the database is to add the necessary settings. Here is a code snippet that shows how to configure the database settings in your Django project:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': BASE_DIR / 'db.sqlite3',
    }
}

This configuration specifies that the database engine is SQLite3 and the database file is located in the project's base directory. You can customize these settings based on your requirements.

Note that you will be provided with the database configuration for the upcoming practice tasks. You will only focus on the code that interacts with the database.

In your view defined in myapp/views.py, you will perform basic CRUD (Create, Read, Update, Delete) operations using raw SQL queries. For this lesson, let's focus on executing simple raw queries to retrieve data from the database:

from django.http import HttpResponse
import sqlite3

def get_items(request):
    # Create a new SQLite connection for each request
    connection = sqlite3.connect('db.sqlite3')
    items = []
    try:
        # Retrieve items from the database
        raw_query = 'SELECT * FROM items'
        items = connection.execute(raw_query).fetchall()
    finally:
        # Close the connection to ensure it is not reused
        connection.close()

    return HttpResponse(items)

In the code snippet above, we create a new connection to the SQLite3 database, execute a raw SQL query to retrieve all items from the items table, and return the result as an HttpResponse. This is a simple example to demonstrate how to interact with the database using raw SQL queries.

Now, if we send a request to the get_items view, the items from the database will be returned. This is just the beginning of what you can do with SQLite3 and Django. In the upcoming tasks, you will explore more advanced data operations and learn how to use Django's ORM to interact with the database.