Unable to install sqlite3 about node-sqlite3

[xieerduos]

I also encountered the same problem. Do you know how to solve it? thanks

#1746 I feel that the problem is the same as the problem I raised, and this solution proposed by this friend or manually downloaded to the local can be temporarily solved @laozl

I've conducted tests and discovered that the issue began with version 5.1.7 of sqlite3. To temporarily resolve this, you can specify version 5.1.6 in your package.json file. Simply add or modify the sqlite3 dependency in the following manner:

"dependencies": {
    "sqlite3": "5.1.6"
}

This should bypass the issue until a permanent fix is implemented.

[andyImatest]

I'm having the same issue with v5.1.7:

prebuild-install info looking for local prebuild @ prebuilds\sqlite3-v5.1.7-napi-v36-win32-x64.tar.gz

which should be looking for sqlite3-v5.1.7-napi-v6-win32-x64.tar.gz

Will pin to version v5.1.6 for now, but would love to make use of the improved bundling!

[laozl]

But I'm going to modify the ` node_ In modules/sqlite3/package. json ',' binary ': {' napi_versions': [3,6]} 'is' binary': {'napi_versions': [6]}', which can be processed

[xieerduos]

I also encountered the same problem. Do you know how to solve it? thanks

[qyn980427]

I also encountered the same problem. Do you know how to solve it? thanks

#1746 I feel that the problem is the same as the problem I raised, and this solution proposed by this friend or manually downloaded to the local can be temporarily solved @laozl

[laozl]

I also encountered the same problem. Do you know how to solve it? thanks

#1746 I feel that the problem is the same as the problem I raised, and this solution proposed by this friend or manually downloaded to the local can be temporarily solved @laozl

I've conducted tests and discovered that the issue began with version 5.1.7 of sqlite3. To temporarily resolve this, you can specify version 5.1.6 in your package.json file. Simply add or modify the sqlite3 dependency in the following manner:

"dependencies": {
    "sqlite3": "5.1.6"
}

This should bypass the issue until a permanent fix is implemented.

Thank you very much. Your plan has solved the troubles that have troubled me for a few days at once

[milux]

+1

[faribauc]

+1 with sqlite3 5.1.7

Confirmed it works when locking 5.1.6

[webdevepru]

it doesn't work for me since
"sqlite3": "5.1.6",
"electron": "^28.2.1",
"electron-builder": "^24.13.3",

[jesusrogliero]

"sqlite3": "5.1.6"

It worked for me, thank you very much.
Funciono para mi, Muchas gracias

"devDependencies": {
	"electron": "^13.4.0",
	"electron-builder": "^22.13.1",
	"eslint": "^7.32.0",
	"eslint-plugin-react": "^7.26.0"
},
"dependencies": {
	"@navpreetdevpuri/html-pdf": "^3.0.9",
	"appdata-path": "^1.0.0",
	"bcrypt": "5.1.0",
	"bcv-divisas": "^1.2.6",
	"electron-log": "^4.4.1",
	"electron-updater": "^6.1.1",
	"googleapis": "^123.0.0",
	"handlebars": "^4.7.8",
	"moment": "^2.29.4",
	"nodemailer": "^6.9.3",
	"sequelize": "^6.6.5",
	"sqlite3": "5.1.6"
}

[pranavwani]

This worked:

export LDFLAGS="-L`brew --prefix`/opt/sqlcipher/lib"
export CPPFLAGS="-I`brew --prefix`/opt/sqlcipher/include/sqlcipher"
npm install [email protected] --build-from-source --sqlite_libname=sqlcipher --sqlite=`brew --prefix` --runtime=electron --target=27.3.9 --dist-url=https://electronjs.org/headers

node -e 'require("sqlite3")'

Thanks @xieerduos