Protecting a SQLite db in a subdirectory

I’m a total noob, so forgive me if this is a dumb question. I’m building a streamlit app and I have a sqliteDB for the backend. I put it in a subfolder called “x”. Is there anyway to keep that folder and the db from being downloaded? I haven’t deployed anything yet but I’m about to. Just curious. I’m not going to include anything too sensitive in there but I’d like to have individual users track their progress in tutorials and I’m doing that with SQLite.

Thank you much!

Hi @Collin_Smith

You can use st.experimental_connection to connect to the database while the database file can be hosted remotely on the cloud. Please see this page for more details on how to do that: https://experimental-connection.streamlit.app/S3,_GCS,_and_cloud_files?utm_medium=oembed

More info on st.experimental_connection on the Docs page: st.experimental_connection - Streamlit Docs

Hope this helps!

Best regards,
Chanin

1 Like

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.