Skip to content

abreits/node-red-contrib-oracledb

Repository files navigation

Node-RED Oracle Database nodes

node-red-contrib-oracledb 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

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 as a global package as well:

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

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

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.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 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.

Planned

  • Improve documentation
  • Make testable
  • Add localization

Realized

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

About

Node-RED oracle database nodes

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published