I have too much data for my Shiny app. I need to connect to a remote database - but I'm not super experienced with data bases (basic knowledge of MySQL).
I want to do a simple test to see if I can connect to a remote MySQL database using dbplyr ,pool, RMySQL, etc.
I've been checking out the documentation for these packages, including looking at the videos from rstudio.com published online. The features are great but I'm not getting anywhere with the examples. I think this is because I can't connect to a database to give it a try on.
This is a link that I could've sworn I got working before:
https://shiny.rstudio.com/articles/pool-dplyr.html
But now the database example is broken and will not connect to the db. Virtually all other documentation I come across use examples of reading the database from memory.
Any examples of a database that allows users to read from for testing R database management tools?