sqlite3-page-explorer-git
maintainer zxp19821005
· 0 votes
· scanned 2026-08-03 00:08:14.047287
LOW
View on AUR ↗
Why flagged
The npm install and npx usage are part of building the project from source and use the project's own package.json; no untrusted remote code execution occurs.
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-07-25) reviewed the full PKGBUILD and judged it LOW (confidence 95%): The npm install and npx usage are part of building the project from source and use the project's own package.json; no untrusted remote code execution occurs.
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:69
NODE_ENV=development 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:73
NODE_ENV=production 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>
2
pkgname=sqlite3-page-explorer-git
3
_pkgname="cc.siara.${pkgname%-git}"
4
pkgver=1.0.r75.g0d0b58b
5
_electronversion=22
6
_nodeversion=18
7
pkgrel=1
8
pkgdesc="Cross Platform app to explore internal organisation of tables and indices.(Use system-wide electron)"
9
arch=('any')
10
url="https://github.com/siara-cc/sqlite3_page_explorer"
11
license=('Apache-2.0')
12
provides=("${pkgname%-git}=${pkgver}")
13
conflicts=("${pkgname%-git}")
14
depends=(
15
"electron${_electronversion}"
16
)
17
makedepends=(
18
'git'
19
'npm'
20
'nvm'
21
'gendesk'
22
'curl'
23
)
24
source=(
25
"${pkgname%-git}.git::git+${url}.git"
26
"${pkgname%-git}.sh"
27
)
28
sha256sums=('SKIP'
29
'291f50480f5a61bc9c68db7d44cd0412071128706baa868a9cb854f8779a1980')
30
pkgver() {
31
cd "${srcdir}/${pkgname%-git}.git"
32
set -o pipefail
33
git describe --long --tags --abbrev=7 | sed 's/\([^-]*-g\)/r\1/;s/-/./g;s/v//g' ||
34
printf "r%s.%s" "$(git rev-list --count HEAD)" "$(git rev-parse --short=7 HEAD)"
35
}
36
_ensure_local_nvm() {
37
local NVM_DIR="${srcdir}/.nvm"
38
source /usr/share/nvm/init-nvm.sh || [[ $? != 1 ]]
39
nvm install "${_nodeversion}"
40
nvm use "${_nodeversion}"
41
}
42
prepare() {
43
sed -i -e "
44
s/@electronversion@/${_electronversion}/g
45
s/@appname@/${pkgname%-git}/g
46
s/@runname@/app.asar/g
47
s/@cfgdirname@/${_pkgname}/g
48
s/@options@//g
49
" "${srcdir}/${pkgname%-git}.sh"
50
gendesk -q -f -n --pkgname="${pkgname%-git}" --pkgdesc="${pkgdesc}" --categories="Development" --name="${pkgname%-git}" --exec="${pkgname%-git} %U"
51
cd "${srcdir}/${pkgname%-git}.git"
52
export ELECTRON_SKIP_BINARY_DOWNLOAD=1
53
export SYSTEM_ELECTRON_VERSION="$(electron${_electronversion} -v | sed 's/v//g')"
54
HOME="${srcdir}/.electron-gyp"
55
{
56
echo -e '\n'
57
#echo 'build_from_source=true'
58
echo "cache=${srcdir}/.npm_cache"
59
} >> .npmrc
60
if [[ "$(curl -s ipinfo.io/country)" == *"CN"* ]]; then
61
{
62
echo 'registry=https://registry.npmmirror.com'
63
echo 'electron_mirror=https://registry.npmmirror.com/-/binary/electron/'
64
echo 'electron_builder_binaries_mirror=https://registry.npmmirror.com/-/binary/electron-builder-binaries/'
65
} >> .npmrc
66
find ./ -type f -name "package-lock.json" -exec sed -i "s/registry.npmjs.org/registry.npmmirror.com/g" {} +
67
fi
68
NODE_ENV=development npm install
69
NODE_ENV=development npm add -D "@electron/packager"
70
}
71
build() {
72
cd "${srcdir}/${pkgname%-git}.git"
73
NODE_ENV=production npx electron-packager . "${pkgname%-git}" --overwrite --asar=true --platform=linux --icon=res/icons/db_search.png --prune=true --out=release --ignore="^/release"
74
}
75
package() {
76
install -Dm755 "${srcdir}/${pkgname%-git}.sh" "${pkgdir}/usr/bin/${pkgname%-git}"
77
install -Dm644 "${srcdir}/${pkgname%-git}.git/release/${pkgname%-git}-"*/resources/app.asar -t "${pkgdir}/usr/lib/${pkgname%-git}"
78
install -Dm644 "${srcdir}/${pkgname%-git}.git/res/icons/db_search.png" "${pkgdir}/usr/share/pixmaps/${pkgname%-git}.png"
79
install -Dm644 "${srcdir}/${pkgname%-git}.desktop" -t "${pkgdir}/usr/share/applications"
80
}
81
Scan history
| Scanned at (UTC) | Severity | Rules |
|---|---|---|
| 2026-08-03 00:08:14 | LOW | 3 |
| 2026-08-02 00:16:08 | LOW | 3 |
| 2026-08-01 00:11:18 | LOW | 3 |
| 2026-07-31 00:14:10 | LOW | 3 |
| 2026-07-30 00:17:23 | LOW | 3 |
| 2026-07-29 00:25:53 | LOW | 3 |
| 2026-07-28 00:07:28 | LOW | 3 |
| 2026-07-27 00:24:32 | LOW | 3 |
| 2026-07-26 00:07:32 | LOW | 3 |
| 2026-07-25 00:13:44 | LOW | 3 |
| 2026-07-24 00:02:28 | LOW | 3 |
| 2026-07-23 00:14:47 | LOW | 3 |
| 2026-07-22 00:29:32 | LOW | 3 |
| 2026-07-21 00:24:15 | LOW | 3 |
| 2026-07-20 00:19:49 | LOW | 3 |
| 2026-07-19 00:17:08 | LOW | 3 |
| 2026-07-18 00:14:48 | LOW | 3 |
| 2026-07-17 00:06:16 | LOW | 3 |
| 2026-07-16 00:05:41 | LOW | 3 |
| 2026-07-15 00:09:25 | LOW | 3 |