Verification
Prove the happy path
- Can explain direct vs pooled connections
- Can identify public vs secret Supabase values
- Can diagnose connectivity
- Can keep environments isolated
Phase 08 · Lesson 13
Mastery Capstone Lab
Learning contract
What you should be able to do after this
- Explain Mastery Capstone Lab without relying on framework buzzwords.
- Connect the lesson to the phase outcome: Operate Supabase as managed PostgreSQL with deliberate project, connection, pooling, dashboard, and environment boundaries.
- Reproduce the relevant behavior and verify it with evidence.
- Diagnose at least one representative failure instead of guessing.
Figure 8.13 — TaskFlow boundary map
Application
connection string/pooler
Supabase Postgres
database objects
dashboard/observability
Instructor workflow: predict first → implement the smallest slice → run it → inspect evidence → break one assumption → diagnose → explain it back. Do not copy the whole code block before understanding the first failing boundary.
Mastery Capstone Lab
This is the transfer exercise for Phase 08: Supabase PostgreSQL. The detailed lessons are now closed-book reference material. Your task is to prove that the phase outcome can be reproduced from requirements, repository evidence, and debugging—not by copying a finished implementation.
Target artifact A Supabase project configured for TaskFlow development with documented connection paths and safe environment variables.
Acceptance criteria - Write the behavior and constraints before implementation. - Identify the owning layer and every boundary crossed. - Implement the smallest complete vertical slice. - Verify the happy path from outside the implementation. - Demonstrate at least one expected failure path. - Run the phase-relevant quality checks. - Review the diff for accidental duplication, leaked responsibilities, missing validation/authorization, and hidden environment assumptions.
Evidence packet Save the command/request used, expected result, actual result, one failure reproduction, the fix, and a short explanation of why the final responsibility belongs where it does. This packet is more valuable than a screenshot of a green page because it demonstrates repeatable engineering reasoning.
Stretch Change one requirement after the first implementation. Measure which files must change. If a tiny domain change causes unrelated layers to move, use that evidence to discuss coupling before adding another abstraction.
Executable lesson studio · sql
Now turn the explanation into engineering skill.
A guided lesson proves you can follow. A capstone proves you can transfer the model to a requirement with fewer cues.
By the end, you should be able to
- Operate Supabase as managed PostgreSQL with deliberate project, connection, pooling, dashboard, and environment boundaries.
- Produce a reproducible evidence packet for success and failure.
- Defend the architecture and identify one improvement without overengineering.
Figure 8.13B — Mental model
Application
connection string/pooler
Supabase Postgres
database objects
dashboard/observability
Code-along sequence
One coherent change at a time
- 01
Create the project and record which values are public identifiers versus secrets.
- 02
Inspect the database with SQL editor and an external client so the dashboard is not the only access path.
- 03
Compare direct and pooled connection strings and document when each is appropriate.
- 04
Place connection information in environment files excluded from Git.
- 05
Test connectivity from the API environment and diagnose a deliberately incorrect host/port/password.
- 06
Document how local, staging, and production projects will remain separate.
- 07
Run the phase mastery checklist without looking at the provided implementation.
- 08
Perform a short architecture review and document one trade-off you consciously accepted.
txtCapstone evidence packet
Requirement -> implementation diff -> verification -> controlled failure -> diagnosis -> final proofDo not copy this as a finished answer. Predict what each boundary does, type the smallest useful slice, run it, then compare the result with your prediction.
Break it on purpose
Build debugging memory
- Committing database credentials
- Using the wrong connection mode for serverless/concurrent workloads
SymptomInvestigation path
You can only continue by copying the reference
Return to the mental model and acceptance criteria. Rebuild one smaller slice from first principles before reopening the source.
Everything seems to work but proof is weak
Choose an external observer: HTTP client, browser, database query, test runner, health endpoint, or deployment log, and capture deterministic evidence.
Closed-reference challenge
Can you transfer the idea?
Extend the phase artifact with one requirement not used in the guided example while preserving the same ownership rules and verification strategy.
Explain-back
Answer these without reopening the solution
- What did you build without a transcript?
- Which boundary caused the most reasoning effort?
- Which failure gave the strongest evidence?
- What shortcut did you deliberately avoid?
- What would you automate before repeating this in a team?
Lesson studio
Turn the reading into skill
Do it
Create the project and record which values are public identifiers versus secrets.
Use the smallest change that demonstrates this lesson. Stop after it works and capture evidence.Break it safely
Committing database credentials
Predict the symptom before causing the failure. Then locate the earliest boundary where reality diverges from expectation.Explain it back
Why does this responsibility live here, what input does it trust, what output proves success, and what would go wrong if another layer owned it?
If your explanation is vague, repeat the boundary trace before moving on.Exit ticket
Before marking complete
Close the reference. Reproduce the core idea from memory or explain the exact request/data flow aloud. Then check your diff or notes for accidental shortcuts that bypass validation, authorization, error handling, or verification earned in earlier phases.