Windows require error - stdout stderr not work on Win32

[ang3lx]

hello,
i'm using sql.js with electron. I've packaged app for OSX and Windows
OSX all works fine, but in windows
require('sql.js');
generate error
Uncaught Error: EPERM: operation not permitted, write

how can solve this problem?

[lovasoa]

There is not enough precision here for the problem to be solved. But if you are building a desktop application, you'd better use a compiled version of sqlite. It will be much faster and there are very good packages on npm to do just that.

[ang3lx]

i've resolved with 'remote' module
var remote = require('remote');
var SQL = remote.require('sql.js');

[ang3lx]

remote module has other problems, but i've find another possible solution.
i've used sql-debug.js instead if sql.js and i've commented out these lines and app works fine:

if (ENVIRONMENT_IS_WEB && preloadStartTime !== null) {
  Module.printErr('pre-main prep time: ' + (Date.now() - preloadStartTime) + ' ms');
}

when the application is executed on windows by double-clicking on the .exe file (compiled version) the error is triggered because of the line written in the console, which is not present on Windows unless the application is launched using the command prompt

[henrythasler]

This also happens in a nwjs-Environment on Win. The problem here is that ENVIRONMENT_IS_WEB is also true in a nwjs-Environment.

A as workaround I suggest to modify the sql-debug as follows:

Line 35: //var ENVIRONMENT_IS_NODE = typeof process === 'object' && typeof require === 'function';
Line 36: var ENVIRONMENT_IS_NODE = undefined;

basically disabling node functionality.

As a permanent solution I propose to set these Environment-Variables within a if-else-Statement to prevent more than one to be set to TRUE.