Manage data

Edit databases with CRUD 

Of course, you need to be able to edit a database easily. You should be able to add elements to the tables, delete data, modify information. In most cases, you just want to be able to search, filter and "read" the database information.

The term CRUD stands for: Create, Read, Update, Delete. Of course, user rights must be set on a database. Not everyone should have the right to delete or modify, or even add data. Applications where this can be done, such as Wikipedia, still keep an edit history and have a control mechanism built in to prevent misuse or errors.   

  • Create: Sustainable storage of data. Data should not be stored twice. For example, an ID should always be preserved. If you delete a row, the other rows keep their original ID. Otherwise, the "relationships" are ruined. 
  • Read: Easy search and filtering of data.
  • Update: Update data in the database. 
  • Delete: Deleting data from the database

Examples

Examples of "read":

  • seeing a web page
  • searching for certain products in an online store
  • seeing your timeline on a social media website
  • ...

Examples of "create":  

  • posting a message on social media
  • sending a message to your teacher in an online learning environment
  • placing an order in a web shop
  • ...

Examples of "delete":

  • Deleting a message on "social media" (can also be update)
  • Deleting an account
  • ...

Examples of update 

  • Write over money in a banking application
  • Adjusting your profile information on social media
  • ...
Next page