Error: SQLITE_BUSY: unable to close due to unfinalised statements about node-sqlite3

[kkaefer]

Can you please post the test files? Without these, it's pretty hard to determine why this error occurs. My guess is that one of the statements in your code isn't finalized. When you create statements with Database#prepare(), you have to call .finalize() on them; otherwise, sqlite will keep them around infinitely and won't allow closing the database.

[markc]

Yes, of course, sorry. It was just the example at the top of README.md but with :memory: changed to an on disk file so I could check the results against my /usr/bin/sqlite3 v3.7.5.

var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database('./test.sqlite');

db.serialize(function() {
  db.run("CREATE TABLE lorem (info TEXT)");

  var stmt = db.prepare("INSERT INTO lorem VALUES (?)");
  for (var i = 0; i < 10; i++) {
      stmt.run("Ipsum " + i);
  }

  db.each("SELECT rowid AS id, info FROM lorem", function(err, row) {
      console.log(row.id + ": " + row.info);
  });
});

db.close();

[kkaefer]

Thank you, I fixed the error in the readme