This example shows how to use Anychart library with the R programming language, Shiny web framework and MySQL database.
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 firstly.
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.
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
Language - R
Web framework - Shiny
Database - MySQL
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