This is a quick placeholder cross-post of the 'so I can find it again' category: Sergio Leunissen from our Linux group has a blog post on using Node.js and...
This is a quick placeholder cross-post of the 'so I can find it again' category: Sergio Leunissen from our Linux group has a blog post on using Node.js and node-oracledb on Oracle Linux. You can find the post here. The Oracle Linux RPMs packages make it all so easy!
This is a quick placeholder cross-post of the 'so I can find it again' category: Sergio Leunissen from our Linux group has a blog post on using Node.js and node-oracledb on Oracle Linux. You can find...
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...
