A couple of weeks ago I release a video that showed people how to get up and running with Node.js and Oracle on the App Dev VM. This post builds on the work done there and demonstrates some of the power and flexibility of Node.js and the Oracle Database Node.js Driver.
Last week I started thinking about a new project for the Oracle Database Node.js Driver. I have a lot of experience with Oracle Application Express (APEX) and I wondered if it would be possible to use the driver as the basis for a new APEX listener powered by Node.js.
APEX, for those that don’t know it, is a declarative environment for creating web applications on the Oracle Database. APEX is included with the Oracle Database license, including the free XE edition. At any rate, APEX runs in the database and thus requires some kind of “web listener” to proxy communications between the Oracle Database and the client. You thinking what I’m thinking??? Let’s do it with Node!
Back to the the Node.js APEX listener… I was able to get the basics working! Keep in mind: This code is NOT ready for production use (not even close). But it is pretty cool!
Check out the video to see it in action and follow these steps if you’re interested in giving it a whirl:
- If you haven’t already done so, watch this video and follow the steps to get Up and Running with Node.js and Oracle
- In the VM, open a terminal and enter the following:
1234567cd ~/node-oracledb/node-oracledb-master/examples/wget "https://jsao.io/node-apex-listener-0.1.0.zip"unzip node-apex-listener-0.1.0.zipcd node-apex-listener-0.1.0/npm installnode index.jsfirefox localhost:7000/apex/f?p=4550
- Login with hr/hr/oracle
- That’s it!