Duckdb can't rebuild in electron project on Windows

[stefenson]

I'm trying to integrate duckdb into my electron project, but the rebuild process always goes wrong, however on my WSL, it doesn't have any problem.

The environment of my PC is:

OS: Win10 22H2
Nodejs: v20.12.0
Python: 3.12.7
Duckdb: v1.1.1
Electron: 32.0.1
Electron-forge/cli: 7.5.0
Visual Studio Version: 2022 Community
MSBuild Version: 17.11.35327.3
Win10 SDK: 22621
VC++ ATL lib version: v143

And this is the error I got:

/node-addon-api /I../src/duckdb/src/include /I../src/duckdb/third_party/concurrentqueue /I../src/duckdb/third_party/fast_float /I../src/duckdb/third_party/fastpforlib /I../src/duckdb/third_party/fmt/include
/I../src/duckdb/third_party/fsst /I../src/duckdb/third_party/httplib /I../src/duckdb/third_party/hyperloglog /I../src/duckdb/third_party/jaro_winkler /I../src/duckdb/third_party/jaro_winkler/details
/I../src/duckdb/third_party/libpg_query /I../src/duckdb/third_party/libpg_query/include /I../src/duckdb/third_party/lz4 /I../src/duckdb/third_party/brotli/include /I../src/duckdb/third_party/brotli/common
/I../src/duckdb/third_party/brotli/dec /I../src/duckdb/third_party/brotli/enc /I../src/duckdb/third_party/mbedtls /I../src/duckdb/third_party/mbedtls/include /I../src/duckdb/third_party/mbedtls/library
/I../src/duckdb/third_party/miniz /I../src/duckdb/third_party/pcg /I../src/duckdb/third_party/re2 /I../src/duckdb/third_party/skiplist /I../src/duckdb/third_party/tdigest /I../src/duckdb/third_party/utf8proc
/I../src/duckdb/third_party/utf8proc/include /I../src/duckdb/third_party/yyjson/include /I../src/duckdb/extension/parquet/include /I../src/duckdb/third_party/parquet /I../src/duckdb/third_party/thrift
/I../src/duckdb/third_party/snappy /I../src/duckdb/third_party/zstd/include /I../src/duckdb/extension/icu/include /I../src/duckdb/extension/icu/third_party/icu/common
/I../src/duckdb/extension/icu/third_party/icu/i18n /I../src/duckdb/extension/json/include /Z7 /nologo /W3 /WX- /diagnostics:column /MP /Ox /Ob2 /Oi /Ot /Oy /GL /D NODE_GYP_MODULE_NAME=duckdb /D
USING_UV_SHARED=1 /D USING_V8_SHARED=1 /D V8_DEPRECATION_WARNINGS=1 /D _GLIBCXX_USE_CXX11_ABI=1 /D ELECTRON_ENSURE_CONFIG_GYPI /D USING_ELECTRON_CONFIG_GYPI /D V8_COMPRESS_POINTERS /D
V8_COMPRESS_POINTERS_IN_ISOLATE_CAGE /D V8_31BIT_SMIS_ON_64BIT_ARCH /D V8_ENABLE_SANDBOX /D WIN32 /D _CRT_SECURE_NO_DEPRECATE /D _CRT_NONSTDC_NO_DEPRECATE /D _HAS_EXCEPTIONS=0 /D OPENSSL_NO_PINSHARED /D
OPENSSL_THREADS /D OPENSSL_NO_ASM /D NAPI_VERSION=6 /D DUCKDB_EXTENSION_PARQUET_LINKED /D DUCKDB_EXTENSION_ICU_LINKED /D DUCKDB_EXTENSION_JSON_LINKED /D DUCKDB_EXTENSION_AUTOLOAD_DEFAULT=1 /D
DUCKDB_EXTENSION_AUTOINSTALL_DEFAULT=1 /D NDEBUG /D DUCKDB_BUILD_LIBRARY /D BUILDING_NODE_EXTENSION /D HOST_BINARY="node.exe" /D _WINDLL /GF /Gm- /EHsc /MT /GS /Gy /fp:precise /Zc:wchar_t /Zc:forScope
/Zc:inline /GR- /FoRelease/obj/duckdb//src/duckdb_node.obj /FdRelease/obj/duckdb/vc143.pdb /external:W3 /Gd /TP /wd4351 /wd4355 /wd4800 /wd4251 /wd4275 /wd4244 /wd4267 /FC /errorReport:queue /Zc:__cplusplus
-std:c++17 /bigobj /GR ../src/duckdb_node.cpp(1,1): 

error C1083: Cannot open include file:  <---

“..\node-addon-api /I..\src\duckdb\src\include /I..\src\duckdb\third_party\concurrentqueue
/I..\src\duckdb\third_party\fast_float /I..\src\duckdb\third_party\fastpforlib /I..\src\duckdb\third_party\fmt\include /I..\src\duckdb\third_party\fsst /I..\src\duckdb\third_party\httplib
/I..\src\duckdb\third_party\hyperloglog /I..\src\duckdb\third_party\jaro_winkler /I..\src\duckdb\third_party\jaro_winkler\details /I..\src\duckdb\third_party\libpg_query
/I..\src\duckdb\third_party\libpg_query\include /I..\src\duckdb\third_party\lz4 /I..\src\duckdb\third_party\brotli\include /I..\src\duckdb\third_party\brotli\common /I..\src\duckdb\third_party\brotli\dec
/I..\src\duckdb\third_party\brotli\enc /I..\src\duckdb\third_party\mbedtls /I..\src\duckdb\third_party\mbedtls\include /I..\src\duckdb\third_party\mbedtls\library /I..\src\duckdb\third_party\miniz
/I..\src\duckdb\third_party\pcg /I..\src\duckdb\third_party\re2 /I..\src\duckdb\third_party\skiplist /I..\src\duckdb\third_party\tdigest /I..\src\duckdb\third_party\utf8proc
/I..\src\duckdb\third_party\utf8proc\include /I..\src\duckdb\third_party\yyjson\include /I..\src\duckdb\extension\parquet\include /I..\src\duckdb\third_party\parquet /I..\src\duckdb\third_party\thrift
/I..\src\duckdb\third_party\snappy /I..\src\duckdb\third_party\zstd\include /I..\src\duckdb\extension\icu\include /I..\src\duckdb\extension\icu\third_party\icu\common
/I..\src\duckdb\extension\icu\third_party\icu\i18n /I..\src\duckdb\extension\json\include /Z7 /nologo /W3 /WX- /diagnostics:column /MP /Ox /Ob2 /Oi /Ot /Oy /GL /D NODE_GYP_MODULE_NAME=duckdb /D
USING_UV_SHARED=1 /D USING_V8_SHARED=1 /D V8_DEPRECATION_WARNINGS=1 /D _GLIBCXX_USE_CXX11_ABI=1 /D ELECTRON_ENSURE_CONFIG_GYPI /D USING_ELECTRON_CONFIG_GYPI /D V8_COMPRESS_POINTERS /D
V8_COMPRESS_POINTERS_IN_ISOLATE_CAGE /D V8_31BIT_SMIS_ON_64BIT_ARCH /D V8_ENABLE_SANDBOX /D WIN32 /D _CRT_SECURE_NO_DEPRECATE /D _CRT_NONSTDC_NO_DEPRECATE /D _HAS_EXCEPTIONS=0 /D OPENSSL_NO_PINSHARED /D
OPENSSL_THREADS /D OPENSSL_NO_ASM /D NAPI_VERS... [E:\project\ht_chart\ht_chart_back\node_modules\duckdb\build\duckdb.vcxproj]

However, if I just run the 'test' or 'pack' command in duckdb-node, these errors will disappear.

Could you please help me to solve this problem? <3

[neolord0]

I had the same problem.
I used the already generated node file without compiling it.

Delete src, binding.gyp, binding.gyp.in, and Makefile from the node_modules/duckdb folder as follows.

This will prevent node-gyp from compiling duckdb when packaging your electron program.
And, put the duckdb module and all modules that duckdb depends on into the "app.asar.unpacked" folder.

This will allow you to use duckdb with electron programs on Windows.