Welcome to this playground. You can test all tips of 10 tips to optimize PostgreSQL queries in your Django project using this repo.
To run this playground, you'll need
- Install virtualenv
pipenv install -d
- Setup your environment
Copy the example env file
cp .env.example .env
Edit .env by setting a PostgreSQL password and a Django Secret Key.
- Activate your environment
pipenv shell
- Start your PostgreSQL container
docker compose up -d
- Open a notebook
./manage.py shell_plus --notebook
You are now ready to start ;)
This notebook is based on the books Django Application that includes two Models:
- Book
- Person
A Person can be either the author of a Book or one of its readers.
All books written by a Person can be accessed through the writings related name of the author ForeignKey.
The readers relation is defined as a ManyToManyField, accessible from Person using writings related name.
---
title: The books application
---
classDiagram
Book --> Person: author (books)
Book o--> Person: readers (writings)
class Book{
title
author
readers
}
class Person{
email
name
bio
}
We also provide a generate_data Django command to populate the database with enough data to get meaningful results when playing with queries.