Database Design for Full-Stack Apps

Summary

Designing your schema with your API and frontend's actual query needs in mind — not in isolation, since what the frontend needs to display shapes what the backend needs to efficiently query.

• 1Design a schema starting from 'what will the frontend need to render this screen' rather than abstract entities alone.
• 2Identify a query your planned schema would make awkward or slow, and adjust the design.
• 3Practice explaining a schema design decision in terms of the user-facing feature it supports.