This repository contains a Shiny application for analyzing and visualizing Eurostat data. The application is built as an R package using the golem framework, ensuring modularity, scalability, and ease of deployment.
This package is not maintained and comes 'as is'
- Modular Shiny app structure for maintainability and scalability
- Database connectivity using environment variables for secure configuration
- Multi-layered data visualization and interaction
- Customizable UI with external resources (JS/CSS)
- Automated testing and CI/CD integration
- Ready for deployment on RStudio Connect, Shiny Server, Docker, and more
Clone the repository and install dependencies:
# Install required packages
install.packages(c("golem", "shiny", "DBI", "odbc", "config", "dplyr", "reactable"))
# Install the package (from the project root)
devtools::install()
Set the required environment variables for database access in a .Renviron
file:
DB_SERVER=your_server
DB_DATABASE=your_database
DB_USERNAME=your_username
DB_PASSWORD=your_password
DB_DRIVER=your_odbc_driver
DB_SCHEMA=your_schema
# When using a sqlite database you just need this:
SQLITE_DB_PATH=your_sqlite_file
To run the app in development mode:
# From the project root
golem::run_dev()
Or use the provided script:
source("dev/run_dev.R")
R/
- R source code (modules, helpers, UI, server, etc.)inst/app/www/
- Static resources (JS, CSS)data_preperation/
- SQL scripts for data preparationtests/
- Unit testsdev/
- Development scripts for setup, development, and deployment
See dev/03_deploy.R
for deployment instructions to various platforms, including RStudio Connect, ShinyApps.io, and Docker.
See the DESCRIPTION
file for licence information.
See the DESCRIPTION
file for author information.
This project was generated using the golem framework.