What Is CRUD?
Create, Read, Update, and Delete (CRUD) make up the four basic operations of persistent storage. CRUD operations often refer to SQL operations used in relational databases, but can also map to data manipulation operations used in RESTful API services and other databases.
Create
Create operation refers to adding new data or records in a system. In SQL, the
CREATE
INSERT
POST
PUT
Read
Read operation involves retrieving stored data from a system. In SQL, the
SELECT
GET
Update
Update operation modifies or replaces existing data. In SQL, the
UPDATE
PUT
PATCH
Delete
Delete operation is used to remove existing records from a system. For both SQL and RESTful APIs, the
DELETE
Use Cases
Applications that support CRUD operations tend to be transactional use cases, where individual inserts, reads, updates, and deletions are common. On the other hand, analytical applications have different data storage and access patterns where CRUD operations are less useful. For example, in analytical applications, it is very common to insert data in bulk, then read data on aggregated values rather than for individual data points. Data may be eventually deleted in bulk often with no support for updates.