CoachnestCoachnest
Sign InGet Started
Back to course

Mastering CRUD: Build Full-Stack Database Applications

…
—
Contents
1

What Is CRUD and Why It Matters

Reading12mFree
2

CRUD, REST, and HTTP Verbs

Reading14mFree
3

The Data Lifecycle of a Record

Reading11m
4

Course Project Tour: TaskFlow

Video9m
5

Chapter 1 — Quiz

Quiz8m
6

Tables, Rows, Columns & Types

Reading14m
7

Primary Keys & IDs (Auto-increment vs UUID)

Reading13m
8

Relationships: One-to-Many & Many-to-Many

Reading16m
9

Normalization & Schema Design Principles

Reading14m
10

Modeling TaskFlow with Prisma

Reading13m
11

Chapter 2 — Quiz

Quiz8m
12

INSERT — Creating Rows

Reading13m
13

SELECT — Reading & Filtering

Reading16m
14

UPDATE — Changing Rows Safely

Reading12m
15

DELETE — Removing Rows

Reading11m
16

Live SQL: A Full CRUD Session

Video15m
17

Chapter 3 — Quiz

Quiz9m
18

REST API Design for CRUD Resources

Reading14m
19

HTTP Status Codes That Tell the Truth

Reading12m
20

Scaffolding the API (Express & Next.js)

Reading16m
21

Connecting an ORM (Prisma) to Your Routes

Reading13m
22

Chapter 4 — Quiz

Quiz8m
23

Building the Create Endpoint End-to-End

Reading15m
24

Reading a Single Resource

Reading11m
25

Listing Collections

Reading13m
26

Live Coding: Create & Read

Video16m
27

Chapter 5 — Quiz

Quiz8m
28

PUT vs PATCH: Full vs Partial Updates

Reading13m
29

Authorization: Who Can Change This Row?

Reading12m
30

Soft Delete, Hard Delete & Restore

Reading14m
31

Idempotency & Concurrency Control

Reading13m
32

Chapter 6 — Quiz

Quiz9m
33

Input Validation with Zod

Reading14m
34

Mass Assignment & Over-Posting

Reading11m
35

SQL Injection & Safe Queries

Reading13m
36

Consistent Error Handling

Reading12m
37

Chapter 7 — Quiz

Quiz9m
38

Offset vs Cursor Pagination

Reading15m
39

Filtering & Dynamic WHERE Clauses

Reading13m
40

Safe Sorting & Full-Text Search

Reading14m
41

Indexing for Fast Reads

Reading13m
42

Chapter 8 — Quiz

Quiz9m
43

Forms & Creating Records from the UI

Reading14m

Fetching & Displaying Data

Reading13m
45

Optimistic Updates & Deletes

Reading14m
46

Building the TaskFlow UI

Video17m
47

Chapter 9 — Quiz

Quiz8m
48

Transactions & Data Integrity

Reading15m
49

Testing Your CRUD Endpoints

Reading14m
50

Caching, N+1 & Performance

Reading13m
51

Deploying & Migrating Safely

Reading14m
52

Chapter 10 — Final Quiz

Quiz10m
←→navigate lessons
Chapter 9 of 10·Chapter 9 — CRUD on the Frontend
Lesson 44 of 52Reading13 min

Fetching & Displaying Data

Fetching & Displaying Data¶

The Read side of the UI: load a collection, handle the three states, and keep it fresh.

Every Fetch Has Three States¶

tsx
4 lines
1if (isLoading) return <Spinner />;
2if (error)     return <ErrorBox onRetry={refetch} />;
3if (data.length === 0) return <EmptyState />;
4return <TaskList tasks={data} />;

Loading, error, and empty are not edge cases — they're the normal lifecycle of remote data. Design all three.

Use a Data-Fetching Library¶

Hand-rolling useEffect + useState for every fetch leads to bugs (race conditions, stale closures, no caching). Libraries like TanStack Query or SWR handle caching, refetching, and dedup:

tsx
9 lines
1import { useQuery } from "@tanstack/react-query";
2
3function useTasks(status?: string) {
4  return useQuery({
5    queryKey: ["tasks", status],
6    queryFn: () =>
7      fetch(`/api/v1/tasks?status=${status ?? ""}`).then((r) => r.json()),
8  });
9}

The queryKey doubles as a cache key — change the filter, get a fresh (cached) result.

Server Components: Fetch on the Server¶

In the Next.js App Router you can read data directly in a Server Component — no client fetch, no loading spinner on first paint:

tsx
4 lines
1export default async function TasksPage() {
2  const tasks = await prisma.task.findMany({ where: { ownerId } });
3  return <TaskList tasks={tasks} />;
4}

Paginate the UI Too¶

Wire the list to the paginated API from Chapter 8: a "Load more" button (cursor) or page controls (offset). Never render ten thousand DOM nodes — fetch a page at a time.

Previous

Forms & Creating Records from the UI

Next

Optimistic Updates & Deletes

Use ← → arrow keys to navigate between lessons