Thread by @swapnakpanda

4️⃣ CRUD Operations described wrt SQL, REST API and UI

🧵 👇

0️⃣ Introduction

CRUD stands for Create, Read, Update and Delete.

These are the 4 basic operations of persistent storage.

The term CRUD is also used for Database and UI.

Let's explore these 👇

1️⃣ C for Create

SQL: INSERT into TABLE_NAME VALUES (V1, V2, V3)

REST HTTP Method: POST

UI Form: User Sign Up, Creating a Blog Post etc.

2️⃣ R for READ

SQL: SELECT V2, V3 from TABLE_NAME WHERE V1 = VAL

REST HTTP Method: GET

UI Form: List of Blog Posts, List of Comments

3️⃣ U for Update

SQL: UPDATE TABLE_NAME SET V2 = NEW_VAL WHERE V1 = VAL

REST HTTP Method: PUT

UI Form: Update User Bio, Update a Blog Post

4️⃣ D for DELETE

SQL: DELETE FROM TABLE_NAME WHERE V1 = VAL

REST HTTP METHOD: DELETE

UI Form: Remove a Blog Post, Remove a Comment

That's it guys. Hope this 🧵 helps you in analogising the concept of CRUD from SQL to REST API to UI.

See you soon in another 🧵 👋