The esqlite from mscdex

Installation fails. ( Error: Unable to detect compiler type )

Hello.
I am currently using Electron to develop a cross-platform desktop app.
Until recently, I really liked "better-sqlite3-multiple-ciphers", but it does not allow asynchronous processing, often blocking the renderer process when heavy queries are executed.
So I was searching and found this module.

I tried to install it immediately and ran the command, but the build doesn't seem to work.

What should I do?

npm ERR! code 1
npm ERR! path D:\develop\native-app\Electron\CleePIX\node_modules\esqlite
npm ERR! command failed
npm ERR! command C:\WINDOWS\system32\cmd.exe /d /s /c node buildcheck.js > buildcheck.gypi && node-gyp rebuild
npm ERR! D:\develop\native-app\Electron\CleePIX\node_modules\buildcheck\lib\index.js:133
npm ERR!         throw new Error('Unable to detect compiler type');
npm ERR!         ^
npm ERR!
npm ERR! Error: Unable to detect compiler type
npm ERR!     at new BuildEnvironment (D:\develop\native-app\Electron\CleePIX\node_modules\buildcheck\lib\index.js:133:15)
npm ERR!     at Object.<anonymous> (D:\develop\native-app\Electron\CleePIX\node_modules\esqlite\buildcheck.js:5:12)
npm ERR!     at Module._compile (node:internal/modules/cjs/loader:1254:14)
npm ERR!     at Module._extensions..js (node:internal/modules/cjs/loader:1308:10)
npm ERR!     at Module.load (node:internal/modules/cjs/loader:1117:32)
npm ERR!     at Module._load (node:internal/modules/cjs/loader:958:12)
npm ERR!     at Function.executeUserEntryPoint [as runMain] (node:internal/modules/run_main:81:12)
npm ERR!     at node:internal/main/run_main_module:23:47
npm ERR!
npm ERR! Node.js v18.15.0

development environment

OS：Windows 11 Pro
Node version : 18.15.0
Electron version: 23.1.3
esqlite version: latest

Thank you very much.

Registering Japanese characters in a database table column does not work.

The registration process itself can be performed, but when the string inserted into the record is checked, it is cut off in the middle and only part of the string is there, or blank characters are inserted. There are also garbled characters.
This is probably an internal character code processing problem.

db.query(`CREATE TABLE tags ( name TEXT NOT NULL )`);
db.query(`INSERT INTO tags( name ) VALUES( ? )`, ["あいうえお"]);
db.query(`INSERT INTO tags( name ) VALUES( ? )`, ["テスト"]);
db.query(`INSERT INTO tags( name ) VALUES( ? )`, ["text test"]);
db.query(`SELECT * FROM tags`, ( _, rows ) => { console.dir(rows, { deps: null }) });

output example

[
  { name: 'テ' },
  { name: 'あ�' },
  { name: 'text test' },
]

mscdex / esqlite Goto Github PK

esqlite's People

Contributors

Stargazers

Watchers

esqlite's Issues

Installation fails. ( Error: Unable to detect compiler type )

development environment

Registering Japanese characters in a database table column does not work.

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent