Help with accessing SQLite database in Github Repo

Using Streamlit
3

I GOT IT!

So, here’s the trick for anybody else looking to use a SQLite database on Github:
Pay attention to your console. When I rebooted my app once more, I watched it spin up in the console. I noticed it cloned the repository over to Streamlit (it’s not just referencing the code from Github). Where it said main module, I got the idea that I could use that as my relative path. That did the trick.

Again, if you’re wanting to use a SQLite database that you host on your Github, your secrets should look something like this:
[sqlite]
path/to/streamlit-cloned-repository/sqlite.db

I have no problem sharing my secrets in this case. Mine are:
[sqlite]
Boardgames/auto-setup/gamessqlite.db

I hope this helps some other newbies out there.

1 Like