Chapter 7. Omar's Pantry

What you'll learn in this chapter

• Explain why apps need a real database, not a spreadsheet or browser storage
• Describe tables, rows, columns, primary keys and foreign keys in plain words
• Read and write the five everyday SQL statements
• Know when you'd reach for NoSQL, object storage, vectors or a cache
• Create your first migration and replace QueueLess's hard-coded menu with real data

Inside

1. Why not just a spreadsheet?
2. Relational databases: shelves with labels
3. Five SQL statements you'll use every week
4. NoSQL: jars instead of shelves
5. Omar's shelf rules
6. Other stores in the pantry
7. How data travels: from tap to shelf and back
8. Migrations: changing the shelves safely
9. Lab: build QueueLess's first real shelves
10. More prompts for your pantry
11. What you've learned