CRUD Operations With An Example
What is CRUD ?
The term CRUD relates to data management. As an acronym, CRUD comes in the software industry and represents the four branches required to implement a permanent storage application:
- Create
- Read
- Update
- Delete
These are the four basic operations of persistent storage. Alternate words are sometimes used when defining the four basic operations of CRUD, such as construct instead of create, retrieve instead of read, or destroy or destruct instead of delete.
When Should We Use CRUD?
The ability to create, read, update, and delete items in a web application is essential for most full-stack projects. Instead of using ad-hoc SQL statements, many programmers prefer to use CRUD because of its performance.
Explain CRUD Elements
Create (create a dataset):
The create function allows users to create a new record in the database. In the SQL relational database application.Performs the INSERT statement to create a new record.
Read or Retrieve (read datasets):
The read function is similar to a search function. It allows users to search and retrieve specific records in the table and read their values.
Update (update datasets):
The update function is used to modify existing records that exist in the database. To fully change a record, users may have to modify information in multiple fields.
Delete or Destroy (destroy datasets):
The delete function allows users to remove records from a database that is no longer needed.
How to Use It ?
The images below are from my CRUD Operations Project. I tried to express it simply.
The main purpose of this project is to save usernames in the database, display them, edit and delete them. If you are curious about the details, you can review my project on my Github page.
I used PostgreSQL technology with PgAdmin for the database:
Connected DB:
Create User:
Get Users From DB:
Update User:
Delete User:
And Finally, How It’s Look Like :)
