node package manager

sails-mssql

MSSQL Adapter for Sails.js

image_squidhome@2x.png

sails-mssql NPM version

Microsoft SQL Server Adapter for Sails.js

Compatibility

  • SQL Server 2005 and later (tested with SQL Server 2005 and SQL Server 2008)
  • Sails.js 0.9.x
  • Windows/OSX/Linux

Installation

npm install sails-mssql

Configuration

Basic Options

adapters: {
  'default': 'mssql',
  mssql: {
    module: 'sails-mssql',
    user: 'sample',
    password: 'secret', 
    database: 'sailsdb'
  }
}

Advanced Options

adapters: {
  'default': 'mssql',
  mssql: {
    module: 'sails-mssql',
    host: 'localhost',
    port: 1433,
    user: 'sample',
    password: 'secret', 
    database: 'sailsdb',
    timeout: 5000,
    pool: {
      min: 0,
      max: 10,
      idleTimeout: 30000
    }
  }
}

License

MIT License Copyright © 2013-2014 Sergei Belov