Vibe Coder · Unit 12: Login and Data With Supabase · Lesson 1 of 6

What a database is

A database is where your app remembers things. Tables, rows and columns in plain words, and what Supabase gives you.

Read the short notes and pictures.Do everything inside a blue frame.

Where your app remembers

Until now your app has shown sample data. A real product stores what people create and shows it to them the next time. That is the job of a database. Supabase provides one, based on a widely used database called Postgres, along with sign-in and file storage.

A 3D scene of coloured blocks and cards. A table: a row, a column, a table.
A row for each thing, a column for each fact.

The words

Table

One kind of thing: invoices, clients.

Row

One item: a single invoice.

Column

One fact about every item: amount, date, status.

Id

A unique label for each row, so rows can refer to each other.

A 3D scene of coloured blocks and cards. Supabase gives you: a database, sign-in, file storage.
A database, sign-in and file storage in one service.

From brief to tables

  1. Open your build brief

    The Data section lists what must be saved.

  2. One table per kind of thing

    Invoices, clients.

  3. One column per fact

    With a type: text, number, date, yes or no.

  4. Link them

    Each invoice belongs to one client and one user.

ActivityBuild stepSign-in and saved data

Design your tables on paper

Create a Supabase project. Then ask Claude to turn the Data section of your build brief into a list of tables and columns in plain words, and check it against the brief.

Done when

You will create the first table in the next lesson.

Keep these

  • A database is where an app remembers.
  • Tables hold rows and columns.
  • Supabase adds sign-in and storage.