SPB Git

Repository Public

backup.sh 1.2 KB 23 lines shellscript

1#!/bin/bash2# Consistent online backup of the SQLite database (VACUUM INTO), gzip, 30-day retention.3# The database holds passkey public keys, session token hashes and end-to-end encrypted sync records:4# a backup alone does not reveal browsing data.5set -euo pipefail6cd "$(dirname "$0")/.."7set -a; [ -f .env ] && . ./.env; set +a8DATA_DIR="${DATA_DIR:-./data}"; DATA_DIR="${DATA_DIR/#\~/$HOME}"9BACKUP_DIR="${BACKUP_DIR:-$HOME/backups/sp-browser-backend}"; BACKUP_DIR="${BACKUP_DIR/#\~/$HOME}"10mkdir -p "$BACKUP_DIR"; chmod 700 "$BACKUP_DIR"11stamp="$(date -u +%Y%m%dT%H%M%SZ)"12out="$BACKUP_DIR/sp-browser-$stamp.sqlite"13node --input-type=commonjs -e '14const { DatabaseSync } = require("node:sqlite");15const db = new DatabaseSync(process.argv[1], { readOnly: true });16db.exec("VACUUM INTO " + JSON.stringify(process.argv[2]).replace(/"/g, "\x27"));17const check = new DatabaseSync(process.argv[2], { readOnly: true }).prepare("PRAGMA integrity_check").get();18if (check.integrity_check !== "ok") { console.error("integrity check failed"); process.exit(1); }19' "$DATA_DIR/sp-browser.sqlite" "$out"20gzip -9 "$out"; chmod 600 "$out.gz"21find "$BACKUP_DIR" -name 'sp-browser-*.sqlite.gz' -mtime +30 -delete22echo "backup ok: $out.gz ($(du -h "$out.gz" | cut -f1))"23
Files main
Menu

Theme