IO - CRUD (Create/Read/Update/Delete) - basic functions of persistent storage
About
In computer programming, create, read, update and delete (as an acronym CRUD) are the four basic functions of persistent storage.
Operation
| Operation | SQL | HTTP | File System | mutator |
|---|---|---|---|---|
| Create | INSERT | PUT / POST | write | Row Level |
| Read (Retrieve/Query) | SELECT | GET | read / take | - |
| Update (Modify) | UPDATE | POST / PUT | write | Field Level |
| Delete (Destroy) | DELETE | DELETE | delete/dispose | Row Level |
Principle
- CQS Principle - Asking a question should not change the answer. ie Query should not change data.
- Design - CQRS (Command Query Responsibility Segregation) - Read not where you write
