Registry / database / oracle-orm

oracle-orm

JSON →
library0.1.9jsnpmunverified

A minimal Oracle database ORM for Node.js, version 0.1.9, designed as a lightweight alternative to other Oracle ORMs. It automatically maps database tables to Model objects and provides basic CRUD operations with safety against SQL injections. This package requires manual installation of Oracle Instant Client and libaio, and does not support connection pooling, error recovery, or advanced features. It targets developers who need a simple, predictable ORM for Oracle without unexpected table name pluralization or invalid SQL generation. The project appears stable but with limited maintenance and community adoption.

database
github ↗package ↗homepage ↗
Install & Compatibility
Where this runs

No compatibility data collected yet for this library.

Code
Verified usage

Verified import paths — ran on the pinned version, not inferred.

Package uses CommonJS; ESM import is not supported (no default export). Use require().

const ORM = require('oracle-orm');

Callback is required as third argument; omitting debug parameter will cause undefined errors.

new ORM({driver: 'oracle', hostname: '...', ...}, debug, callback)

API is callback-based only; promises/async/await not supported natively.

orm.getModels(function(err, models) { ... })

Connects to Oracle, retrieves all models (tables), and fetches all rows from USERS table ordered by USER_ID ascending.

const ORM = require('oracle-orm'); const config = { driver: 'oracle', hostname: process.env.DB_HOST ?? 'localhost', port: 1521, database: process.env.DB_SID ?? 'XE', user: process.env.DB_USER ?? 'user', password: process.env.DB_PASS ?? '' }; new ORM(config, false, function(err, orm) { if (err) return console.error(err); orm.getModels(function(err, models) { if (err) return console.error(err); if (models.USERS) { models.USERS.get({}, ['USER_ID ASC'], function(err, rows) { if (err) return console.error(err); console.log(rows); }); } }); });
Debug
Known footguns
gotchaRequires Oracle Instant Client and libaio installed manually; npm install may prompt for sudo to set environment variables.
breakingCallback is required as third argument to ORM constructor; omitting it will cause undefined is not a function error.
deprecatedAll API methods are callback-based; no promise or async/await support.
gotchaTable names are used as model keys exactly as they appear in the database (uppercase by default).
gotchaNo connection pooling; every ORM instance creates a single connection.
Upgrade
Version history

Breaking-change detection hasn't run for this library yet.

Audit
Security & dependencies

CVE tracking and dependency tree are planned for a later release.

Agent activity
7 hits · last 30 days
gptbot
3
ahrefsbot
1
Resources
githubhttps://github.com/SGrondin/oracle-orm ↗
packageoracle-orm ↗
homepagehttps://github.com/SGrondin/oracle-orm ↗