Data projects: CRUD with Shiny

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: