zzstoatzz.io / typeahead
GET /xrpc/app.bsky.actor.searchActorsTypeahead typeahead.waow.tech
16
fork

Configure Feed

Select the types of activity you want to include in your feed.

typeahead / scripts / migrate-avatar-cid.sql
at 5080912ca9c3d7d4301e4dce83a5b804de56d00a 12 lines 423 B view raw
zzstoatzz add moderation filtering and store avatar CIDs instead of full URLs
b894163d
1-- one-shot migration: convert full avatar URLs to CIDs 2-- strips the URL prefix (including DID) and @jpeg suffix, leaving just the CID 3-- 4-- run with: npx wrangler d1 execute typeahead --remote --file scripts/migrate-avatar-cid.sql 5 6UPDATE actors 7SET avatar_url = REPLACE( 8 REPLACE(avatar_url, 'https://cdn.bsky.app/img/avatar/plain/' || did || '/', ''), 9 '@jpeg', 10 '' 11) 12WHERE avatar_url LIKE 'https://cdn.bsky.app/%';