P9 – Other Topics (Performance, Security, Integrity, API Security)

Overview

This phase covers additional important topics that improve a database-driven application in real production environments. Each team member contributes with one sub-topic, explained with simple examples connected to the Wedding Planner system.

Topics / Subpages

• Performance (Indexes, Query Optimization)
• Security (SQL Injection, Least Privilege)
• Data Consistency / Integrity (Constraints, FK, Cascade)
• API Security (Validation, Rate limiting, Auth basics)

Notes

Each topic includes:

• beginner-friendly explanation
• at least one concrete example (SQL snippet / rule / pseudo-code)
• connection to the Wedding Planner project