Official Oracle driver for Node.JS

Currently at v0.2. node-oracledb makes use of C API for performance which makes it more like a “thick client”. That mean you are required to install Oracle’s client lbiraries1. Though versioned as 0.2, node-oracledb already supports a lot of features such as connection pooling, statement caching, client-result caching, etc… node-oracledb is not yet available through npm. You will have to clone and run npm install manually by yourself. Windows support is still pretty rough but I don’t actually care much.
Read more →

Returning query result as json array with Oracle 10G

How to turn ref cursor into json object in Oracle 10G. An equivalent version of row_to_json of Postgres in Oracle 10G.
Read more →