Skip to content

CRUD — Create, Read, Update, Delete (The Four Things Every App Does)

Learn the four fundamental database operations that power every application, with hands-on examples in Supabase.

14 min readbeginner, hands-on, database, crud, supabase

Every application you've ever used — every social media feed, every online store, every banking app — does four things with data: creates it, reads it, updates it, and deletes it. That's it. Four operations. They have a catchy acronym: CRUD.

Once you understand CRUD, you understand the fundamental pattern behind every feature in every application. That's not an exaggeration.

The Four Operations

Let's use our todos table from the previous lessons. It has these columns: id, title, is_complete, and created_at.

Create — Adding New Data

When you add a new to-do item, you're performing a Create operation. You're inserting a new row into the table.

In the Supabase dashboard: Click "Insert row" in the Table Editor, fill in the title, and save.

**What's happenin

This lesson is part of the Guild Member curriculum. Plans start at $29/mo.