nostalgia‑drip daily tweets highlighting bangers from the community archive.

• runs every 15 min via val.town
• builds a queue of tweets once per utc‑day (00‑:)
• posts each item at the same hour & minute the original tweet dropped, give or take the 15 min tick
• uses supabase for archive lookup, sqlite (val.fs) for local state, and oauth 1.0a creds to hit POST /2/tweets

1. every run (*/15 min): cronValHandler() executes.
2. queue build step (once/day):
   • if nothing queued for today and no “dummy” row in posted_tweets, call selectHighlights().
   • result filtered & capped: 3‑12 tweets, ≤2 per user/year, likes ≥100.
   • craft new tweet text (truncates to fit, adds credit + link).
   • for each, calculate today’s scheduled_at matching original HH:MM (utc) and insert into to_post_queue.
   • if zero highlights, insert dummy-YYYY-MM-DD into posted_tweets to mark the attempt.
3. posting step:
   • grab any queue rows with scheduled_at ≤ now + 15 min.
   • postTweet() signs the request with oauth1 and fires to x api v2.
   • on success, move row to posted_tweets.

1. fork or create a val named communityArchiveBot.
2. add secrets (val → secrets pane):
   • NEXT_PUBLIC_SUPABASE_URL
   • SUPABASE_SERVICE_ROLE
   • X_API_KEY, X_API_SECRET (consumer key/secret)
   • X_ACCESS_TOKEN, X_ACCESS_TOKEN_SECRET (user token/secret)
   • optional X_USERNAME (bot’s handle for nicer logs)
3. set schedule to */15 * * * * (val cron expression).
4. ship it.

note : oauth2 user‑bearer works too, but basic tier is happy with oauth1 and the four tokens are easier to yank from the dev portal.

create table enriched_tweets (
  tweet_id        text primary key,
  account_id      text,
  username        text,
  created_at      timestamptz,
  full_text       text,
  favorite_count  int,
  reply_to_tweet_id text
);

create table all_account (
  account_id text primary key
);

no writes are performed on supabase — it’s read‑only.

Create val
// peek at upcoming queue
await previewQueue();

// manual fire
await cronValHandler({ lastRunAt: undefined });