Is there a way to perform a synchronous all()?

[gabrielfgularte]

Is it possible to wait until the query is finished? I have something like:

function query(fields, table) {
  db.on('open', () => {
    return db.prepare(`SELECT ${fields} FROM ${table}`).all()
  })
}

let rows = query('*', 'user')
console.log(rows) // is returning undefined. I need this to wait until all() is finished.

thanks!

[JoshuaWise]

The database opens asynchronously, but after the database is opened, all queries are done synchronously.

db.on('open', () => {
  function query(fields, table) {
    return db.prepare(`SELECT ${fields} FROM ${table}`).all()
  }
  let rows = query('*', 'user')
  console.log(rows)
})

[JoshuaWise]

Version 2 has been released! If you update better-sqlite3 to version 2, you'll be able to do this synchronously:

var Database = require('better-sqlite3')
var db = new Database('foobar.db', options)

function query(fields, table) {
  return db.prepare(`SELECT ${fields} FROM ${table}`).all()
}

let rows = query('*', 'user')
console.log(rows)