socksthewolf.com / simplebskylabeler
A simple BlueSky profile labeler that can be ran on Cloudflare Workers github.com/SocksTheWolf/SimpleBSkyLabeler
cf bsky profile label bluesky cloudflare workers
fork atom
simplebskylabeler / setup.sql
at main 8 lines 324 B view raw
SocksTheWolf Add partial index to SQL query
89d1b381
1CREATE TABLE IF NOT EXISTS labeled ( 2 id INTEGER PRIMARY KEY, 3 account STRING UNIQUE NOT NULL, 4 time TIMESTAMP DEFAULT (STRFTIME('%Y-%m-%dT%H:%M:%fZ', 'NOW', 'localtime')) NOT NULL, 5 neg INTEGER DEFAULT 0 NOT NULL 6); 7CREATE INDEX IF NOT EXISTS idx_labeled_non_removed ON labeled(neg) WHERE neg == 0; 8pragma optimize