I deploy a R model to shinyapps.io. It can accept the input parameters from users and output the plot and values my R model calculated. I want to ask if there is a way to create a database at the same time and I can store the parameters that users input?
look at using sqlite3 or duckdb which are both widely used file based databases rathen the server based databases like postgresql, Microsoft SQL server etc
Thank you so much Adam, if I use sqlite3 to create a database in my R code, I deploy it to shinyapps.io. Then how can I retrieve these user input parameters from it or I can use command saveRDS to save the user input parameters, but how can I retrieve this RDS data from it?
Hello, I studied this manual, it looks like that it can provide a solution for my problem.
"One of the consequences of this design is that files written to the file system will be deleted when your application shuts down or moves to another server. These transitions shouldn’t happen while a user’s session is active, so you can safely write temporary files associated with a particular session to the filesystem and expect to read these files back in during the same session. However, local files created by your application will not persist beyond the session in which they are created. If you want to access files after the session has closed, you will need to design your application so that it saves its temporary files to an external service."
It mention that "local files created by your application will not persist beyond the session in which they are created.". SO even though I use saveRDS to save the file, it will be deleted.
I saw the manual provide the solution how to write the data from shinyapp.io to Amazon s3 bucket, is there any R package I wrote the data to Azure Blob storage?
This topic was automatically closed 54 days after the last reply. New replies are no longer allowed.
If you have a query related to it or one of the replies, start a new topic and refer back with a link.