i have an app that displays data and gathers feedback from the users.
It writes the feedback to a sqlite db and file.
For every new session it seems that the db file reverts to the version that was uploaded when deployed through positron.
how can the db be kept persistent across active sessions and time ? The answers on this forum do not seem to adress this issue.
That's right, shinyapps.io (and as of this post, our newer similar offering, Connect Cloud) do not permanently retain data your application writes to disk during runtime. We discuss this in our documentation. I understand how this could be a severe limitation for your particular use case. Many customers with similar needs use another solution such as an external database or object storage to persist that portion of their application.
I am interested in growing Connect Cloud to provide a simpler solution to the problem you describe. Let me know if you would be interested in participating in any pre-release, beta quality programs related to this capability in future.