Sequelize

The Sequelize library provides easy access to MySQL, MariaDB, SQLite or PostgreSQL databases by mapping database entries to objects and vice versa. To put it in a nutshell, it's an ORM (Object-Relational-Mapper). The library is written entirely in JavaScript and can be used in the Node.JS environment.

Getting started Use with Express Use on Heroku API Reference Fork on Github

Easy installation

$ npm install sequelize
$ npm install mysql

Simple usage

var Sequelize = require('sequelize')
  , sequelize = new Sequelize('database', 'username', 'password')
 
var User = sequelize.define('User', {
  username: Sequelize.STRING,
  birthday: Sequelize.DATE
})
 
sequelize.sync().success(function() {
  User.create({
    username: 'sdepold',
    birthday: new Date(1986, 06, 28)
  }).success(function(sdepold) {
    console.log(sdepold.values)
  })
})

Trusted and used by

Imprint