Hands-on exercises with complete runnable code. No external dependencies beyond Python 3.8 standard library.
Available Labs
| Lab | Module | What You'll Learn | Time |
|---|---|---|---|
| lab-01-n-plus-one-profiling | N+1 Queries | Observe N+1, fix with JOIN and IN batch, measure improvement | |
| lab-02-connection-pool-tuning | Connection Pooling | Pool size impact on p50/p99/throughput |
Running Labs
Each lab has:
README.md— complete instructions with all codesetup.md— prerequisites and setup notessolution.md— expected results and analysis
Copy the code from README.md, save as a .py file, run with python3.
What Makes a Good Lab Session
- Run the code unmodified first — see the baseline
- Change one parameter at a time — observe the effect
- Explain the results to yourself — connect to the theory in the parent module
- Try the extension exercises — they reveal edge cases