Hi @gmiliotis,
Thanks for posting!
Sharing @randyzwitch’s response from a similar post:
sqllite is a special case of databases, in that sqllite is a file that can be committed to a Git repo. Other databases, like postgres that you mention, are whole programs running in their own process on a server.
In the case of a private repo, the only way to make what you want work is to somehow be able to download that sqlite file into your app. Its possible that you could use secrets management to have SSH keys in your Streamlit sharing app that would allow you to clone a private repo into your Streamlit sharing app location. But that’s pretty close to having the sqlite database public.
So yes, if you want to have an app backed by a database, and you don’t want that data to be public, using a database such as postgres hosted somewhere else is probably the best solution.
I also recommend checking out the following thread: Streamlit and sqlite | Update database by sharing the web app
Caroline 