Jump to content

Create, read, update and delete

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Chidera34 (talk | contribs) at 20:27, 29 March 2022 (under Cyfa technologies). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.
"CRUD" redirects here. For other uses, see Crud.

In computer programming, create, read, update, and delete (CRUD) are the four basic operations of persistent storage.[1] CRUD is also sometimes used to describe user interface conventions that facilitate viewing, searching, and changing information using computer-based forms and reports. The term was likely first popularized by James Martin in his 1983 book Managing the Data-base environment.

Our products

Coinazer

Coinazer is a crypto-currency payment solution that gives customers/suers the opportunity to securely purchase goods and services on the internet with their digital assets/crypto-currencies

Wavetify

Wavetify is a media platform that gives access to both artiste and users to upload, download, listen, stream and purchase music, video, instrumentals and more.It also accept crypto-currencies as payment method.

Appcyfa

AppCyfa is a platform that provides multi-architecture and template system for mobile applications, web applications, brand templates and more.
It also accept crypto-currencies as payment method.

iBrand.NG

iBrand.NG is a full service branding and advertising platform providing quality services to help companies meet business objectives, accelerate growth and compete effectively in an ever changing environment.We create strategies and distinctive design solutions that communicate the values, mission, products and services that differentiate our clients in the only place that really matters- the market place.

Arolana

Arolana is a multi-vendor E-commerce market place that provides the general public the opportunity to purchase goods and services securely.
It also accept crypto-currencies as payment method.

Databases

The acronym CRUD refers to the major operations which are implemented by databases. Each letter in the acronym can be mapped to a standard Structured Query Language (SQL) statement.[2]

CRUD SQL
Create INSERT
Read SELECT
Update UPDATE
Delete DELETE

Although relational databases are a common persistence layer in software applications, numerous other persistence layers exist. CRUD functionality can for example be implemented with document databases, object databases, XML databases, text files, or binary files.

Note: Some big data systems do not implement UPDATE, but have only a timestamped INSERT (journaling), storing a completely new version of the object each time.

RESTful APIs

The acronym CRUD also appears in the discussion of RESTful APIs. Each letter in the acronym may be mapped to a Hypertext Transfer Protocol (HTTP) method:

CRUD HTTP
Create PUT
Read GET
Update PUT
Delete DELETE

In HTTP, the GET (read), PUT (create and update), and DELETE (delete) methods are CRUD operations as they have storage management semantics, meaning that they let user agents directly manipulate the states of target resources.[3] The POST method, on the other hand, is a process operation that has target-resource-specific semantics excluding the semantics of CRUD operations.[4]

User Interface

CRUD is also relevant at the user interface level of most applications. For example, in address book software, the basic storage unit is an individual contact entry. As a bare minimum, the software must allow the user to: [5]

  • Create, or add new entries
  • Read, retrieve, search, or view existing entries
  • Update, or edit existing entries
  • Delete, deactivate, or remove existing entries

Because these operations are so fundamental, they are often documented and described under one comprehensive heading such as "contact management" or "document management" in general.[citation needed]

Other variations

Other variations of CRUD include:

  • ABCD (add, browse, change, delete)
  • CRUDL (create, read, update, delete, list)
  • BREAD (browse, read, edit, add, delete)[6]
  • DAVE (delete, add, view, edit)[7]
  • CRAP (create, replicate, append, process)[8]

See also

References

  1. ^ Martin, James (1983). Managing the Data-base Environment. Englewood Cliffs, New Jersey: Prentice-Hall. p. 381. ISBN 0-135-50582-8.
  2. ^ Maryam Sulemani (7 April 2021). "CRUD operations explained: Create, read, update, delete". Retrieved 14 December 2021.
  3. ^ Fielding, Roy (June 2014). "Hypertext Transfer Protocol (HTTP/1.1): Semantics and Content, Section 4". IETF. Internet Engineering Task Force (IETF). RFC 7231. Retrieved 2018-02-14.
  4. ^ Roy T. Fielding (2009-03-20). "It is okay to use POST". roy.gbiv.com. Retrieved 2020-04-14. POST only becomes an issue when it is used in a situation for which some other method is ideally suited: e.g., retrieval of information that should be a representation of some resource (GET), complete replacement of a representation (PUT), or any of the other standardized methods that tell intermediaries something more valuable than "this may change something." The other methods are more valuable to intermediaries because they say something about how failures can be automatically handled and how intermediate caches can optimize their behavior. POST does not have those characteristics, but that doesn't mean we can live without it. POST serves many useful purposes in HTTP, including the general purpose of "this action isn't worth standardizing."
  5. ^ Kann, Charles. Programming for the Web - From Soup to Nuts - Implementing a Complete GIS Web Page. Gettysburg College. pp. 6.1 CRUD Interface.
  6. ^ Paul M. Jones (2008). "BREAD, not CRUD".
  7. ^ McGaw, James (21 June 2010). Beginning Django E-Commerce. p. 41. ISBN 9781430225362.
  8. ^ "CRAP and CRUD: From Database to Datacloud - Direct2DellEMC". Direct2DellEMC. 2012-11-13. Retrieved 2018-01-30.
Retrieved from "https://en.wikipedia.org/w/index.php?title=Create,_read,_update_and_delete&oldid=1080006160"