Use sqlite3 in web worker doesn't work about node-webworker-threads HOT 3 CLOSED

Hi, currently we do not support require() in threads, there is only importScripts, which only supports pure-JavaScript modules (via browserify, webpack, onejs etc), and it cannot write to the filesystem.

Perhaps you could move the SQLite-access functions to the main thread, and postMessage from within the worker to access it?

from node-webworker-threads.

so you mean pass this: var db, to the worker?

from node-webworker-threads.

I mean something like:

var Worker = require('webworker-threads').Worker;
var sqlite3 = require('sqlite3').verbose();
var worker = new Worker(function(){
  this.postMessage(...) // query to db
  this.onmessage = function(event) {
      // ...handler result from SQLite3...
  };
});

var db = new sqlite3.Database('MyDB.db');
worker.onmessage = function (event) {
   // ... do something with db ...
}

Basically doing all DB filesystem operations in the main threads, and have the worker do CPU-intensive work. Something like https://github.com/mozilla/jschannel might be useful to make postMessage easier to reason with.

from node-webworker-threads.