CRUD
CRUD (Create, Read, Update, Delete) are the four basic functions of persistent storage. CRUD applications are common in web development, where the main focus is on data manipulation rather than complex business logic or user interfaces.
The operations can be mapped to following SQL statements or HTTP methods in the context of RESTful APIs:
| CRUD | SQL | HTTP |
|---|---|---|
| Create | INSERT | POST, PUT (no id) |
| Read | SELECT | GET |
| Update | UPDATE | PUT (replace), PATCH (modify) |
| Delete | DELETE | DELETE |