CRUD

CRUD stands for Create, Read, Update, and Delete, representing the four basic operations for persistent storage that nearly every data-driven application implements. In web development, CRUD operations map to HTTP methods (POST for Create, GET for Read, PUT/PATCH for Update, DELETE for Delete) and SQL statements (INSERT, SELECT, UPDATE, DELETE). Understanding CRUD is fundamental to building any application that stores data.

A task management application implements full CRUD functionality: Create happens when a user fills out a form and clicks Add Task, triggering POST /tasks and INSERT INTO tasks. Read occurs on page load with GET /tasks running SELECT * FROM tasks. Update happens when editing a task with PUT /tasks/123 executing UPDATE tasks SET. Delete removes a task with DELETE /tasks/123 running DELETE FROM tasks WHERE id equals 123.