4 / 20 · Book 15 · Your First SELECT -- Reading the Source of Truth← prev⊞ allnext →Get the book →
1.4Why DB Verification Matters
| Scenario | API Response | Database Reality | Without DB Check |
|---|---|---|---|
| Caching bug | Returns 201 Created | No row in users table | Bug goes undetected |
| Race condition | Returns success | Duplicate rows created | Data corruption undetected |
| Default value bug | Returns user with role=null | Role column is NULL | Missing default undetected |
| Soft delete bug | Returns 204 Deleted | deleted_at is still NULL | Item appears deleted but is not |