I’m working on a little project to automate the setup of a board game to share with my nerdy board game friends while also giving me experience with Streamlit. I have the data in two tables in a SQLite database that I’ve uploaded to my Github. There is nothing secret or sensitive in this database whatsoever. For some reason, I’m getting an error on my deployed app:
OperationalError: no such table: games
This leads me to believe the app is accessing the database, but not finding the tables. My secrets.toml are:
database = "gamessqlite.db"
There are two tables: games and components.
I get the same error when running it locally, however, when I adjust the
db_path in my code from
st.secrets['sqlite'] to the absolute path of the database on my computer, I can run the app just fine. Am I setting my secrets up incorrectly? There was no guide and very little found in my searches for deploying a streamlit app using a SQLite database. Does anybody know what might be happening? I really appreciate the help!