Add docs showing how to connect to Oracle Databases

[sayedathar11]

Hiii Streamlit Team,
As per the documentation given here , currently Streamlit supports connection to Big Query , My Sql and various other databases . But I noticed that there is no functionality and module available to connect to Oracle Database .
Oracle Databases are used by lot of companies and adding module to connect to Oracle Database will make streamlit more complete and diverse library !
So can you please look into it and make the latest version available.
Thanks and Regards
Athar

[vdonato]

Hi @sayedathar11, thanks for the suggestion.

Since streamlit apps are written in plain python, there's no reason that you can't already use your preferred oracle db library with streamlit. The documentation provides some examples for how to use a few popular databases with streamlit, but we haven't done any work to streamlit itself to add support for these databases -- any database is supported if you're able to install the appropriate library to work with it.

I'll keep this issue open but change its title to be a request for documentation.

[egnofam]

Hello,
I hope you are doing well. I would like to know how to connect streamlit to oracle db?
Thanks in advance.

[snehankekre]

Hi @egnofam, 👋

Quoting Vincent from before:

Since streamlit apps are written in plain python, there's no reason that you can't already use your preferred oracle db library with streamlit. The documentation provides some examples for how to use a few popular databases with streamlit, but we haven't done any work to streamlit itself to add support for these databases -- any database is supported if you're able to install the appropriate library to work with it.

Think of Streamlit just as the frontend in this case. The connection to your preferred orcale db would happen via the use of a third-party Python library that connects to oracle. So, you'd need to figure out how to connect your Python script to Oracle.

The following resource will help (5. Create a Python Application) https://www.oracle.com/database/technologies/appdev/python/quickstartpythononprem.html#linux-tab

Please upvote this issue if you'd like to see us prioritize an official connection tutorial for Oracle.