image cache on cloudflare r2
dunkirk.sh
1-- Initial schema for image stats
2CREATE TABLE IF NOT EXISTS image_stats (
3 image_key TEXT NOT NULL,
4 bucket_hour INTEGER NOT NULL,
5 hits INTEGER NOT NULL DEFAULT 1,
6 PRIMARY KEY (image_key, bucket_hour)
7) WITHOUT ROWID;
8
9CREATE INDEX IF NOT EXISTS idx_stats_time
10ON image_stats(bucket_hour, image_key);