installation error when running setup.sh about uu-notify HOT 3 CLOSED

if mapbox/node-sqlite3 is not updated any time soon, here are some alternative (long term) solutions:

from mapbox/node-sqlite3, issue no.1493: //how to avoid mentioning this issue in sqlite3-1493? too late, cannot be undone.

A.)

modify package.json:

"resolutions": {
  "node-gyp": "^8"
}

...and go back to latest mapbox/node-sqlite3 release

B.)

replace mapbox/node-sqlite3 by the fork from microsoft-vscode guys:
https://www.npmjs.com/package/@vscode/sqlite3
https://github.com/microsoft/vscode-node-sqlite3

--> use npm alias:

"sqlite3": "npm:@vscode/sqlite3@^5.0.7",

⚠️ the fork depends on Python >= 3.6.0 (I assume at build time, only?)
should not be a problem, uberspace has python 3.6.x
however, might need to update the uberlab guide to set default python version to 3.6 or higher? or better specify in the shebang of setup.sh since its a build time dependency only:

#!/usr/bin/env python3

Todo:

• double check if this fork really uses an up-to-date version of node-gyp. A: yes it does, the fork includes the required commit

Option B should be evaluated if it, because mapbox/node-sqlite3 seems to be not actively maintained (currently 300+ open issues and complaints about (transitive) vulnerabilities not being fixed timely)

from uu-notify.

new versions of sqlite3 have been released. however, with sqlite v5.0.8, uu-notify will crash at runtime on uberspace with following error:

$ node index.mjs
internal/modules/cjs/loader.js:1144
  return process.dlopen(module, path.toNamespacedPath(filename));
                 ^

Error: /lib64/libstdc++.so.6: version `CXXABI_1.3.8' not found (required by /home/dummy-user/uu-notify/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-x64/node_sqlite3.node)
    at Object.Module._extensions..node (internal/modules/cjs/loader.js:1144:18)
    at Module.load (internal/modules/cjs/loader.js:950:32)
    at Function.Module._load (internal/modules/cjs/loader.js:790:12)
    at Module.require (internal/modules/cjs/loader.js:974:19)
    at require (internal/modules/cjs/helpers.js:101:18)
    at Object.<anonymous> (/home/fnk/uu-notify/node_modules/sqlite3/lib/sqlite3-binding.js:4:17)
    at Module._compile (internal/modules/cjs/loader.js:1085:14)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1114:10)
    at Module.load (internal/modules/cjs/loader.js:950:32)
    at Function.Module._load (internal/modules/cjs/loader.js:790:12) {
  code: 'ERR_DLOPEN_FAILED'
}

this is an issue specific to centos7 and there is an issue open at sqlite3: TryGhost/node-sqlite3#1582

from uu-notify.

obsolete / resolved by #11

from uu-notify.