Overview#
Create Read Update Delete (CRUD) are typical data operations that could be performed regardless of the protocol.Create Read Update Delete Originally was applied to SQL Operations.
Create Read Update Delete for SQL and HTTP / REST [1]#
| Operation | SQL | HTTP/REST | LDAP |
|---|---|---|---|
| Create | INSERT | PUT / POST | Add Request |
| Read | SELECT | GET | Search Request/SearchResultEntry |
| Update | UPDATE | PUT / POST / PATCH | Modify Request |
| Delete | DELETE | DELETE | Delete Request |
Though HTTP GET and HTTP DELETE coordinate well, HTTP POST, HTTP PUT, and HTTP PATCH aren’t directly synonymous with a single CRUD operation.
For example, HTTP POST doesn’t necessarily only mean “Create”. It’s actually a very versatile method — so versatile that the entire SOAP protocol is tunneled through the HTTP POST method when used with HTTP.
Since HTTP Methods don’t map cleanly to CRUD, Ulsberg argues that API providers should consider how they might describe their APIs in a different way: "Don’t limit yourself to CRUD when you design a REST API. You should read the specification and understand the semantics of each method, and use it properly."
What it comes down to is that REST is an architectural style, not a protocol.
More Information#
There might be more information for this subject on one of the following:- [#1] - Designing a True REST State Machine
- based on information obtained 2017-02-02-
- [#2] - Create Read Update Delete (CRUD)- based on information obtained 2015-02-02-
