In the field of data managment, CRUD is an essential application for making easier the main SQL operations. It refers to an acronym of four operations: create, read, update, delete.
Although there are already several softwares in the market, I consider that creating my own CRUD application in R could be a great exercise for understanding this kind of application in deep. As I like cooking, I used this project to organize all my recipes in a database!
For now, as you can see in the screenshot, you can read the database and create new records (the updating and deleting operations are in development).
SPECIFICATIONS
- Programming language: R
- Used packages: rstudioapi, dplyr, lubridate, shiny, shinydashboard, DT, RMySQL ,shinyBS
- Main problems: :I was not allowed to modify my database from R. The specific error was «Warning: Error in . local: could not run statement: The used command is not allowed with this MariaDB version [No stack trace available]. The problem was that the «local_infile» setting was disabled by default, so we had to tell the server to enable it. You can read more about it here.
- Next steps: Include the update and delete operations
- Links: