Connection to a sqlite database on the host


#1

Hi,

I try to deploy a application on which multiple users should be able to update a shared sqlite database.
This sqlite database would be located on the host (for example /home/shiny/db.sqlite)

I looked at the post https://www.openanalytics.eu/blog/2017/11/12/shinyproxy-1.0.2/
In the documentation, I also see there is also a container-network argument.

Is there a way to configure an application to read/write files on the host ?
Is there an impact on R syntax within shiny app ?
DBI::dbConnect(RSQLite::SQLite(), dbname = path)

I think permission rights may also be an issue, no ?

Thanks very much!


#2

I wonder if it would work to link database into a docker via -v argument?


#3

Hi @stephLH,

You can use the container-volumes field in your application specs to mount specific folders / files on your host into your Docker container. This is the equivalent of the docker run -v @Roman_Lustrik mentioned. See https://www.shinyproxy.io/configuration/#apps

Hope this helps!

Best,
Tobias


#4

Thanks both of you, I will try the -v argument ASAP.