What Is a CRUD App?
A CRUD app is any software that primarily Creates, Reads, Updates, and Deletes data — the four fundamental database operations that underpin most business applications.
CRUD stands for Create, Read, Update, Delete — the four operations you can perform on any piece of data. Almost every business application is, at its core, a CRUD app with access control, business rules, and a user interface layered on top.
Examples of CRUD apps:
- A booking system: create bookings, read availability, update reservations, delete cancellations
- A CRM: create contacts, read deal history, update pipeline stage, delete closed-lost records
- An inventory tool: create products, read stock levels, update quantities, delete discontinued items
CRUD maps directly to HTTP methods:
| CRUD | HTTP | SQL |
|---|---|---|
| Create | POST | INSERT |
| Read | GET | SELECT |
| Update | PUT/PATCH | UPDATE |
| Delete | DELETE | DELETE |
What makes a CRUD app non-trivial: The CRUD operations themselves are simple. The complexity is in access control (who can read/write which rows), validation (what data is acceptable), business rules (what happens when X is updated), and real-time sync (who else needs to know when data changes).
Using Supabase for CRUD: Supabase auto-generates a REST and GraphQL API from your Postgres schema. Combined with Row-Level Security, you get typed CRUD operations with access control — without writing a single API handler.