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?