Create Development Environment

[5coho]

This ticket aims to track progress in creating a development environment. Item to complete:

• Dockerfile for R Shiny app
• Dockerfile for PostgreSQL Database
  • Schema matching
  • Test Data
• Docker Compose file
  • DB
  • App
  • PG Admin
• Makefile
• Repo documentation update
• GitFlow (Not this time)
  • main branch -> Prod
  • dev branch -> Non Prod
  • Branch Protection

[5coho]

Working Branch: https://github.com/bcgov/watershedBC/tree/29-dev-environment

[5coho]

Having some issues with using the rocker/rshiny image:

• after installing r dependencies total image size is ~2.3GB which is ridiculous. I'm going to try and build my own and hope for improvement
• After running app.R using Rscript app.R I get a couple things:
  • The app listens on different ports every time the container restart? It should default to 3838. I'm wondering if the base image is overwriting usage of that port.
  • Even setting the port using options=list(port=3838) port forwarding fails
  • setting network_mode: host gives firewall unrestricted access

[5coho]

Tables that are not created in the local DB because they have no reference in the app:

• public.bc_seasonal_regimes_alex_analysis_jan18_21clust
• public.bc_seasonal_regimes_alex_analysis_jan18_21clust_wsc_parde_lon
• public.bc_seasonal_regimes_alex_analysis_jan18_21clust_wsc_parde_lon_s
• public.spatial_ref_sys
• public.test
• public.vri
• public.watershed_statistics
• public.wsc_drainagebasin_4326
• public.wsc_monthly_with_attri_dams_20240204

[bevingtona]

Having some issues with using the rocker/rshiny image:

• after installing r dependencies total image size is ~2.3GB which is ridiculous. I'm going to try and build my own and hope for improvement

• After running app.R using Rscript app.R I get a couple things:

  • The app listens on different ports every time the container restart? It should default to 3838. I'm wondering if the base image is overwriting usage of that port.
  • Even setting the port using options=list(port=3838) port forwarding fails
  • setting network_mode: host gives firewall unrestricted access

Not sure how to solve the container size issue..

Maybe something like r-minimal can be used? https://github.com/r-hub/r-minimal
There is a lot of base functionality missing, but we can add it back as needed.

[5coho]

Container issue fixed. Using rocker/r-ver:4.3.3 as base and installing required system geo packages. Greatly reduced the image size and runs much smoother using the R -e "shiny::runApp(...)" then using an R shiny server image.