Post Bridge

Build me a personal social post scheduler to replace Post Bridge. Requirements: - Node + Express + better-sqlite3; a localhost page with a compose box, image/video attach, and the queue ordered by send time. - Targets with open APIs only: Bluesky (app password via @atproto/api), Mastodon (access token), and a Telegram channel (bot token). Creds in .env, one small adapter file per network so a fourth is addable later. - For the approval-gated platforms people actually want (TikTok, Instagram, YouTube, Facebook, Threads, Pinterest, LinkedIn), do NOT fight their APIs: at post time send me an ntfy.sh push with the caption and media path so I can post by hand in a minute. Say clearly in the README that these need approved developer apps and business verification you cannot one-shot. - Slot-based queue: I define posting times per weekday in my timezone and new posts fill the next free slot; a post can also be pinned to an exact datetime or duplicated across networks with per-network text and counts. - A node-cron tick every minute publishes due posts, marks each row sent or failed, retries failures 3 times with backoff, and marks before sending so nothing double-posts. - Attached media stored in media/ next to the database, images resized per network with sharp. - A history page of the last 100 sent posts linking to the live posts. - Runs on my always-on box; localhost only, no accounts, no telemetry. - Out of scope: cross-network analytics, teams, and per-platform video transcoding. - README: getting a Bluesky app password, a Mastodon token, and a Telegram bot token, plus an honest note that social APIs drift and this needs occasional patching.