zzstoatzz.io / typeahead
GET /xrpc/app.bsky.actor.searchActorsTypeahead typeahead.waow.tech
fork atom
typeahead / scripts / add-actor-deltas.sql
at main 6 lines 245 B view raw
zzstoatzz.io granular stats: 5-min actor deltas, 5-min search buckets, layout rearrange
b2703a7b
1CREATE TABLE IF NOT EXISTS actor_deltas ( 2 bucket INTEGER PRIMARY KEY, -- 5-min bucket (Date.now() / 300_000) 3 actors_delta INTEGER NOT NULL DEFAULT 0, 4 handles_delta INTEGER NOT NULL DEFAULT 0, 5 avatars_delta INTEGER NOT NULL DEFAULT 0 6);