Asynchronous HTTP-requests on sqlite database in Node.js

Question

I'm currently trying to to test a little server with multiple asynchronous HTTP-requests, however my sqlite3 database seems to block simultaneous queries issuing SQLITE_BUSY.

db.exec(query, (err) => {
    if (err !== null) {
        callback('Insertion failed.');
    } else {
        callback(null);
});

Is there a way to circumvent this problem using the sqlite3 module?

Thanks in advance.

This seems to be a similar question: stackoverflow.com/questions/964207/sqlite-exception-sqlite-busy — Peter
– Peter, Commented Oct 12, 2016 at 17:57

user7009026 · Accepted Answer · 2016-10-12 19:29:25Z

1

Could you just use async.queue?

var async = require('async');

var q = async.queue(function(task, callback) {
    db.exec(task.query, function(err) {
        callback('Insertion failed.');
    });
    callback();
}, 1);

q.drain = function() {
    console.log('queue is empty, ready for more query');
};

q.push({query: "Your SQL INSERT query"}, function(err) {
    console.error(err);
});

answered Oct 12, 2016 at 19:29

user7009026

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Asynchronous HTTP-requests on sqlite database in Node.js

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related