Sequelize

Sequelize is a promise-based Node.js/io.js ORM for Postgres, MySQL, MariaDB, SQLite and Microsoft SQL Server. It features solid transaction support, relations, read replication and more.

Documentation

Installation

npm install sequelize

From 3.0.0 and up Sequelize will follow SEMVER.

Backwards compatibility changes

3.0.0 cleans up a lot of deprecated code, making it easier for us to develop and maintain features in the future. This implies that most of the changes in 3.0.0 are breaking changes! Please read the changelog for 3.0.0 carefully. Upgrading to 3.0. We highly recommend to use 3.0 as it also includes security related fixes that can't be backported to either 2.0 or 1.7.

If you still use 1.7 please read our guide Upgrading to 2.0 plus the changelog up to now. Version 2.1 also contained new breaking changes.

Features

• Schema definition
• Schema synchronization/dropping
• 1:1, 1:M & N:M Associations
• Through models
• Promises
• Hooks/callbacks/lifecycle events
• Prefetching/association including
• Transactions
• Migrations
• CLI (sequelize-cli)

Resources

• Changelog
• Getting Started
• Documentation
• API Reference
• Collaboration and pull requests
• Roadmap
• Twitter: @SequelizeJS
• IRC: sequelizejs on Freenode
• Google Groups
• Add-ons & Plugins