sqlark-bin

LOW

maintainer zxp19821005 0 votes scanned 2026-09-17 00:27:14.276658

View on AUR

Why flagged

The package downloads prebuilt RPMs from the official project domain download.sqlark.com, which is plausibly controlled by the software vendor; despite the non-whitelisted host, the source is verifiable via provided sha256sums and the payload is a legitimate application binary, not malicious code.

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 package downloads prebuilt RPMs from the official project domain download.sqlark.com, which is plausibly controlled by the software vendor; despite the non-whitelisted host, the source is verifiable via provided sha256sums and the payload is a legitimate application binary, not malicious code.

1 higher static finding superseded - not the current verdict (shown for transparency)

Medium source=() URL on a non-standard host source_untrusted_domain

One or more source=() URLs point to a host outside the trusted allowlist (github.com, gitlab.com, codeberg.org, pypi.org, …).

PKGBUILD:26 source_aarch64=("${pkgname%-bin}-${pkgver}-aarch64.rpm::https://download.sqlark.com/fullPackage/Linux/${_subver}/${_pkgname}_V${pkgver}_linux_arm64.rpm")

PKGBUILD

1 offending line(s) highlighted

      1# Maintainer: zxp19821005 <zxp19821005 at 163 dot com>
    
      2# Contributor: Bruce Zhang
    
      3pkgname=sqlark-bin
    
      4_pkgname=SQLark
    
      5pkgver=4.0.2
    
      6_subver=941818
    
      7_electronversion=40
    
      8pkgrel=1
    
      9pkgdesc="SQLark is a powerful SQL query tool that provides a user-friendly interface for database management and analysis."
    
      10arch=(
    
      11	'aarch64'
    
      12	'x86_64'
    
      13)
    
      14url="https://www.sqlark.com/"
    
      15license=('LicenseRef-scancode-commercial-license')
    
      16conflicts=("${pkgname%-bin}")
    
      17provides=("${pkgname%-bin}=${pkgver}")
    
      18depends=(
    
      19    "electron${_electronversion}"
    
      20    'libxml2-legacy'
    
      21)
    
      22makedepends=(
    
      23    'asar'
    
      24)
    
      25source=("${pkgname%-bin}.sh")
    
      26source_aarch64=("${pkgname%-bin}-${pkgver}-aarch64.rpm::https://download.sqlark.com/fullPackage/Linux/${_subver}/${_pkgname}_V${pkgver}_linux_arm64.rpm")
    
      27source_x86_64=("${pkgname%-bin}-${pkgver}-x86_64.rpm::https://download.sqlark.com/fullPackage/Linux/${_subver}/${_pkgname}_V${pkgver}_linux_x86_64.rpm")
    
      28sha256sums=('a774c2f54fbbeeaac3cefc0f7250796d30c86d27f0fd40b7eaf9c0fdb021623d')
    
      29sha256sums_aarch64=('f98c1bacf008557536537c606b7df900cbf598ec7cde21e46b05b50d1041d4c5')
    
      30sha256sums_x86_64=('35882d845c61fb0201d4171694eae221a54e83e23623ae835100f3dfc45df26e')
    
      31_get_app_dir() {
    
      32    find "${srcdir}" -type f -name "resources.pak" -exec dirname {} + | head -n 1
    
      33}
    
      34_check_electron_version() {
    
      35    echo "Verifying Electron version..."
    
      36    local _main_exe=$(find "$(_get_app_dir)" -maxdepth 1 -type f -executable -printf '%s %p\n' | sort -nr | head -1 | cut -d' ' -f2-)
    
      37    [[ -z "${_main_exe}" ]] && echo -e "\033[1;33mNote: Could not find Electron binary.\033[0m" && return
    
      38    local _elec_ver=$(strings "${_main_exe}" | grep -oP 'Electron/\K[0-9]+' | head -1)
    
      39    [[ -z "${_elec_ver}" ]] && echo -e "\033[1;33mNote: Could not determine Electron version.\033[0m" && return
    
      40    [[ "${_elec_ver}" != "${_electronversion}" ]] &&
    
      41        echo -e "\033[1;31mWarning: Electron version mismatch! Detected: ${_elec_ver}, Expected: ${_electronversion}\033[0m" ||
    
      42        echo -e "Electron version verified: \033[1;31m${_elec_ver}\033[0m"
    
      43}
    
      44prepare() {
    
      45    sed -i -e "
    
      46        s/@electronversion@/${_electronversion}/g
    
      47        s/@appname@/${pkgname%-bin}/g
    
      48        s/@runname@/resources\/app.asar/g
    
      49        s/@cfgdirname@/${_pkgname}/g
    
      50    " "${srcdir}/${pkgname%-bin}.sh"
    
      51	_check_electron_version
    
      52    sed -i "s/\/opt\/${_pkgname}\///g" "${srcdir}/usr/share/applications/${pkgname%-bin}.desktop"
    
      53}
    
      54package() {
    
      55	install -Dm755 "${srcdir}/${pkgname%-bin}.sh" "${pkgdir}/usr/bin/${pkgname%-bin}"
    
      56    install -Dm755 -d "${pkgdir}/usr/lib/${pkgname%-bin}"
    
      57    local _app_dir=$(_get_app_dir)
    
      58    cp -a "${_app_dir}/resources" "${pkgdir}/usr/lib/${pkgname%-bin}/"
    
      59    cp -a "${_app_dir}/"{data-migrate,plugins,server} "${pkgdir}/usr/lib/${pkgname%-bin}/"
    
      60	install -Dm644 "${srcdir}/usr/share/applications/${pkgname%-bin}.desktop" -t "${pkgdir}/usr/share/applications"
    
      61	find "${srcdir}" -type f \( -name "*.png" -o -name "*.svg" \) -path "*share/icons/*" | while read -r _i; do
    
      62        _extension="${_i##*.}"
    
      63        _icon_path="${_i#*share/icons/}"
    
      64        _target_dir="/usr/share/icons/$(dirname "${_icon_path}")"
    
      65        install -Dm644 "${_i}" "${pkgdir}${_target_dir}/${pkgname%-bin}.${_extension}"
    
      66    done
    
      67}
    
      68

Scan history

Scanned at (UTC)	Severity	Rules
2026-09-17 00:27:14	Low	2
2026-09-16 00:03:17	Low	2
2026-09-15 00:25:31	Low	2
2026-09-14 00:27:57	Low	2
2026-09-13 00:19:54	Low	2
2026-09-12 00:25:17	Low	2
2026-09-11 00:19:22	Low	2
2026-09-10 00:22:44	Low	2
2026-09-09 00:04:09	Low	2
2026-09-08 00:18:08	Low	2
2026-09-07 00:30:15	Low	2
2026-09-06 00:17:06	Low	2
2026-09-05 00:16:27	Low	2
2026-09-04 00:03:13	Low	2
2026-09-03 00:15:47	Low	2
2026-09-02 00:02:31	Low	2
2026-09-01 00:11:19	Low	2
2026-08-31 00:19:57	Low	2
2026-08-30 00:04:14	Low	2
2026-08-29 00:29:17	Low	2