sails.config.connections
What is this?
Adapters are the middle man between your Sails app and some kind of storage (typically a database)
Global connections are configured in the connections.js file located in your project's config directory. You can also specify connections in your config/local.js or environment-specific config files.
Sails adapters have been written for a variety of popular databases such as MySQL, Postgres and Mongo. You can find a list of supported adapters here.
Example
To use the sails-memory adapter (useful for DEVELOPMENT ONLY), first install the module with npm install sails-memory, then define it in connections.js:
Here is an example adapter configuration file
myApp/config/connections.js
module.exports.connections = {
// sails-disk is installed by default.
localDiskDb: {
adapter: 'sails-disk'
},
memory: {
adapter: 'sails-memory'
}
};
If you wanted to set memory as the default adapter for your models, you would do this.
myApp/config/models.js
module.exports.models = {
connection: 'memory'
};
Keep in mind that options you define directly in your model definitions will override these settings. Prior to v0.10, adapters were defined in
myApp/config/Adapters.js. See v0.9 docs for more info.
Multiple connections for an adapter
You can set up more than one connection using the same adapter. For example, if you had two mysql databases, you could configure them as:
module.exports.connections = {
localMysql: {
adapter: 'sails-mysql',
user: 'root',
host: 'localhost',
database: 'someDbase'
},
remoteMysql: {
adapter: 'sails-mysql',
user: 'remoteUser',
password: 'remotePassword',
host: 'http://remote-mysql-host.com',
database: 'remoteDbase'
}
};
Note If any connection to an adapter is used by a model, then all connections to that adapter will be loaded on
sails.lift, whether or not models are actually using them. In the example above, if a model was configured to use thelocalMysqlconnection, then bothlocalMysqlandremoteMysqlwould attempt to connect at run time. It is therefore good practice to split your connection configurations up by environment and save them to the appropriate environment-specific config files, or else comment out any connections that you don't want active.
For a better experience on sailsjs.com, update your browser.
Reference
- Application
- Blueprint API
- Command Line Interface
-
Configuration
- sails.config.*
- sails.config.blueprints
- sails.config.bootstrap()
- sails.config.connections
- sails.config.cors
- sails.config.csrf
- sails.config.globals
- sails.config.http
- sails.config.i18n
- sails.config.log
- sails.config.models
- sails.config.policies
- sails.config.routes
- sails.config.session
- sails.config.sockets
- sails.config.views
-
Request (`req`)
- req.accepted
- req.acceptedCharsets
- req.acceptedLanguages
- req.body
- req.cookies
- req.fresh
- req.headers
- req.host
- req.ip
- req.ips
- req.isSocket
- req.method
- req.options
- req.originalUrl
- req.params
- req.path
- req.protocol
- req.query
- req.secure
- req.signedCookies
- req.socket
- req.subdomains
- req.url
- req.wantsJSON
- req.xhr
- req.accepts()
- req.acceptsCharset()
- req.acceptsLanguage()
- req.allParams()
- req.file()
- req.get()
- req.is()
- req.param()
- Response (`res`)
- Waterline (ORM)
- WebSockets
Built with Love
The Sails framework is maintained by a web & mobile studio in Austin, TX, with the help of our contributors. We created Sails in 2012 to assist us on Node.js projects. Naturally we open-sourced it. We hope it makes your life a little bit easier!
© 2012-2018 The Sails Company.
The Sails framework is free and open-source under the MIT License.