unable to invoke node js binary in sidecar

[abhijitpatil181171]

Describe the bug

I have backend in node with sqlite . i have created binary of node using pkg but when i use this binary as sidecar and invoked in main.rs then i am getting error as shown img

Reproduction

No response

Expected behavior

main.rust should run backend binary so that my frontend can access backend api

Full tauri info output

{
  "$schema": "../node_modules/@tauri-apps/cli/schema.json",
  "build": {
    "beforeBuildCommand": "npm run build",
    "beforeDevCommand": "npm run start",
    "devPath": "http://localhost:3000",
    "distDir": "../build"
  },
  "package": {
    "productName": "web-application",
    "version": "0.1.0"
  },
  "tauri": {
    "allowlist": {
      "all": true,
      "shell": {
        "sidecar": true,
        "scope": [
          {
            "name": "D:\\Test-Json\\node-sqlite-backend\\server-win",
            "sidecar": true
          }
        ]
      }
    },

    "bundle": {
      "active": true,
      "category": "DeveloperTool",
      "copyright": "",
      "deb": {
        "depends": []
      },
      "externalBin": ["D:\\Test-Json\\node-sqlite-backend\\server-win"],
      "icon": [
        "icons/32x32.png",
        "icons/128x128.png",
        "icons/128x128@2x.png",
        "icons/icon.icns",
        "icons/icon.ico"
      ],
      "identifier": "com.yourdomain.yourapp",
      "longDescription": "",
      "macOS": {
        "entitlements": null,
        "exceptionDomain": "",
        "frameworks": [],
        "providerShortName": null,
        "signingIdentity": null
      },
      "resources": [],
      "shortDescription": "",
      "targets": "all",
      "windows": {
        "certificateThumbprint": null,
        "digestAlgorithm": "sha256",
        "timestampUrl": ""
      }
    },
    "security": {
      "dangerousDisableAssetCspModification": false,
      "dangerousRemoteDomainIpcAccess": [],
      "dangerousUseHttpScheme": true,
      "freezePrototype": false
    },
    "updater": {
      "active": false
    },
    "windows": [
      {
        "fullscreen": false,
        "height": 800,
        "resizable": true,
        "title": "USER ENTRY",
        "width": 920
      }
    ]
  }
}
this is my tauri.config.json

Stack trace

No response

Additional context

[FabianLars]

Can you try adding one of those to your package.json file to make pkg include the sqlite files?

The generic one (probably won't work):

"pkg": {
    "assets": ["node_modules/sqlite3/lib/bindings"]
}

The specific one (may be different per OS, or package manager, but this is what it looked like for me on windows):

"pkg": {
    "assets": ["node_modules/sqlite3/build/Release/node_sqlite3.node"]
}

[abhijitpatil181171]

i have added "pkg": {
"assets": ["node_modules/sqlite3/build/Release/node_sqlite3.node"]
}
in my backend code but if you closely look at file path in terminal it is looking for sqlite it is starting my C:/..... but my backend project is in D directory and tauri and backend is in samedirectory i have attached image of same

[abhijitpatil181171]

yes it is solved i have to copy node_modules/sqlite3/build/Release/node_sqlite3.node along with binary