Here is just one example to illustrate why everyone needs a simple CRUD interface: Say you have an application that contains a large amount of information about your company’s clients, and this information is entered by uploading a large spreadsheet. What if someone notices that a name has been misspelled or an address has a typo? Without a simple CRUD interface, there are two ways to change this data. First, you could use another spreadsheet, but it must be prepared and uploaded. The original could be millions of rows long, and locating and correcting a single piece of data could be time consuming. Another method to change that value is to contact the database admin and ask them to manipulate the data. This is highly discouraged, because the admin may not know how changing that piece of data could affect the performance of the application. The formatting of the data could be important, or the old piece of data could be relied on in other places.
- Case Studies