node-red-contrib-oracledb-mod 1.0.0

v1.0.0 - Production Milestone: Dual Outputs, Sequential Queries, Vectors, Transactions & Schema Explorer

on Node.js NPM

Highlights

🚀 Production Milestone 1.0.0

This release marks the general availability (1.0.0) milestone of node-red-contrib-oracledb-mod, establishing the benchmark for modern Oracle Database and Autonomous Database integration in Node-RED.

• Optional Dual Output Ports (splitoutputs): Route successful query results to Port 1 and error messages directly to Port 2 without requiring a separate Catch node.
• Sequential Multi-Statement Queries: Pass an array of SQL statements in msg.query to execute multiple queries sequentially within a single round-trip.
• Real-Time SQL Bind Auto-Detection: Editor automatically scans and displays detected :param names live as you type.
• Multi-Node Transaction Management: Atomic multi-node transaction lifecycle (Begin, Continue, Commit, Rollback) with automatic 60-second safety rollback timer.
• Oracle 23ai / 26ai Native Vector Search: Automatic native binding of JavaScript Float32Array / Float64Array as oracledb.DB_TYPE_VECTOR for AI similarity queries (VECTOR_DISTANCE).
• Interactive Database, Schema & Field Explorer: Full database hierarchy browser (Database → Schema → Object Type → Table/View → Columns) with smart SELECT *, SELECT cols, and INSERT template SQL generation (excluding internal system SYS_NC$ and sequence identity columns).
• TypeScript 7 Native Port & ESLint 10 Flat Config: Blazing-fast native build pipeline (>80% faster) and zero package security vulnerabilities.
• Automated Test Suite: 39 tests passing across Node 20 and Node 22 (19 unit + 20 live Autonomous Database mTLS thin mode tests).