Where Instagram Stores 2 Billion Photos

Coming Soon

1080p • 60FPS

Databases are just organized storage. We use SQLite (zero setup) to store our high scores permanently.

Resources

Phase 1: Intel

Mission Briefing

⏱️ Before You Watch (5 mins)

Today's Secret: Variables in code forget everything when the computer turns off. Databases never forget. We will use SQLite, a database that lives in a single file. Zero setup, infinite memory.

What you should have ready:

Your Express server
sqlite3 installed (we'll do this)

🧠 Quick Concepts

Term	Simple Meaning
Database (DB)	A digital filing cabinet
Table	A specific drawer (e.g., "Scores")
Row	A single folder (e.g., "Divyanshu: 100")
SQL	The language we use to talk to the DB
SQLite	A simple DB that requires no installation

🤔 Think About

Before watching, consider:

Contact list on your phone = Database.
Instagram feed = Database.
Your bank balance = Database. Everything is a database.

🎯 By the End

After this episode, you'll:

✅ Create your first Database table
✅ Save a score permanently
✅ Retrieve scores even after restarting the computer!

Never forget! 💾

Phase 3: Debrief

Mission Report

📝 What We Learned

Persistence: The ability to remember data after a restart.
SQL (Structured Query Language): simpler than it looks!
- CREATE TABLE: Make a new drawer.
- INSERT INTO: Put a file in the drawer.
- SELECT *: Show me everything in the drawer.
SQLite: The perfect database for beginners (and mobile apps!).

🔗 Key SQL Commands

-- Create the table
CREATE TABLE scores (name TEXT, score INTEGER);

-- Add a score
INSERT INTO scores (name, score) VALUES ('Divyanshu', 100);

-- Get all scores
SELECT * FROM scores ORDER BY score DESC;