Vibe Coding playbook/Module 4 · How software works

Day 33 / 100 · How software works

A spreadsheet with rules.

A database stores your app's data so it's still there tomorrow, and so more than one person can use it at once.

id
name
phone
branch

101

T. Mokoena

082 555 0101

Sandton

102

A. Naidoo

072 555 0102

Durban

103

J. Smit

083 555 0103

Cape Town

Table = a sheet. Row = one record. Column = one field. Primary key (id) = a unique number per row. Relationship = linking tables, like customers to their orders.

Where to keep data

In the browser: just you, one device.

A single file (SQLite): one small app.

A hosted database (e.g. Postgres): real users, shared data.

Source: POPIA ↗

Store what you need. Nothing more.