search

oracle / node-oracledb

Oracle Database driver for Node.js maintained by Oracle Corp.
http://oracle.github.io/node-oracledb/
Other
2.26k stars 1.08k forks source link

Deploying a node-oracledb application on Cloud #702

Closed devang28 closed 7 years ago

devang28 commented 7 years ago

I have followed and installed the node oracledb from the link here . To work on the local machine, the method used is appropriate, but how should I resolve the challenges while deploying the same application in a production environment on any cloud service(private or public). Lately, I have been trying to get this work on Pivotal Cloud Foundrys cloud service but I wasnt successful.

Most of the cloud services use their own artifactory or a repository to serve the buildpacks, how should the oracledb be included in one of these nodejs buildpacks?

Moreover, how should the oracle SDK and Windows SDK(Visual Studio dependency) and Python dependency be handled because in most cases this also wont be there in the cloud environment.

I am not sure whether this query should have been raised here or any cloud forums but yes since the challenge was with oracledb so I hope it makes sense.

bchr02 commented 7 years ago

Give oracledb-pb a try.

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

On May 24, 2017, at 4:52 PM, devang28 notifications@github.com wrote:

I have followed and installed the node oracledb from the link here . To work on the local machine, the method used is appropriate, but how should I resolve the challenges while deploying the same application in a production environment on any cloud service(private or public). Lately, I have been trying to get this work on Pivotal Cloud Foundrys cloud service but I wasnt successful.

Most of the cloud services use their own artifactory or a repository to serve the buildpacks, how should the oracledb be included in one of these nodejs buildpacks?

Moreover, how should the oracle SDK and Windows SDK(Visual Studio dependency) and Python dependency be handled because in most cases this also wont be there in the cloud environment.

I am not sure whether this query should have been raised here or any cloud forums but yes since the challenge was with oracledb so I hope it makes sense.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

cjbj commented 7 years ago

@devang28 you could use Oracle Cloud: https://blogs.oracle.com/opal/scripting-languages-and-oracle-database-cloud-how-to-do-it

node-oracledb is pre-installed on Oracle Application Container Cloud. For anything else you need to get the node-oracledb shared library and Oracle Instant Client installed. When you've played around, let us know what you decided and how you did it.

brunoborges commented 7 years ago

hey @bchr02, is there a reason why one should use oracledb-pb instead of the official driver? oracledb-pb is a fork of this project

bchr02 commented 7 years ago

My fork doesn't need the dependencies that are needed for compiling, since it includes prebuilt binaries. Also it automatically installs instanctclient and sets up the environment variable so you don't have to. So it makes it easier to get up and running with oracledb.

On May 25, 2017, at 6:25 PM, Bruno Borges notifications@github.com wrote:

hey @bchr02, is there a reason why one should use oracledb-pb instead of the official driver? oracledb-pb is a fork of this project

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or mute the thread.

krismohan commented 6 years ago

In case you didn't notice.. Prebuilt binaries are now available for node-oracledb https://github.com/oracle/node-oracledb/issues/807