unable to install sqlite3

[micheg]

Version

16.17.1

Platform

Linux manager 5.4.0-155-generic #172-Ubuntu SMP Fri Jul 7 16:10:02 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux

Subsystem

sqlite3

What steps will reproduce the bug?

I can't get sqlite3 to work in any way. I tried to install it with:

• npm install sqlite3
• npm install sqlite3 --build-from-source --target_arch=arm
• npm install sqlite3 --build-from-source --target_arch=arm64
• npm install sqlite3 --build-from-source --target_arch=arm64 --target_platform=android --target=16.17.1
• npm install sqlite3 --build-from-source --target_arch=arm

How often does it reproduce? Is there a required condition?

Always

What is the expected behavior?

working sqlite3

What do you see instead?

every time the apk crashes, reporting: 07-27 22:53:48.881 7473 8068 And nodejs : 07-27 22:53:48.881 7473 8068 E nodejs : Error: dlopen failed: "{MYPATH/}node_modules/sqlite3/lib/binding/napi-v6-android-unknown-arm64/node_sqlite3.node" is for EM_X86_64 (62 ) instead of EM_AARCH64 (183)

Additional information

I use the cordova module with cordova11 (with cordova12 nodejs-mobile doesn't compile at all) the target system is android