Waterline is a next-generation storage and retrieval engine, and the default ORM used in the Sails framework.
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 and store things like users, whether they live in Redis, MySQL, MongoDB, or Postgres.
Waterline strives to inherit the best parts of ORMs like ActiveRecord, Hibernate, and Mongoose, but with a fresh perspective and emphasis on modularity, testability, and consistency across adapters.
Looking for the version of Waterline used in Sails v0.12? See the 0.11.x branch of this repo. If you're upgrading to v0.13 from a previous release of Waterline standalone, take a look at the upgrading guide.
Install from NPM.
$ npm install waterline --saveWaterline uses the concept of an adapter to translate a predefined set of methods into a query that can be understood by your data store. Adapters allow you to use various datastores such as MySQL, PostgreSQL, MongoDB, Redis, etc. and have a clear API for working with your model data.
Waterline supports a wide variety of adapters, both core and community maintained.
The up-to-date documentation for Waterline is maintained on the Sails framework website. You can find detailed API reference docs under Reference > Waterline ORM. For conceptual info (including Waterline standalone usage), and answers to common questions, see Concepts > Models & ORM.
Check out the recommended community support options for tutorials and other resources. If you have a specific question, or just need to clarify how something works, ask for help or reach out to the core team directly.
You can keep up to date with security patches, the Waterline release schedule, new database adapters, and events in your area by following us (@sailsjs) on Twitter.
To report a bug, click here.
Please observe the guidelines and conventions laid out in our contribution guide when opening issues or submitting pull requests.
All tests are written with mocha and should be run with npm:
$ npm testMIT. Copyright © 2012-2017 Mike McNeil, Balderdash Design Co., & The Sails Company
Waterline, like the rest of the Sails framework, is free and open-source under the MIT License.
Below, you'll find a handful of experimental features that you might enjoy.
Please be aware that these are in the early stages and should not be relied upon as production features of Waterline. They could change at any time-- even on a patch release! You have been warned!
var Waterline = require('waterline');Waterline.start(opts, function(err, orm) { /*...*/ })Waterline.stop(orm, function(err) { /*...*/ })Waterline.getModel(modelIdentity, orm)
For detailed usage, see the source code (bottom of
lib/waterline.jsin this repo.)