A Waterline adapter for Oracle Database that uses the Official Node Oracle Driver (v1.3.0) mantained by Oracle Corp. It may be used in Sails web applications or any another Node.js project using Waterline as ORM.

oracledb driver module is the main dependency of sails-oracle-database, so before installing it, you MUST read How to Install oracledb.

Installation is performed via NPM as follows:

$ npm install sails-oracle-database

The following configuration options are available along with their default values:

config: {
    adapter: 'sails-oracle-database',
    connectString: 'host:port/databaseName',
    logQueries:true,
    debug:true,
    user: 'user',
    password: 'password',
    skipDescribe:true,
    prefetchRows:10000,
    poolMax: 50,
    poolMin: 0,
    poolIncrement: 1, //only grow the pool by one connection at a time
    poolTimeout: 0 //never terminate idle connections (seconds)
};

Waterline is a new kind of storage and retrieval engine. It provides a uniform API for accessing stuff from different kinds of databases, protocols, and 3rd party APIs. That means you write the same code to get users, whether they live in mySQL, LDAP, MongoDB, or Facebook.

To learn more visit the project on GitHub at Waterline.