Search for a command to run...
No comments yet. Be the first to comment.
Time is money. Today, we want to make as much software as possible with the least amount of effort. Large online stores are developing their own smartphone applications. But what are the advantages of a progressive app for a business? Benefits of a ...
Hey 👋, I'm back with a new blog post after a long break! This past week, I’ve been diving deep into integrating push notifications into a mobile app. If you've ever wondered how they work and why they’re so effective, this post is for you! What Are ...
I'm back again with a new blog post. The idea for this post came very spontaneously. I'm currently investing a lot of time in my new development project, and I came up with how to further secure the application. As a solution to this issue, quite a f...
Node.js is an engine that allows us to run JavaScript outside the browser. Many applications today are powered by Node.js, offering numerous advantages and a few drawbacks. However, my intention today is not to introduce Node.js or JavaScript. Today,...
I have said many times that computer science is a huge field in which everyone can find themselves. Being a computer science student has its advantages and benefits, and one such advantage is what GitHub offers with its GitHub for Education program a...
Open Graph is an Internet protocol created by Facebook to standardize the display of metadata on social networks. What advantages does it bring? Open Graph brings advantages when displaying a website on social networks. Open Graph makes our posts mor...
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:
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.
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
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.
