A Waterline adapter for Oracle Database that uses the Official Node Oracle Driver mantained by Oracle Corp. May be used in a Sails app or anything using Waterline for the ORM.

The Adapter is not finished yet. It has few functionalities pending for fixes, but you can use it. It works on both Windows and Linux systems.

Things that you can do NOW:

• Connect to an Oracle database. (05/Aug/2015)
• Do find request. (05/Aug/2015)
• Populate find request (Joins). (07/Aug/2015)
• Create, modify and delete automatically DB tables (Alter mode). (07/Aug/2015)
• Insert request. (11/Aug/2015)
• Update request. (22/Aug/2015)
• Delete request. (22/Aug/2015)
• Use multiple Oracle connections on Sails App. (22/Aug/2015)

Pending fixes:

• On alter mode, create automatically triggers and sequences for autoincrementable attributes. Now you must create them manually.
• The PK column must be id.
• Now in updates you must use id on where clause.
• Count request.
• On alter mode, allow the automatic addition and deletion of table columns individually.
• On alter mode, implement createEach method.
• On insert autoincrementable attribute value, set its sequence if necessary.

From now you can work with this adapter using funcionalities as described.

We hope we can improve adapter actions as soon as posible.

As oracledb driver module is a dependency you must read How to Install it.

Install is through NPM.

$ npm install sails-oradb

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

config: {
    adapter: 'sails-oradb',
    connectString: 'host:port/databaseName',
    user: 'root',
    password: ''
};

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.