The JavaScript JSON.parse() and JSON.stringify() methods make it easy to work with JavaScript objects in Node.js and store them in Oracle Database using the...
The JavaScript JSON.parse() and JSON.stringify() methods make it easy to work with JavaScript objects in Node.js and store them in Oracle Database using the node-oracledb module. I'll start with some examples showing a simple, naive, implementation which you can use with all versions of Oracle Database. Then I'll go on to show some of the great JSON functionality introduced in Oracle Database 12.1.0.2. The examples below use the async/await syntax available in Node 7.6, but...
The JavaScript JSON.parse() and JSON.stringify() methods make it easy to work with JavaScript objects in Node.js and store them in Oracle Database using the node-oracledb module. I'll start with some...
Some of our node-oracledb users recently commented they have moved from REST to GraphQL so I thought I'd take a look at what it is all about. I can requote the...
Some of our node-oracledb users recently commented they have moved from REST to GraphQL so I thought I'd take a look at what it is all about. I can requote the GraphQL talking points with the best of them, but things like "Declarative Data Fetching" and "a schema with a defined type system is the contract between client and server" are easier to undstand with examples. In brief, GraphQL: Provides a single endpoint that responds to queries. No need to create multiple endpoints...
Some of our node-oracledb users recently commented they have moved from REST to GraphQL so I thought I'd take a look at what it is all about. I can requote the GraphQL talking points with the best...
Release announcement: Node-oracledb 2.3.0, the Node.js module for accessing Oracle Database, is on npm. Top features: Continuous Query Notifications....
Release announcement: Node-oracledb 2.3.0, the Node.js module for accessing Oracle Database, is on npm. Top features: Continuous Query Notifications. Heterogeneous Connection Pools. Our 2.x release series continues with some interesting improvements: Node-oracledb 2.3 is now available for your pleasure. Binaries for the usual platforms are available for Node.js 6, 8, and 10; source code is available on GitHub. We are not planning on releasing binaries for Node.js 4 or 9...
Release announcement: Node-oracledb 2.3.0, the Node.js module for accessing Oracle Database, is on npm. Top features: Continuous Query Notifications. Heterogeneous Connection Pools. Our 2.x...
Native Oracle Database Continuous Query Notification (CQN) code has landed in the node-oracledb master branch on GitHub. If you want to play with it, but don't...
Native Oracle Database Continuous Query Notification (CQN) code has landed in the node-oracledb master branch on GitHub. If you want to play with it, but don't want to wait for the next binary node-oracledb release, you can compile node-oracledb yourself and play with this demo. [Update: node-oracledb 2.3 has been released and binaries are now available.] Some of you may already be using CQN via its PL/SQL APIs. The new, native support in node-oracledb makes it all so...
Native Oracle Database Continuous Query Notification (CQN) code has landed in the node-oracledb master branch on GitHub. If you want to play with it, but don't want to wait for the next...
This post shows how to run a node-oracledb application in a Docker Container. For bonus points, the application connects to an Oracle Database running in a...
This post shows how to run a node-oracledb application in a Docker Container. For bonus points, the application connects to an Oracle Database running in a second container. The steps are the 'show notes' from a recent talk at Oracle Code. The demo app is a simple Express web service that accepts REST calls. DOCKER Oracle Docker images are available from https://store.docker.com/ and also mirrored on https://container-registry.oracle.com If you're not familiar with Docker,...
This post shows how to run a node-oracledb application in a Docker Container. For bonus points, the application connects to an Oracle Database running in a second container. The steps are the...
Release announcement: Node-oracledb 2.2, the Node.js module for accessing Oracle Database, is on npm. Top features: Batch Statement Execution In the six-or-so...
Release announcement: Node-oracledb 2.2, the Node.js module for accessing Oracle Database, is on npm. Top features: Batch Statement Execution In the six-or-so weeks since 2.1 was released, a bunch of new functionality landed in node-oracledb 2.2. This shows how much engineering went into the refactored lower abstraction layer we introduced in 2.0, just to make it easy to expose Oracle features to languages like Node.js. The top features in node-oracledb 2.2 are: Added...
Release announcement: Node-oracledb 2.2, the Node.js module for accessing Oracle Database, is on npm. Top features: Batch Statement Execution In the six-or-so weeks since 2.1 was released, a bunch...
Release announcement: Node-oracledb 2.1.0, the Node.js module for accessing Oracle Database, is on npm. Top features: Privileged connections such as SYSDBA. A...
Release announcement: Node-oracledb 2.1.0, the Node.js module for accessing Oracle Database, is on npm. Top features: Privileged connections such as SYSDBA. A new 'queryStream()' Stream 'destroy()' method After the big refactoring of node-oracledb 2.0, we're pleased to push node-oracledb forward with the release of 2.1.0. Changes in node-oracledb 2.1.0 include: Support for SYSDBA, SYSOPER, SYSASM, SYSBACKUP, SYSDG, SYSKM, and SYSRAC privileges in standalone connections. You...
Release announcement: Node-oracledb 2.1.0, the Node.js module for accessing Oracle Database, is on npm. Top features: Privileged connections such as SYSDBA. A new 'queryStream()' Stream 'destroy()'...
For our Node.js node-oracledb v2 add-on for Oracle Database we revamped its lower data access layer and made it into a standalone project ODPI-C, which is...
For our Node.js node-oracledb v2 add-on for Oracle Database we revamped its lower data access layer and made it into a standalone project ODPI-C, which is being reused by several other language APIs. ODPI-C gave us a reason and opportunity to simplify some of internal query handling code in node-oracledb. To recap, node-oracledb has four ways to execute queries against an Oracle Database. These are the same in version 1 and version 2: Direct Fetches - these are...
For our Node.js node-oracledb v2 add-on for Oracle Database we revamped its lower data access layer and made it into a standalone project ODPI-C, which is being reused by several other language...
Release announcement: Node-oracledb 2.0.15, the Node.js add-on for Oracle Database, is now on npm for general use. Top features: Pre-built binaries, Query fetch...
Release announcement: Node-oracledb 2.0.15, the Node.js add-on for Oracle Database, is now on npm for general use. Top features: Pre-built binaries, Query fetch improvements It's time to shake things up. Node-oracledb version 1 has been stable for a while. Our tight, hard working team is now proud to deliver node-oracledb 2 to you. With improvements throughout the code and documentation, this release is looking great. There are now over 3000 functional tests, as well as solid...
Release announcement: Node-oracledb 2.0.15, the Node.js add-on for Oracle Database, is now on npm for general use. Top features: Pre-built binaries, Query fetch improvements It's time to shake things...
