download jlcpcb stock into a sqlite database for easy local viewing via DB Browser for SQLite.

jlcpcb_parts_download

#!/usr/bin/env bash

set -euo pipefail

DB_FILE=$(ls *.db 2>/dev/null | grep "JLCPCB" | head -n 1 || echo "")
if [ -n "$DB_FILE" ]; then
    echo "Already downloaded, exiting: $DB_FILE"
    exit 0
fi


echo "Downloading JLCPCB parts database..."
DOWNLOAD_URL="https://cdfer.github.io/jlcpcb-parts-database/jlcpcb-components.sqlite3"
CURRENT_DATE=$(date +"%Y_%m_%d")
OUTPUT_FILE="JLCPCB_${CURRENT_DATE}.db"

curl -L -o "$OUTPUT_FILE" "$DOWNLOAD_URL"

echo "Creating optimized table for easier querying..."
sqlite3 "$OUTPUT_FILE" <<EOF
DROP TABLE IF EXISTS aaa;
CREATE TABLE aaa AS
SELECT lcsc, basic, stock, ROUND(json_extract(price, '\$[0].price'), 3) AS price, mfr, category, subcategory, joints, description, datasheet
FROM components 
INNER JOIN categories ON components.category_id = categories.id
EOF
echo "Database processing complete."