Async await sqlite in javascript

Question

I'm looking at this tutorial, which has a library called aa-sqlite in order to replace Promises() syntax with async-await.

I'm not seeing aa-sqlite on npm. Is there another, updated syntax for async await sqlite?

Here is what I'm trying with the standard sqlite library:

const sqlite3 = require('sqlite3').verbose();
let db = new sqlite3.Database("tmp.db")

async function myfunc(db) {
  let sql = "SELECT id id FROM TABLE LIMIT 2"
  let res1 = await db.run(sql)
  console.log(res1)
  for (row of res1) {
    console.log(row);   
  }

But this yields

TypeError: res1 is not iterable

I am not expecting res1 to be an object, but instead an iterator of results. How can I async/await the results of a db.run query in ES7/ES8?

@Mittenchops You cannot use for ..of with objects. See developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/… — achacttn
– achacttn, Commented May 14, 2019 at 4:11
I think your package - sqlite3 does not support promise or async/await syntax. In ES6, you can wrap callback based functions with Promise, which are essentially a return value with state (pending, resolved, rejected). — hoangdv
– hoangdv, Commented May 14, 2019 at 4:12

MetaZebre · Accepted Answer · 2020-06-18 16:56:18Z

I sort of tried sqlite npm package, which implements async/await over splite3, but it is not that easy to use.

A simple way is to create a little module and promessify the main sqlite3 functions.

Here is my simple module I created for a Discord chatbot database:

const sqlite3 = require('sqlite3');
const util    = require('util');

let db = new sqlite3.Database('./db/chatbot.sqlite3', sqlite3.OPEN_READWRITE, (err) => {
    if (err) {
        console.error(err.message);
    }
    console.log('Connected to the chatbot database.');
});

db.run = util.promisify(db.run);
db.get = util.promisify(db.get);
db.all = util.promisify(db.all);

// empty all data from db
db.clean_db = async function() {
  await db.run("delete from users");
  await db.run("delete from members");
  await db.run("delete from guilds");
  db.run("vacuum");
}

// any kind of other function ...

// and then export your module

module.exports = db;

How to use - now you can use the module like this in your code:

const db = require('./db');

// get one user
const myUser = await db.get("select * from users where id = ?", [id]);
if (! myUser)
    return console.log("User with id", id, "not found");

// get all users
const users = await db.all("select * from users");
users.map((user) => { console.log(user.id, "/", user.name); });

// ... etc ...

Guilherme Borges · Accepted Answer · 2020-11-08 03:31:19Z

6

For me the simplest solution would be to encapsulate the operation in a Promise like so:

const res = await new Promise((resolve, reject) => {
    db.each('SELECT id FROM table', [], (err, row) => {
        if (err)
            reject(err)

        resolve(row)
    })
})

console.log(res)

With this you'll have the row result in res outside the callback and synchronously.

answered Nov 8, 2020 at 3:31

Guilherme Borges

1652 silver badges8 bronze badges

Comments

Mittenchops · Accepted Answer · 2019-05-27 02:42:45Z

3

Try the sqlite package, rather than the sqlite3 used in the demo. It has better support for async await.

answered May 27, 2019 at 2:42

Mittenchops

20k39 gold badges149 silver badges258 bronze badges

Comments

MetaZebre · Accepted Answer · 2020-06-16 16:22:24Z

1

You are note seeing the aa-sqlite package because it's not a npm package.

The guy who wrote the tutorial you are refering simply put how he created this small aa-sqlite package, and it's all written inside the tuto, but it has not been published on npm.

answered Jun 16, 2020 at 16:22

MetaZebre

94910 silver badges12 bronze badges

Collectives™ on Stack Overflow

Async await sqlite in javascript

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related