sqlite3-page-explorer-git

LOW

maintainer zxp19821005 0 votes scanned 2026-11-01 00:21:48.120785

View on AUR

Why flagged

The flagged npm install and npx usage are part of building the project from its own source with declared dependencies; no untrusted remote code execution or malicious payloads are present.

Triggered rules

Low AI review downgraded a static finding llm_review

The static rules flagged this MEDIUM, but an AI model (qwen/qwen3-235b-a22b-2507) reviewed the full PKGBUILD and judged it LOW (confidence 95%): The flagged npm install and npx usage are part of building the project from its own source with declared dependencies; no untrusted remote code execution or malicious payloads are present.

2 higher static findings superseded - not the current verdict (shown for transparency)

Medium npm/yarn/pnpm install of an undeclared external package npm_install_external

Runs `npm/yarn/pnpm install <package>` for a package not in source=(), pulling unpinned, unreviewed code at build time. Severity downgraded: the package declares/looks like a Node.js consumer, where build-time installs are expected.

PKGBUILD:87 npm add -D "@electron/packager"

Medium npx/bunx/deno executes a remote package remote_code_tool

`npx`/`bunx`/`pnpm dlx`/`deno run <url>` downloads AND runs a remote package at build time — the moral equivalent of piping a download into a shell. Severity downgraded: Node.js consumer context.

PKGBUILD:92 npx electron-packager . "${pkgname%-git}" --overwrite --asar=true --platform=linux --icon=res/icons/db_search.png --prune=true --out=release --ignore="^/release"

PKGBUILD

2 offending line(s) highlighted

      1# Maintainer: zxp19821005 <zxp19821005 at 163 dot com>
    
      2pkgname=sqlite3-page-explorer-git
    
      3_pkgname="cc.siara.${pkgname%-git}"
    
      4pkgver=1.0.r88.g633fb21
    
      5_electronversion=39
    
      6_nodeversion=22
    
      7pkgrel=1
    
      8pkgdesc="Cross Platform app to explore internal organisation of tables and indices."
    
      9arch=('any')
    
      10url="https://github.com/siara-cc/sqlite3_page_explorer"
    
      11license=('Apache-2.0')
    
      12provides=("${pkgname%-git}=${pkgver}")
    
      13conflicts=("${pkgname%-git}")
    
      14depends=(
    
      15    "electron${_electronversion}"
    
      16)
    
      17makedepends=(
    
      18    'git'
    
      19    'npm'
    
      20    'nvm'
    
      21    'gendesk'
    
      22    'curl'
    
      23    'jq'
    
      24)
    
      25source=(
    
      26    "${pkgname%-git}.git::git+${url}.git"
    
      27    "${pkgname%-git}.sh"
    
      28)
    
      29sha256sums=('SKIP'
    
      30            'a774c2f54fbbeeaac3cefc0f7250796d30c86d27f0fd40b7eaf9c0fdb021623d')
    
      31pkgver() {
    
      32    cd "${srcdir}/${pkgname%-git}.git"
    
      33    set -o pipefail
    
      34    git describe --long --tags --abbrev=7 | sed 's/\([^-]*-g\)/r\1/;s/-/./g;s/v//g' ||
    
      35    printf "r%s.%s" "$(git rev-list --count HEAD)" "$(git rev-parse --short=7 HEAD)"
    
      36}
    
      37_ensure_local_nvm() {
    
      38    local NVM_DIR="${srcdir}/.nvm"
    
      39    source /usr/share/nvm/init-nvm.sh || [[ $? != 1 ]]
    
      40    nvm install "${_nodeversion}"
    
      41    nvm use "${_nodeversion}"
    
      42}
    
      43_get_app_dir() {
    
      44	find "${srcdir}" -type d -name "node_modules" -prune -o -type f -name "resources.pak" -print0 | xargs -0 dirname | head -n 1
    
      45}
    
      46_get_electron_version() {
    
      47    _elec_ver=$(find "${srcdir}" -maxdepth 5 -name "package.json" ! -path "*/node_modules/*" \
    
      48        -exec grep -l '"electron"' {} + | xargs -I{} jq -r '(.devDependencies.electron // .dependencies.electron) // empty' {} 2>/dev/null | head -1)
    
      49    [[ -z "${_elec_ver}" ]] && return 1
    
      50    echo -e "The electron version is: \033[1;31m${_elec_ver%%.*}\033[0m"
    
      51}
    
      52_set_build_env() {
    
      53	export ELECTRON_DIST="/usr/lib/electron${_electronversion}"
    
      54	export ELECTRON_OVERRIDE_DIST_PATH="${ELECTRON_DIST}"
    
      55	export ELECTRON_SKIP_BINARY_DOWNLOAD=1
    
      56	export SYSTEM_ELECTRON_VERSION="$(electron${_electronversion} -v | sed 's/^v//')"
    
      57	export HOME="${srcdir}/.home"
    
      58	export XDG_CACHE_HOME="${HOME}/.cache"
    
      59	export XDG_CONFIG_HOME="${HOME}/.config"
    
      60	export XDG_DATA_HOME="${HOME}/.local/share"
    
      61	export npm_config_cache="${HOME}/.npm_cache"
    
      62	export COREPACK_NPM_REGISTRY="${COREPACK_NPM_REGISTRY:-${NPM_CONFIG_REGISTRY:-https://registry.npmjs.org}}"
    
      63	export COREPACK_HOME="${HOME}/.corepack"
    
      64	export npm_config_audit=false
    
      65	mkdir -p "${HOME}" "${npm_config_cache}" "${COREPACK_HOME}"
    
      66}
    
      67prepare() {
    
      68    cd "${srcdir}/${pkgname%-git}.git"
    
      69    _get_electron_version
    
      70    sed -i -e "
    
      71        s/@electronversion@/${_electronversion}/g
    
      72        s/@appname@/${pkgname%-git}/g
    
      73        s/@runname@/app.asar/g
    
      74        s/@cfgdirname@/${_pkgname}/g
    
      75    " "${srcdir}/${pkgname%-git}.sh"
    
      76    gendesk -q -f -n \
    
      77        --pkgname="${pkgname%-git}" \
    
      78        --pkgdesc="${pkgdesc}" \
    
      79        --categories="Development" \
    
      80        --name="${pkgname%-git}" \
    
      81        --exec="${pkgname%-git} %U"
    
      82    _set_build_env
    
      83    _ensure_local_nvm
    
      84    sed -i "s/\"electron\": \"[^\"]*\"/\"electron\": \"${SYSTEM_ELECTRON_VERSION}\"/g" package.json
    
      85    export NODE_ENV=development
    
      86    npm install
    
      87    npm add -D "@electron/packager"
    
      88}
    
      89build() {
    
      90    cd "${srcdir}/${pkgname%-git}.git"
    
      91    export NODE_ENV=production
    
      92    npx electron-packager . "${pkgname%-git}" --overwrite --asar=true --platform=linux --icon=res/icons/db_search.png --prune=true --out=release --ignore="^/release"
    
      93}
    
      94package() {
    
      95    install -Dm755 "${srcdir}/${pkgname%-git}.sh" "${pkgdir}/usr/bin/${pkgname%-git}"
    
      96    install -Dm755 -d "${pkgdir}/usr/lib/${pkgname%-git}"
    
      97	local _app_dir=$(_get_app_dir)
    
      98	cp -a "${_app_dir}/resources/." "${pkgdir}/usr/lib/${pkgname%-git}/"
    
      99    install -Dm644 "${srcdir}/${pkgname%-git}.git/res/icons/db_search.png" "${pkgdir}/usr/share/pixmaps/${pkgname%-git}.png"
    
      100    install -Dm644 "${srcdir}/${pkgname%-git}.git/${pkgname%-git}.desktop" -t "${pkgdir}/usr/share/applications"
    
      101}

Scan history

Scanned at (UTC)	Severity	Rules
2026-11-01 00:21:48	Low	3
2026-10-31 00:07:41	Low	3
2026-10-30 00:29:30	Low	3
2026-10-29 00:13:55	Low	3
2026-10-28 00:06:54	Low	3
2026-10-27 00:23:28	Low	3
2026-10-26 00:12:40	Low	3
2026-10-25 00:20:48	Low	3
2026-10-24 00:14:55	Low	3
2026-10-23 00:02:19	Low	3
2026-10-22 00:13:10	Low	3
2026-10-21 00:12:50	Low	3
2026-10-20 00:10:31	Low	3
2026-10-19 00:03:55	Low	3
2026-10-18 00:06:55	Low	3
2026-10-17 00:21:55	Low	3
2026-10-16 00:12:47	Low	3
2026-10-15 00:28:05	Low	3
2026-10-14 00:06:47	Low	3
2026-10-13 00:23:45	Low	3