CURD = CREATE-UPDATE-READ-DELETE
These four operations are used to manipulate the data in database, users must be able to create data, read data, update or edit the data, and delete the data. curd sometimes used to describe user interface conventions that facilitate viewing, searching, and changing information using computer-based forms and reports.
curd is extensively used in database applications. This includes Relational Database Management Systems (RDBMS) like oracle, mysql, and postgresql. It also includes nosql databases like mongodb, apache cassandra, and AWS dynamodb.
CREATE
create operation adds a new record to a database, in RDBMS, a database table row are called record and columns are called fields. Create operation adds one or more new records with distinct field values in a table. in sql database, to create is to Insert and in a nosql database like mongodb, you create with the insert()
method.
UPDATE
update is the operation that allows you to modify existing data. That is, editing the data. unlike READ
, the UPDATE
operation alters the existing data by making changes to it.
In sql database, you use Update
to Update an entry. In a nosql database like mongodb, you can implement an update feature with the FindByIdAndUpdate()
method.
READ
The read operation means getting access to the entries in the database. that is, seeing it. Again, the entry could be anything from user information, This access could mean the user getting access to the created entries right after creating them, or searching for them.
in sql database, to read is to S
elect an entry. In a nosql database like mongodb, you read with the find()
or findById()
method.
DELETE
delete operations allow the user to remove records from the database or delete operation is used to delete or remove any existing records from the table. one should be much more careful while executing the delete operation.