@vijaykonnackal/sails-mssql
a MsSql adapter for Waterline and Sails.js
Last updated 7 months ago by vijaykonnackal .
MIT · Repository · Bugs · Original npm · Tarball · package.json
$ cnpm install @vijaykonnackal/sails-mssql 
SYNC missed versions from official npm registry.

Sails MsSql

A Waterline adapter for working with the Microsoft SqlServer database.

This version works with Sails 1.x. All Waterline Adapter Interfaces and methods are implemented based on the postgres implementation.

This is largely a port of sails-postgresql

Install

$ npm install @vijaykonnackal/sails-mssql

Usage

An example configuration below.

Check MsSql Driver Options and Tarn Pool Options for more details. The options are passed verbatim to downstream driver.

module.exports.datastores = {
    default: {
        adapter: '@vijaykonnackal/sails-mssql',
        host: process.env.DB_HOST,
        port: process.env.DB_PORT,
        user: process.env.DB_USER,
        password: process.env.DB_PASS,
        database: process.env.DB_NAME,
        schemaName: 'dbo',  //note: schema specified in model takes precedence
        requestTimeout: 15000,
        options: {
            encrypt: false,
            appName: 'myapp'
        },
        pool: {
            max: 25,
            min: 5,
            idleTimeoutMillis: 30000
        } 
    }
};

Help

If you have further questions or are having trouble, click here.

License

The Sails framework is free and open-source under the MIT License.

Current Tags

  • 1.1.2                                ...           latest (7 months ago)

2 Versions

  • 1.1.2                                ...           7 months ago
  • 1.1.1                                ...           7 months ago
Maintainers (1)
Downloads
Today 0
This Week 0
This Month 0
Last Day 0
Last Week 0
Last Month 0
Dependencies (6)
Dev Dependencies (5)
Dependents (0)
None

Copyright 2014 - 2017 © taobao.org |