autonomous-db

Autonomous Data Base (experimental) (unoficcial)

This repository contains the npm package's to work with Oracle Autonomous Data Base for NodeJs developers (unoficcial) name autonomous-db.

Setup

First you need install Node and the autonomous-db package:

npm install autonomous-db

The config's values come from your Autonomous Data Warehouse (ADW) / Autonomous Transaction Procesing (ATP), look for Oracle Rest Data Services (ORDS) URL, finally, this user must to have ORDS permissions too.

Example

const adb = require('autonomous-db');

const config = {
    ordsUrl : "https://<host>.adb.<region>.oraclecloudapps.com/ords/",
    user : "user",
    password : "password",
};

const db = new adb.AutonomousDataBase(config);

db.query("SELECT sysdate FROM dual")
.then(data => console.log(data))
  .catch(err => console.log(err));

References

• ORDS
• OML
• SODA
  • Use Oracle Database Actions with SODA
  • A Supported SQL*Plus and SQLcl Commands
• JSON
  • Oracle SQL Function JSON_SERIALIZE
  • JSON_ARRAY SQL/JSON Function