Suport Oracle database to read from

[DestBro]

We use Oracle database, and I would like the DataFrame lib to support it natively.

I know I can use https://kotlin.github.io/dataframe/readsqlfromcustomdatabase.html, but maybe it's not so hard to add the support officially, the syntax is not so different from other SQL databases, thank you.

[zaleslaw]

@DestBro yes, highly likely we could?
Could you please highlight, is it possible to use non-commercial Oracle license for testing or development of the integration?

[DestBro]

@DestBro yes, highly likely we could?
Could you please highlight, is it possible to use non-commercial Oracle license for testing or development of the integration?

I'm not a lawyer or a representative of Oracle company, I can provide info that I find but can't ensure it's true.
I found this info:
❌ Oracle Technology Network (OTN) License: grants you a limited right to use the software internally for the purpose of developing, testing, prototyping, and demonstrating your applications. But it cannot be used for any data processing, business, commercial, or production purposes.
🤔 Oracle Database Express Edition (XE): free for all uses, including development, testing, and production in a commercial setting, if the integrated application will not exceed its hardware limits (1 CPU, 2 GB RAM, 12 GB user data).

Some more context:
I remember Jetbrains already has a tool/plugin that uses jdbc to connect to Oracle DB:

https://www.jetbrains.com/help/idea/relational-databases.html

https://www.jetbrains.com/pages/intellij-idea-databases

Maybe it's another case, but I believe knowledge transfer within the company might help navigating this feature adoption. However given the fact that you have to deal with licensing, I'm ok if this feature is not developed, just for safety.