I have a Shiny application that uses a SQLite database as persistence layer.
The UI includes various input controls that insert data into said database.
However, even though in the immediate timeframe, the new entries seem to be written as expected, and expected changes can be seen, after a certain period all changes get reverted.
It is as if whenever the instance is stopped, everything gets reset.
It is expected behavior?
If so, what would be the recommended implementation approach for instances to not get reset?
Where is the database ? It should be externally hosted if persistancy is required.
The database is technically a file, somewhere in the application package.
Am I to understand shinyapps.io doesn't support the scenario I am describing?
Yes, it doesnt offer permanent storage. It will be temporary through a session only.