Skip to content

Latest commit

 

History

History
56 lines (43 loc) · 1.73 KB

containers.md

File metadata and controls

56 lines (43 loc) · 1.73 KB

sb-mirror

Create an rsync mirror of the SponsorBlock database

Data and mirror contents are licenced and used under CC BY-NC-SA 4.0 from https://sponsor.ajay.app

Environment Variables

SQLITE=TRUE # set to auto-generate sqlite .db file to /export  
MIRROR_URL=qc.mchang.xyz # override to set upstream mirror, must be rsync  
MIRROR=TRUE # set to start rsyncd and cron to run every 5 minutes
VALIDATE=TRUE # set to validate files with rsync checksum  
CSVLINT=TRUE # set to remove invalid csv entries

rsync patches

  • add lz4
  • add xxh3
  • disable ACL
  • disable xattr

sb-server-runner

Downloads and runs SponsorBlockServer from the master branch

SponsorBlockServer is licenced under MIT

Environment Variables

DBINIT=TRUE # set to only initialize the database and immediately exit

rsync

Alpine Linux with rsync patches

  • add lz4
  • add xxh3
  • disable ACL
  • disable xattr

docker-compose.yml

PostgreSQL Setup

  1. Download the mirror to a known directory
  2. Set postgresExportPath to the mirror directory

SQLite Setup

  1. Set SQLITE=TRUE on sb-mirror
  2. Set the export directories for SponsorBlockDB.db

Uncomment the respective config file mapping

Database Comparison

Database Postgres SQLite MSSQL
Advantages Performs Well Performs Poorly -
Disadvantages RAM intensive COPY on start Starts Immediately Not Supported

The default admin ID is a hash of WjGS5C9WRhVzjmB8KdrdR8jLqvTwC5q5kAGdC5WVzfDcbAPX