R, Shiny and MySQL Integration Template This example shows how to use AnyChart library with the R programming language, Shiny web framework and MySQL database.

Running

To use this sample you must have R installed, if not you can visit official R site or follow these instructions; MySQL installed and running, if not please check out MySQL download page and follow these instructions.

To check your installations, run the following command in the command line:


$ R --version
R version 3.3.2 (2016-10-31) -- "Sincere Pumpkin Patch"... # sample output

$ mysql --version
mysql  Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6. # sample output
                

To start this example run commands listed below.

Clone the repository from github.com:


$ git clone git@github.com:anychart-integrations/r-shiny-mysql-template.git
                

Navigate to the repository folder:


$ cd r-shiny-mysql-template
                

Set up MySQL database, use -u -p flags to provide username and password:


$  mysql < database_backup.sql
                

Run R:


$ R
                

Install application dependencies, one after another and init Shiny:


> install.packages("shiny")

> install.packages("RMySQL")

> install.packages("jsonlite")

> library(shiny)
                

If you have some troubles with dependencies installation, carefully read error messages, e.g. to install 'RMySQL' you may need:


sudo apt-get install libmysqlclient-dev
                

Run application supplying absolute path to project folder:


> runApp("{PATH_TO_TEMPLATE}") # e.g. runApp("~/work/r-shiny-mysql-template")
                

Your browser will open the appliation automatically.


Workspace

Your workspace should look like:


r-shiny-mysql-template/
    www/
        css/
            style.css       # css style
    app.R                   # main application code
    database_backup.sql     # MySQL database dump
    LICENSE
    README.md
    index.html          # html template
                    

Technologies


Further Learning


License

AnyChart R/Shiny/MySQL integration sample includes two parts:

  • Code of the integration sample that allows to use Javascript library (in this case, AnyChart) with R language, Shiny web framework and MySQL database. You can use, edit, modify it, use it with other Javascript libraries without any restrictions. It is released under Apache 2.0 License.
  • AnyChart JavaScript library. It is released under Commercial license. You can test this plugin with the trial version of AnyChart. Our trial version is not limited by time and doesn't contain any feature limitations. Check details here.

If you have any questions regarding licensing - please contact us. sales@anychart.com