node.js + sequelize + sqlite

index.js

'use strict';

var Sequelize = require('sequelize');

var sequelize = new Sequelize('mainDB', null, null, {
    dialect: "sqlite",
    storage: './test.sqlite',
});

sequelize
  .authenticate()
  .then(function(err) {
    console.log('Connection has been established successfully.');
  }, function (err) {
    console.log('Unable to connect to the database:', err);
  });


//  MODELS
var User = sequelize.define('User', {
  username: Sequelize.STRING,
  password: Sequelize.STRING
});


//  SYNC SCHEMA
sequelize
  .sync({ force: true })
  .then(function(err) {
    console.log('It worked!');
  }, function (err) {
    console.log('An error occurred while creating the table:', err);
  });

package.json

{
  "main": "index.js",
  "dependencies": {
    "sequelize": "^3.4.1",
    "sqlite3": "^3.0.9"
  }
}

in windows 10, copy all to one folder, install nodejs, in terminal cmd, type
npm update ... wait to finish installation, this may delay 5 minutes
node index.js

output:

Executing (default): SELECT 1+1 AS result
Connection has been established successfully.
It worked!

@Moriame 3 years still useful. I would love to know the journey after this...

Honestly i can't believe am already falling in love with sequelize