posit connect persistent sqlite db

Hello ,

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.

Thank you for your time

JP

Hi @JP_G

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.

Regards
Mike
Connect Cloud engineer

1 Like

Hi @mbaynton ,

thank you for the information. I would be interested in participating in any pre release program or other that are in the pipeline.

best
JPG

@JP_G See this for various options now: Shiny - Persistent data storage in Shiny apps

Thanks all,

I have implemented a googlesheets solution.

For the time being it will be enough.

JP