General question about persistence SQLite
If I deploy a Python Application that uses SQLite on the same host will the data persist while the server is running? And will the data be cleared out when the server resets?
7 Replies
Project ID:
N/AN/A
will the data persist while the server is running?yes, keyword: while
And will the data be cleared out when the server resets?correct, data in your sqlite database will be "cleared" when your redeploy for data persistence, you would want to use a volume and store the sqlite file in the volume https://docs.railway.app/guides/volumes
Thank you. One last question. I am asking these questions in anticipation of deploying a Reflex application which has SQLite built in.
I see you created a template here https://railway.app/template/A5TaaV
Do I just need to add the extra files (i.e. nixpacks.toml, Caddyfile etc...) to my build prior to deploying?
BTW really appreciate you setting this up and working out the kinks in getting it deployed.
those files are critical for deployment, users leaving them out is why the template has a low score
Sounds good. I am glad to have this resource for when I am ready to attempt my first Reflex deploy. Thanks again for your help.
no problem!