socksthewolf.com / skyscheduler
Schedule posts to Bluesky with Cloudflare workers. skyscheduler.work
cf tool bsky-tool cloudflare bluesky schedule bsky service social-media cloudflare-workers
fork atom
skyscheduler / migrations / 0009_first_black_cat.sql
at main 3 lines 293 B view raw
SocksTheWolf put even more indexes on
aafab085
1DROP INDEX `postedUpdate_idx`;--> statement-breakpoint 2CREATE INDEX `postNowScheduledDatePosted_idx` ON `posts` (`posted`,`scheduled_date`,`postNow`) WHERE posted = 0 and postNow <> 0;--> statement-breakpoint 3CREATE INDEX `postedUpdate_idx` ON `posts` (`updated_at`,`posted`) WHERE posted = 1;