Migrating from 1.x to 2.x

2.x using Sequelize ORM to supports MySQL, MariaDB, SQLite or PostgreSQL databases.

config.js changes in 2.x

New database config

  /**
   * database config
   */

  database: {
    // sync database before app start, defaul is false
    syncFirst: false,

    db: 'cnpmjs_test',
    username: 'root',
    password: '',

    // the sql dialect of the database
    // - currently supported: 'mysql', 'sqlite', 'postgres', 'mariadb'
    dialect: 'sqlite',

    // custom host; default: 127.0.0.1
    host: '127.0.0.1',

    // custom port; default: 3306
    port: 3306,

    // you can also pass any dialect options to the underlying dialect library
    // - default is empty
    // - currently supported: 'mysql', 'mariadb'
    dialectOptions: {
      multipleStatements: true,
    //   supportBigNumbers: true,
    //   bigNumberStrings: true
    },

    // use pooling in order to reduce db connection overload and to increase speed
    // currently only for mysql and postgresql (since v1.5.0)
    pool: {
      maxConnections: 10,
      minConnections: 0,
      maxIdleTime: 30000
    },

    // the storage engine for 'sqlite'
    // default store into ~/cnpmjs.org.sqlite
    storage: path.join(process.env.HOME || root, 'cnpmjs.org.sqlite'),

    logging: !!process.env.SQL_DEBUG,
  },

If you're still using MySQL and old config.js mysqlServers: [] from 1.x:

  mysqlServers: [
    {
      host: '127.0.0.1',
      port: 3306,
      user: 'root',
      password: ''
    }
  ],
  mysqlDatabase: 'cnpmjs_test',
  mysqlMaxConnections: 4,
  mysqlQueryTimeout: 5000,

We will do forward compat, and auto change old style config.js to:

  database: {
    syncFirst: false,
    db: 'cnpmjs_test',
    username: 'root',
    password: '',
    dialect: 'mysql',
    host: '127.0.0.1',
    port: 3306,
    pool: {
      maxConnections: 10,
      minConnections: 0,
      maxIdleTime: 30000
    },
    logging: !!process.env.SQL_DEBUG,
  },