Example using multiple databases. about node-sqlite

[koistya]

@tracker1 good question! Here is an example how to work with multiple databases:

import sqlite from 'sqlite';
import Promise from 'bluebird';

Promise.resolve()
  .then(() => Promise.all([
    sqlite.open('./core.sqlite', { Promise }),
    sqlite.open('./data.sqlite', { Promise })
  ])
  .then(([coreDb, dataDb]) => {
    coreDb.get('SELECT * FROM Table WHERE id = ?', 123).then(row => console.log(row));
  });

or, with async/await syntax:

import sqlite from 'sqlite';
impot Promise from 'bluebird';

async function foo() {
  const [coreDb, dataDb] = await Promise.all([
    sqlite.open('./core.sqlite', { Promise }),
    sqlite.open('./data.sqlite', { Promise })
  ]);

  const row = await coreDb.get('SELECT * FROM Table WHERE id = ?', 123);
}

foo();

I guess it would be good to include that info into README.md. A pull request is more than welcome!

[adek05]

How to run two different migrations against different tables open?

[theogravity]

I've documented this in the v4 beta readme, thanks all