Whenever I use sqlite in Node I always come across the issue where the database hasn't been created properly. This is the code I've been using to ensure it does.

const dbpath = 'database.db'
const dbPromise = Promise.resolve()
 .then(() => new Promise(function (resolve, reject) {
 // Make sure database exists before trying to open it
 fs.writeFile(dbpath, '', { flag: 'a+' }, function (err) {
 if (err) reject(err)
 else resolve()
 })
 }))
 .then(() => sqlite.open(dbpath, { Promise }))
 .then(db => db.migrate({ migrationsPath: 'migrations/' }))