Failed to execute SQL with error: TypeError: The database connection is not open about better-sqlite3 HOT 2 CLOSED

The error is precisely correct. You're closing the db immediately after scheduling the fs.readFile.

If you want to close the db, you need to do it in your callback, after you run your db.exec().

It might help to go through a tutorial or two on how node schedules callbacks--as this shows, it can be decidedly confusing!

from better-sqlite3.

Thanks! It's my bad! it now works well after calling db.close() in the try-finally block.
Before starting with better-sqlite3, I've investigated a lot and read diff between node-sqlite3 and the better-sqlite3, in brief async against sync. While trying better-sqlite3, my head is full of sync and have forgotten the async fs.readFile() :)

from better-sqlite3.