C.R.U.D is an acronym for:

• Create
• Read
• Update
• Delete

Let's make a posts folder in the api directory and posts.router.js file inside of that

Add some comments

// [CREATE] a new post
// [READ] a post
// [UPDATE] the data in a post
// [DELETE] a post
// * [READ] ALL of the posts

These roughly translate to http protocol methods and SQL commands

• [CREATE] → [POST] → [INSERT]
• [READ] → [GET] → [SELECT]
• [UPDATE] → [PUT] → [UPDATE]
• [DELETE] → [DELETE] → [DELETE]

Why do we want to know this?

Our server will eventually communicate with our database using http methods and if our database is SQL based we'll need to know a little about SQL even with an ORM.

ORM stands for "Object-relational mapping" and it is a piece of software that stands between your app and database. Often different databases are used to develop with vs production, an ORM lets you write code once and then it will translate to the specific database's flavor of SQL.

The other thing we need to know a little about is the http protocol. In order to ask for data or send data we need to know where and how that data should be sent.

TODO: Talk about request and response