Something went wrong. Try again.
A simple BlueSky profile labeler that can be ran on Cloudflare Workers github.com/SocksTheWolf/SimpleBSkyLabeler
cf bsky profile label bluesky cloudflare workers
Something went wrong. Try again.
simplebskylabeler setup.sql
324 B · 8 lines
SQL
at main
123456789CREATE TABLE IF NOT EXISTS labeled ( id INTEGER PRIMARY KEY, account STRING UNIQUE NOT NULL, time TIMESTAMP DEFAULT (STRFTIME('%Y-%m-%dT%H:%M:%fZ', 'NOW', 'localtime')) NOT NULL, neg INTEGER DEFAULT 0 NOT NULL );CREATE INDEX IF NOT EXISTS idx_labeled_non_removed ON labeled(neg) WHERE neg == 0;pragma optimize