{"id":36773,"date":"2023-10-04T19:41:28","date_gmt":"2023-10-04T16:41:28","guid":{"rendered":"https:\/\/orbitsoft.com\/blog\/?p=36773"},"modified":"2023-12-13T13:28:17","modified_gmt":"2023-12-13T10:28:17","slug":"crud-for-dummies","status":"publish","type":"post","link":"https:\/\/orbitsoft.com\/blog\/crud-for-dummies\/","title":{"rendered":"CRUD for dummies"},"content":{"rendered":"\n<p>The term CRUD is frequently used by developers. In our article we are going to cast light on what they mean by saying it, i.e., we will provide you with an overview of these 4 operations and examples of which applications belong to CRUD and show you the way they work.<\/p>\n\n\n\n<p>CRUD is an abbreviation for the 4 main operations of managing the data, including create, read, update, delete\/ destroy. We perform these actions while working with any type of information on any system, i.e., websites, applications and databases.<\/p>\n\n\n\n<p>For instance, an admin of an online store can create a product card, read it, update the information in it or delete the card.<\/p>\n\n\n<div class=\"wp-block-lazyblock-figure lazyblock-figure-Zw2a60\"><figure class=\"article__figure \">\n        <div class=\"article__figure-img\" >\n        <img decoding=\"async\" src=\"https:\/\/orbitsoft.com\/blog\/wp-content\/uploads\/tg_image_2504678244.jpeg\" alt=\"\">\n    <\/div>\n        <\/figure><\/div>\n\n<div class=\"wp-block-lazyblock-heading lazyblock-heading-Z1NGzdg\"><h2 class=\"article__h\">CRUD operations <\/h2><\/div>\n\n\n<p>Many data management systems are based on CRUD operations. Developers should take into account their peculiarities and interconnections between them.&nbsp;<\/p>\n\n\n\n<p>For example, it is a no-brainer that a shop administrator should not access the delete function of a product card that has not been created yet. While designing programs it is vital to keep in mind even such blindingly obvious scenarios. Otherwise, the outcomes become highly unexpectable.<\/p>\n\n\n<div class=\"wp-block-lazyblock-heading3 lazyblock-heading3-2owjqk\"><h3 class=\"article__h3\">Create<\/h3><\/div>\n\n\n<p>Obviously, this function involves the creation of a new database record. It can be the addition of a new product page to the catalog or a user login into the system. It is impossible to perform any other operation without the \u201cCreate\u201d one.<\/p>\n\n\n<div class=\"wp-block-lazyblock-heading3 lazyblock-heading3-q98GT\"><h3 class=\"article__h3\">Read<\/h3><\/div>\n\n\n<p>The \u201cRead\u201d operation includes data extraction from the database. A good example here is the view of a product page or reading a blog article.<\/p>\n\n\n\n<p>The access to reading can be restricted. For instance, the user needs access to their shopping cart and payment details, yet this information must be hidden from the rest of the users.<\/p>\n\n\n\n<p>The \u201cRead\u201d function also encompasses the search of the data. The tools helping to find the necessary products among thousands of goods are required. These include filtering, sorting, keyword or item number search.<\/p>\n\n\n<div class=\"wp-block-lazyblock-heading3 lazyblock-heading3-lkeus\"><h3 class=\"article__h3\">Update<\/h3><\/div>\n\n\n<p>The \u201cUpdate\u201d operation encompasses making amendments to the database. For instance, a user can update their profile, whereas an admin is capable of changing the price of a product.<\/p>\n\n\n\n<p>It is vital to store the previously entered information properly after updates. If the user changes their name or updates their photo, the updates must not affect their password or email.<\/p>\n\n\n<div class=\"wp-block-lazyblock-heading3 lazyblock-heading3-Z2auvOa\"><h3 class=\"article__h3\">Delete<\/h3><\/div>\n\n\n<p>This function involves the elimination of irrelevant data. For example, the user can delete their feedback on a product, eliminate their account or clean the products from the trash.<\/p>\n\n\n\n<p>The elimination can be either physical (i.e., without the possibility of restoring the data) or logical &#8211; the data will be hidden, but it can be restored if necessary.<\/p>\n\n\n<div class=\"wp-block-lazyblock-heading lazyblock-heading-1vpwVm\"><h2 class=\"article__h\">CRUD Applications <\/h2><\/div>\n\n\n<p>A CRUD model is one of the most fundamental concepts in database management. It is widely used for designing databases, web applications, API and other information systems.&nbsp;<\/p>\n\n\n\n<p>A CRUD app is any mobile or web application that allows the user to create, view, edit and delete records. It can be written in any language and perform any tasks.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>An example of a CRUD application<\/strong><\/td><td><strong>What can be created, read, updated or deleted<\/strong><\/td><\/tr><tr><td>A task manager<\/td><td>Daily, week, annual tasks<\/td><\/tr><tr><td>A social network<\/td><td>Users\u2019 profiles and postings<\/td><\/tr><tr><td>A messenger<\/td><td>Messages<\/td><\/tr><tr><td>A software for booking tickets, hotels and restaurants<\/td><td>Reservations<\/td><\/tr><tr><td>A food delivery software<\/td><td>Orders<\/td><\/tr><tr><td>A bank application<\/td><td>Payments and transactions<\/td><\/tr><tr><td>Maps<\/td><td>Restaurants, stores, museums, hotels and reviews<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n<div class=\"wp-block-lazyblock-important-block lazyblock-important-block-Z1MoalG\"><div class=\"important-box\">\n  <div class=\"important-box__main\">\n          <p class=\"important-box__h\">An example of an application that does not follow the CRUD model<\/p>\n      \t<p><span style=\"font-weight: 400;\">A weather forecast application allows its users to view the information. The customer can\u2019t create, update or delete the information about the weather forecast.<\/span><\/p>  <\/div>\n  <\/div><\/div>\n\n\n<p>The 3 interacting elements are needed to create a proper CRUD application:<\/p>\n\n\n<div class=\"wp-block-lazyblock-figure lazyblock-figure-1tzv3h\"><figure class=\"article__figure \">\n        <div class=\"article__figure-img\" >\n        <img decoding=\"async\" src=\"https:\/\/orbitsoft.com\/blog\/wp-content\/uploads\/tg_image_4043969829.jpeg\" alt=\"\">\n    <\/div>\n        <\/figure><\/div>\n\n\n<ol>\n<li>The database serves to store, manage and organize the information that an application can use and process.<\/li>\n\n\n\n<li>API (app programming interface) is a set of methods and functions that allow applications to exchange the data. An API lets the user interface retrieve some information from the database.<\/li>\n\n\n\n<li>The User Interface (UI) is a part of an application with which every user can interact, i.e., the window, buttons, forms and menu. The interface helps process queries and receive the information. The UI makes an app accessible and comprehensible to the end user.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-lazyblock-heading3 lazyblock-heading3-Z1Jp04I\"><h3 class=\"article__h3\">The way it works<\/h3><\/div>\n\n\n<p>A person fills in a form by writing in their name, data of birth and email. After pressing the \u201cSave\u201d button, the API receives an HTTPS query. This way the query is redirected to the database so that a new record is added. This is the mechanism of the \u201ccreate\u201d operation.<\/p>\n\n\n<div class=\"wp-block-lazyblock-heading lazyblock-heading-tymXw\"><h2 class=\"article__h\">Conclusion <\/h2><\/div>\n\n\n<p>CRUD operations are a set of the main actions required for managing the data in various systems. \u201cCreate\u201d, \u201cRead\u201d, \u201cUpdate\u201d and \u201cDelete\u201d functions form the basis for the majority of websites and mobile applications. What can improve the development and design of software, scale their reliability and ease of use is the understanding of their use and interactions.<\/p>\n\n\n<div class=\"wp-block-lazyblock-banner lazyblock-banner-Z6M8Ih\"><div \n  class=\"banner\n   \n  \" \n  >\n    <div class=\"banner__body\">\n        <h2 class=\"banner__h\">Business software solutions<\/h2>\n        <div class=\"banner__content\">\n            <ul>\n<li>Solutions for business automation, trade and warehouse accounting, and advertising management.<\/li>\n<li>Ready-made products and outsourcing services.<\/li>\n<li>Outstaffing services.<\/li>\n<\/ul>        <\/div>\n                            <div \n              class=\"banner__button button js-form-modal\n               button_style_light-on-promo2\">\n              Let&#8217;s Discuss Your Project                          <\/div>\n            <\/div>\n    <div class=\"banner__photo\">\n        <img decoding=\"async\" src=\"https:\/\/orbitsoft.com\/blog\/wp-content\/uploads\/friendship.png\" alt=\"\" class=\"banner__img\">\n    <\/div>\n<\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>The term CRUD is frequently used by developers. In our article we are going to cast light on what they mean by saying it, i.e., we will provide you with an overview of these 4 operations and examples of which applications belong to CRUD and show you the way they work. CRUD is an abbreviation [&hellip;]<\/p>\n","protected":false},"author":214,"featured_media":36776,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[195],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>CRUD for dummies - OrbitSoft Blog<\/title>\n<meta name=\"description\" content=\"We are going to tell you about 4 CRUD operations, provide you with examples of CRUD applications and show you the way they work\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/orbitsoft.com\/blog\/crud-for-dummies\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"CRUD for dummies - OrbitSoft Blog\" \/>\n<meta name=\"twitter:description\" content=\"We are going to tell you about 4 CRUD operations, provide you with examples of CRUD applications and show you the way they work\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/orbitsoft.com\/blog\/wp-content\/uploads\/tg_image_47684397.jpeg\" \/>\n<meta name=\"twitter:creator\" content=\"@orbitsoft\" \/>\n<meta name=\"twitter:site\" content=\"@orbitsoft\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"elevina\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"CRUD for dummies - OrbitSoft Blog","description":"We are going to tell you about 4 CRUD operations, provide you with examples of CRUD applications and show you the way they work","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/orbitsoft.com\/blog\/crud-for-dummies\/","twitter_card":"summary_large_image","twitter_title":"CRUD for dummies - OrbitSoft Blog","twitter_description":"We are going to tell you about 4 CRUD operations, provide you with examples of CRUD applications and show you the way they work","twitter_image":"https:\/\/orbitsoft.com\/blog\/wp-content\/uploads\/tg_image_47684397.jpeg","twitter_creator":"@orbitsoft","twitter_site":"@orbitsoft","twitter_misc":{"Written by":"elevina","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/orbitsoft.com\/blog\/crud-for-dummies\/","url":"https:\/\/orbitsoft.com\/blog\/crud-for-dummies\/","name":"CRUD for dummies - OrbitSoft Blog","isPartOf":{"@id":"https:\/\/orbitsoft.com\/blog\/#website"},"datePublished":"2023-10-04T16:41:28+00:00","dateModified":"2023-12-13T10:28:17+00:00","author":{"@id":"https:\/\/orbitsoft.com\/blog\/#\/schema\/person\/f96c7f7c1bcb1cdf7e1750794548b6fa"},"description":"We are going to tell you about 4 CRUD operations, provide you with examples of CRUD applications and show you the way they work","breadcrumb":{"@id":"https:\/\/orbitsoft.com\/blog\/crud-for-dummies\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/orbitsoft.com\/blog\/crud-for-dummies\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/orbitsoft.com\/blog\/crud-for-dummies\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/orbitsoft.com\/blog\/"},{"@type":"ListItem","position":2,"name":"CRUD for dummies"}]},{"@type":"WebSite","@id":"https:\/\/orbitsoft.com\/blog\/#website","url":"https:\/\/orbitsoft.com\/blog\/","name":"OrbitSoft Blog","description":"Discover the latest in news and resources for OrbitSoft","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/orbitsoft.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/orbitsoft.com\/blog\/#\/schema\/person\/f96c7f7c1bcb1cdf7e1750794548b6fa","name":"elevina","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/orbitsoft.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9f569b41ea8902fc571542fc77005a24?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9f569b41ea8902fc571542fc77005a24?s=96&d=mm&r=g","caption":"elevina"},"url":"https:\/\/orbitsoft.com\/blog\/author\/elevina\/"}]}},"_links":{"self":[{"href":"https:\/\/orbitsoft.com\/blog\/wp-json\/wp\/v2\/posts\/36773"}],"collection":[{"href":"https:\/\/orbitsoft.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orbitsoft.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orbitsoft.com\/blog\/wp-json\/wp\/v2\/users\/214"}],"replies":[{"embeddable":true,"href":"https:\/\/orbitsoft.com\/blog\/wp-json\/wp\/v2\/comments?post=36773"}],"version-history":[{"count":3,"href":"https:\/\/orbitsoft.com\/blog\/wp-json\/wp\/v2\/posts\/36773\/revisions"}],"predecessor-version":[{"id":36779,"href":"https:\/\/orbitsoft.com\/blog\/wp-json\/wp\/v2\/posts\/36773\/revisions\/36779"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/orbitsoft.com\/blog\/wp-json\/wp\/v2\/media\/36776"}],"wp:attachment":[{"href":"https:\/\/orbitsoft.com\/blog\/wp-json\/wp\/v2\/media?parent=36773"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orbitsoft.com\/blog\/wp-json\/wp\/v2\/categories?post=36773"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orbitsoft.com\/blog\/wp-json\/wp\/v2\/tags?post=36773"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}