Example of Sequelize with sql.js

example.js

var lib = require('./patch.js');
var Sequelize = require('sequelize');

var sequelize = new Sequelize('sqlite://dbname', {dialectModulePath: 'sql.js'});

var User = sequelize.define('user', {
  username: Sequelize.STRING,
  birthday: Sequelize.DATE
});

sequelize.sync().then(function() {
  return User.create({
    username: 'janedoe',
    birthday: new Date(1980, 6, 20)
  });
}).then(function(jane) {
  console.log(jane.get({
    plain: true
  }));
});

patch.js

"use strict";

var lib = require('sql.js');
    lib.verbose = function() {
        return lib;
    }

    lib._Database = lib.Database;
    lib.Database = class Db extends lib._Database {
        constructor(filename, mode, cb) {
            super();
            process.nextTick(cb, null);
        }

        //I'm not 100% sure what this was supposed to do on node-sqlite3, heh.
        serialize(cb) {
            process.nextTick(cb);
        }

        run(sql, params, cb) {
            super.run(sql, params);
            var ctx = {};
            if (sql.toLowerCase().indexOf('insert') !== -1) {
                var rez = this.exec("select last_insert_rowid();");
                ctx.lastID = rez[0].values[0][0];
            }
            if (cb) {
                process.nextTick(cb.bind(ctx), null);
            }
            return this;
        }

        all(sql, params, cb) {
            var result = [];
            this.each(sql, params,
            function(r) {
                result.push(r);
            },
            function() {
                cb(null, result);
            });
            return this;
        }

        close () {

        }
    }

module.export = lib;

Code copied from:

https://github.com/kripken/sql.js/issues/91#issuecomment-169655900

You can try this too. https://gist.github.com/oney/904c4a1533174a9514305088b790f71f

Thanks for copying. That issue is now missing. xD

Thanks for the post. This helped with getting lastID

Hi. I've made an npm package that could be used to make sql.js work with Sequelize without any patching (based on the gist code). In case anyone's interested:
https://www.npmjs.com/package/sql.js-as-sqlite3

Usage:

import Sequelize from 'sequelize'
import sqlJsAsSqlite3 from 'sql.js-as-sqlite3'

const sequelize = new Sequelize('sqlite://:memory:', {
  dialectModule: sqlJsAsSqlite3
})

Nice @catamphetamine