Step 3. CRUD and architecture¶
Training project:
notes_project— a standalone application that starts with SQLite and moves to PostgreSQL. This is the third step of the evolution. You go through the full cycle: from domain design to a finished application with the Services & Selectors architecture.
Prerequisites
Before you start, make sure you have completed:
- Step 1. Hello Django — a basic Django project, the first
HttpResponse - Step 2. Bootstrap Notes — ModelForm, PRG, Bootstrap CRUD
Training state vs Notes Chat App¶
| notes_project (this step) | notes_chat_app (the final goal) | |
|---|---|---|
| Project | Standalone (SQLite → PostgreSQL) | Docker + PostgreSQL |
| Auth | None / basic @login_required |
@login_required, Groups, sharing |
| Models | 9 models: UserProfile, Tag, Notebook, Note, Reminder, TodoList, TodoItem, ShoppingList, ShopItem | The same + Group (Django built-in) + ChatMessage |
| Views | FBV + selectors + services | FBV/CBV + selectors + services |
| Architecture | Services & Selectors | Services & Selectors (identical) |
| Relationships | 1:1, 1:N, M:N — all types | The same + Group M:N for sharing |
Result of the step¶
After you finish this step you will have:
http://localhost:8000/ → Index
http://localhost:8000/notes/ → List of notes (search, filters, tags)
http://localhost:8000/notes/new/ → Note creation form
http://localhost:8000/notes/1/ → Note detail (with reminders)
http://localhost:8000/notes/1/edit/ → Edit form
http://localhost:8000/notes/1/delete/ → Delete confirmation (POST only)
http://localhost:8000/notebooks/ → List of notebooks
http://localhost:8000/notebooks/new/ → New notebook
http://localhost:8000/tags/new/ → New tag
http://localhost:8000/admin/ → Django Admin (with select_related)
What you will learn¶
- The 7-step methodology of database design: Domain → Entities → Attributes → Relationships → Normalization → on_delete → Django Model
- ER diagrams — all relationship types: 1:1, 1:N, M:N
- Services & Selectors — an architectural separation of responsibility layers
selectors.py— only SELECT queries, with optimizationservices.py— CREATE / UPDATE / DELETE withtransaction.atomic()- The N+1 problem and its solution:
select_related,prefetch_related transaction.atomic(),F(),select_for_update()- Class-Based Views (CBV) —
LoginRequiredMixin,UserQuerySetMixin,ListView,CreateView,UpdateView,DeleteView - Moving from SQLite to PostgreSQL via Docker
Reading order¶
- Domain design — the 7-step methodology, where the truth lives, requirements analysis
- ER diagrams — relationship types, the on_delete matrix, the full schema of 11 tables
- Django models — the full code of all models, the ORM QuerySet API
- Migrations — Migration Lifecycle, the dependency DAG, the first run with SQLite
- Services and Selectors — layer architecture, READ/WRITE flow, full code
- QuerySet in depth — normalization, N+1, select_related, prefetch_related, F(), transactions
- PostgreSQL — Docker, configuring Django, moving data
- Class-Based Views — CBV vs FBV, Generic Views, Mixins, hooks
- Checkpoint — checklist, common mistakes, practical exercise