DEV Community

Cover image for What is CRUD?
Patrick
Patrick

Posted on

What is CRUD?

We interact with the CRUD application daily as part of our work. Maybe you record a task in your phone's calendar or take notes.

CRUD is the acronym for Create, Read, Update, and Delete. Any program's basic operations are known as CRUD.

The CRUD application consists of three key components:

  • Database
  • User interface
  • API or back-end system

The database is used to store data. A relational (SQL) or non-relational (NoSQL) database can be used. In most CRUD applications, relational databases are used. MySQL, MariaDB, PostgreSQL, and MS SQL are some of the most popular relational databases.

User Interface (UI) display data in a user-friendly format. With the user interface, the user makes API calls.

The API or back-end system communicates between the database and the user interface. It contains functions for performing CRUD operations.

Computer

CRUD operations

We know four different CRUD operations: create, read, update and delete. Each of these operations has its function in the SQL programming language.

CREATE INSERT
READ SELECT
UPDATE UPDATE
DELETE DELETE

API requests can use different HTTP methods.

We know different HTTP methods such as POST, GET, PETCH, PUT, DELETE. Each letter of the CRUD can be associated with a specific HTTP method.

These are usually:

CREATE POST
READ GET
UPDATE PUT
DELETE DELETE

The create operation allows us to create new rows in the database.

The read operation retrieves data from the database. It can return different data to us, depending on the filters created.

The update operation updates the existing data in the table. We can update only one line in or even more lines at a time.

The delete operation allows us to delete a row in the database.

Some CRUD application ideas

  • To-Do list
  • library system,
  • account management system
  • notebook
  • contact manager

I hope you have got an idea of what CRUD is and how we use it daily.


You can start following me on Twitter, or you can buy me a cup of coffeeโ˜• if you enjoy it.

Discussion (0)