I trying to fetch some records from Sqlite db using Node JS.

我尝试使用Node JS从Sqlite db获取一些记录。

var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database('chat.db');

db.serialize(function(){
    db.each("SELECT * FROM chats", function (err, row) {
        io.emit('chats',row);
    });
});

But this iterates the result set and send one at a time.How can I get the entire result set (without using another array) so that I can loop it somewhere else?

但是这会迭代结果集并一次发送一个。如何获得整个结果集(不使用其他数组)以便我可以将其循环到其他地方?

1 个解决方案