Support Oracle DB

[kanso-git]

Problem

Support to Oracle db

[jeveloper]

+1

[YElyousfi]

I noticed that MSSQL is currently a preview feature for Prisma. Is there any timeline for Oracle support? This would greatly increase adoption by large companies.

[gerwinbrunner]

+1

[Gnilherk]

+1

[nat-me]

+1

[rizrmd]

We need this support, and willing to pay for it. Can we setup bounty to accelerate this development ?

[joseviniciusnunes]

+1

[chadelofson]

+1

[pimeys]

The biggest problem I see is there's no Rust crate for Oracle that fits well to the current async/await ecosystem (that I know of). Of course we can do it ourselves as we did with SQL Server. The problem with Oracle are the legal issues of building a client from scratch. You can link to their C library with ffi and that is ok for them, but need a permission to do your own library.

The thing why I don't like binding to C from rust is the possibility of memory bugs that are really nasty to solve. So a good way to get this forward is to get some people to write a modern asynchronous Oracle crate for Rust. That's about 40% of the work, then it's about integration from there on.

[hinogi]

What about letting users use for example oracledb to make the connection on their own?

[rizrmd]

There is MIT licensed crate that support executing SQL:
https://docs.rs/oci_rs/

Maybe we can wrap it with tokio ?
I might bite the bullet like you guys do with tiberius.

[hinogi]

Guess you then have to check what the Oracle Call Interface license is.

[rizrmd]

Quick googling results:

• https://en.wikipedia.org/wiki/Oracle_Call_Interface#OCI-based_libraries
• http://vrogier.github.io/ocilib/

OCILIB is apache licensed and I think it's been around for a while. It encapsulates OCI (Oracle Call Interface), so I think if we create this lib, we can license it similar to OCILIB.

[joseviniciusnunes]

I'm interested in helping, what are the steps to integrate the prism with this client made by oracle itself?

https://www.npmjs.com/package/oracledb

[rizrmd]

I'm interested in helping, what are the steps to integrate the prism with this client made by oracle itself?

https://www.npmjs.com/package/oracledb

I think, the changes should be made on rust side of prisma, and then make sure everything on js side play nice with it...

[chadelofson]

I would be interested in helping get this driver done

[drodsou]

This would be a much appreciated feature, specially given the free availability of Oracle DBs in the cloud: https://www.oracle.com/cloud/free/#always-free

[hinogi]

Maybe just add support for oracle db here for the SQL Query AST and Visitor
https://github.com/prisma/quaint
@joseviniciusnunes @rizkyramadhan @chadelofson

[hinogi]

+1

[charleaux]

+1

[technervs]

correct me if I'm wrong, but I believe that the problem is not why oracle is closed, because while prism does not approve oracle, typeorm and knex have already done that.

[hinogi]

I meant the prisma connector api

[technervs]

I meant the prisma connector api

it helps?
https://www.oracle.com/br/database/technologies/appdev/rest.html

[agustindev]

I can help with the support too

[koka0012]

If needed I can allocated a part of my team to help creating this connector.

[sheen4n]

Reviving this, does anyone what are the things that we can do to make this connector a reality?

I am sure tons of people are willing to help

[nicholasvperry]

I agree and would love to see Oracle support. But for those who are looking for something until it does work, oracledb works very well.

[JaffParker]

Indicating support as well. I'm not an Oracle professional, I've been forced into it by the institute I work for. I'd love to abstract it as much as possible.

[vancerbtw]

Is there any formal headway being made on this now?

[gvenzl]

Hi all,

I am the Oracle Database Product Manager and working for Oracle.
Thanks all for expressing your interest in having Oracle Database support for this great project.
I too would like to see Prisma support for Oracle Database.

Although I do not fully understand the architecture of Prisma, please forgive my lack of awareness, we do offer a fully open-source JavaScript driver and fully open-source C bindings for our C-based (Oracle Call Interface) drivers, called ODPI-C.

These C bindings (ODPI-C) are the same that are used for the open-source, community-built Rust driver oracle.

Furthermore, the required C driver libraries are available for free as a package called the Oracle Instant Client which is licensed under Oracle's Free Use Terms and Conditions.

Last but not least, there is also a free-to-use Oracle Database variant called Oracle Database Free, which is also licensed under the same Free Use Terms and Conditions.
You can quickly pull a Docker image of that Oracle Database Free image via docker pull gvenzl/oracle-free:slim.

With all that information laid out, are there still any technical or licensing obstacles that would prevent Oracle Database support for Prisma?

Thanks,

[janpio]

No, that sounds good.

Would you say the Rust driver is stable and mature enough to support the full relevant feature set?

Now of course someone "only" has to add an Oracle-compatible SQL dialect to Prisma (provider oracle would be the obvious choice), implement the Introspection queries, generation of Migration SQL, and of course all the SQL to run the possible queries from Prisma Client. Right now that is not on our roadmap.

[JaffParker]

@janpio would you accept contributions despite it not being on your roadmap? It's pretty important for a few, I'm sure we'd chip in.

[janpio]

Sure, the code is all on GitHub, so if you can figure it all out, we are willing to either review the PRs at the end or help how to set up a fork that could add support for this new provider.

[gvenzl]

Hey @janpio,

Would you say the Rust driver is stable and mature enough to support the full relevant feature set?

Yeah, the Rust driver that I've linked above is stable and mature. We know the developers, and they are doing great work there. And I'm sure that in the unlikely event that we were to find anything, we could also report any issues to the driver team there and ask them for a fix in a true open-source community spirit.

To @JaffParker's point and earlier comment, a few people here have stated interest in helping to add Oracle Database support, e.g., @joseviniciusnunes, @chadelofson, @agustindev, @koka0012

And I, of course, am willing to provide answers, clarity, and help wherever possible.

[alexiuscrow]

👀

[ThorstenMewesSPK]

Hi all, just discovered this while searching the web for a reliable oracle orm solution. Would really love to see this come to live! We could provide help with generating oracle dialect and sql syntax as requested by @janpio:

Now of course someone "only" has to add an Oracle-compatible SQL dialect to Prisma (provider oracle would be the obvious choice), implement the Introspection queries, generation of Migration SQL, and of course all the SQL to run the possible queries from Prisma Client. Right now that is not on our roadmap.

[leonardoRocchini]

It would be great to have an oracle Prisma adapter. There are updates?

[phabreeze]

any updates on this adapter?

[janpio]

No updates or concrete plans right now. This issue is just here to track the demand for this via 👍 reactions to the original issue text.

[lroal]

An alternative ORM that supports Oracle is https://github.com/alfateam/rdb

[hinogi]

Well there are other ORMs that support oracle, good old typeorm has also support for oracledb. More modern query builder lack support for oracle most of the time.

[CHSchuepfer]

Yeah, moved on as well. Just forgot the remove the notification.

[cjbj]

One note that may not be known by the non-Oracle user is that node-node-oracledb 6 by default is pure JavaScript and is fully open source. This makes installation and use trivial. Optional, advanced DB features are available if Oracle Instant Client / Oracle Client is additionally installed with node-oracledb but most users don't need them.