Overview#

Create Read Update Delete (CRUD)

Create Read Update Delete for SQL and HTTP / REST [1]#

OperationSQLHTTP/REST
CreateINSERTPUT / POST
ReadSELECTGET
UpdateUPDATEPUT / POST / PATCH
DeleteDELETEDELETE
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:

Add new attachment

Only authorized users are allowed to upload new attachments.
« This page (revision-6) was last changed on 12-Mar-2017 09:06 by jim