image cache on cloudflare r2
dunkirk.sh
1-- Add 10-minute granularity table for last 24 hours
2CREATE TABLE IF NOT EXISTS image_stats_10min (
3 image_key TEXT NOT NULL,
4 bucket_10min INTEGER NOT NULL,
5 hits INTEGER NOT NULL DEFAULT 1,
6 PRIMARY KEY (image_key, bucket_10min)
7) WITHOUT ROWID;
8
9CREATE INDEX IF NOT EXISTS idx_stats_10min_time
10ON image_stats_10min(bucket_10min, image_key);