red-contrib-oracledb-mod v0.5.7

Node-RED Oracle Database nodes

Forked version with updated drivers to support latest node versions

node-red-contrib-oracledb-mod is a Node-RED package that connects directly to an Oracle database server. It currently contains a query and a configuration node to connect to Oracle databases for Node-RED storage.

It uses the oracledb library for the Oracle database connectivity.

Table of Contents

• Installation
• Overview
• Known issues
• What's new
• Roadmap

Installation

If you have installed Node-RED as a global node.js package (you use the command node-red anywhere to start it), you need to install node-red-contrib-oracledb-mod as a global package as well:

$[sudo] npm install -g node-red-contrib-oracledb-mod

If you have installed the .zip or cloned your own copy of Node-RED from github, you can install it as a normal npm package inside the Node-RED project directory:

<path/to/node-red>$ npm install node-red-contrib-oracledb-mod

Overview

This is a Node-Red Oracle database input/output node. The function it provides depends on the query that is sent to the oracle database. An INSERT query stores data in the database and a SELECT query can send data to another node.

Known issues

• none

What's new

version 0.5.7

Fixed an issue with initializing bug which cause nod-red to crash

• Dependencies updated as below source-map-support ^0.5.16 → ^0.5.19 tslint ^6.1.0 → ^6.1.2

version 0.5.6

• Dependencies updated as below oracledb ^4.0.1 → ^4.2.0 gulp-rename ^1.4.0 → ^2.0.0 source-map-support ^0.5.13 → ^0.5.16 tslint ^5.20.0 → ^6.1.0

version 0.4.1

• bugfixes
• added some tests

version 0.4.0

• added automatic reconnect to oracle server

version 0.3.0

• added input node functionality for single results and result sets

version 0.2.0

• major refactor, made preparations for better testable code:
  • javascript source code has been translated to typescript
  • gulp build system added
  • if NODE_RED_ROOT environment variable exists, copy build result into its node-red-contrib-oracledb-mod module for quick testing

version 0.1.0

• initial release

Roadmap

The roadmap section describes things that I want to add or change in the (hopefully near) future.

Realized

• Make it an input and output node:
  • Add support to return SELECT query results