[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_206":207,"_208":209},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_108":87,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":121,"_122":123,"_124":25,"_125":126,"_127":59,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",11,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.tsx","latestPath","fileId","573aad4c-19b9-4099-aa1a-6ca58ff30ffe","name","fileType","interval","content","import { twitterSearch } from \"https://esm.town/v/stevekrouse/twitterSearch\";\nimport { initDb, storeTweet } from \"./db.ts\";\n\n// List of competitors to track\nconst COMPETITORS = [\n { name: \"poe\", url: \"poe.com\" },\n { name: \"shapes\", url: \"shapes.inc\" },\n // { name: \"manus\", url: \"manus.im\" },\n // { name: \"coze\", url: \"coze.com\" },\n // { name: \"gumloop\", url: \"gumloop.com\" },\n // { name: \"n8n\", url: \"n8n.io\" },\n // { name: \"genspark\", url: \"genspark.ai\" },\n // { name: \"pi\", url: \"pi.ai\" },\n // { name: \"character\", url: \"character.ai\" },\n];\n\n// This function runs every hour via cron\nexport default async function({ lastRunAt }: Interval) {\n console.log(`Starting competitor tweet tracking at ${new Date().toISOString()}`);\n\n // Initialize the database\n await initDb();\n\n // Track tweets for each competitor\n for (const competitor of COMPETITORS) {\n await trackCompetitorTweets(competitor, lastRunAt);\n }\n\n console.log(`Completed competitor tweet tracking at ${new Date().toISOString()}`);\n}\n\nasync function trackCompetitorTweets(competitor: { name: string; url: string }, lastRunAt: Date | undefined) {\n try {\n console.log(`Tracking tweets for ${competitor.name} (${competitor.url})`);\n\n // Create a query for this competitor\n const query = `\"${competitor.url}\" -is:retweet`;\n\n // Search Twitter\n const results = await twitterSearch({\n query,\n start_time: lastRunAt,\n // bearerToken: Deno.env.get(\"TWITTER_BEARER_TOKEN\"),\n bearerToken: Deno.env.get(\"GLIF_TWITTER_BEARER_TOKEN\"),\n });\n\n if (!results.length) {\n console.debug(`No new tweets for ${competitor.name} since ${lastRunAt}`);\n return;\n }\n\n console.log(`Found ${results.length} tweets for ${competitor.name}`);\n\n // Store tweets in the database (filtering out retweets again just to be safe)\n let storedCount = 0;\n for (const tweet of results.filter(result => !result.is_retweet)) {\n const stored = await storeTweet({\n id: tweet.id,\n competitor: competitor.name,\n author_username: tweet.author_username,\n // created_at: tweet.created_at\n });\n\n if (stored) storedCount++;\n }\n\n console.log(`Stored ${storedCount} new tweets for ${competitor.name}`);\n } catch (error) {\n console.error(`Error tracking tweets for ${competitor.name}:`, error);\n }\n}","import { twitterSearch } from \"https://esm.town/v/stevekrouse/twitterSearch\";\nimport { initDb, storeTweet } from \"./db.ts\";\n\n// List of competitors to track\nconst COMPETITORS = [\n { name: \"poe\", url: \"poe.com\" },\n { name: \"shapes\", url: \"shapes.inc\" },\n // { name: \"manus\", url: \"manus.im\" },\n // { name: \"coze\", url: \"coze.com\" },\n // { name: \"gumloop\", url: \"gumloop.com\" },\n // { name: \"n8n\", url: \"n8n.io\" },\n // { name: \"genspark\", url: \"genspark.ai\" },\n // { name: \"pi\", url: \"pi.ai\" },\n // { name: \"character\", url: \"character.ai\" },\n];\n\n// This function runs every hour via cron\nexport default async function({ lastRunAt }: Interval) {\n console.log(`Starting competitor tweet tracking at ${new Date().toISOString()}`);\n\n // Initialize the database\n await initDb();\n\n // Track tweets for each competitor\n for (const competitor of COMPETITORS) {\n await trackCompetitorTweets(competitor, lastRunAt);\n }\n\n console.log(`Completed competitor tweet tracking at ${new Date().toISOString()}`);\n}\n\nasync function trackCompetitorTweets(competitor: { name: string; url: string }, lastRunAt: Date | undefined) {\n try {\n console.log(`Tracking tweets for ${competitor.name} (${competitor.url})`);\n\n // Create a query for this competitor\n const query = `\"${competitor.url}\" -is:retweet`;\n\n // Search Twitter\n const results = await twitterSearch({\n query,\n start_time: lastRunAt,\n // bearerToken: Deno.env.get(\"TWITTER_BEARER_TOKEN\"),\n bearerToken: Deno.env.get(\"GLIF_TWITTER_BEARER_TOKEN\"),\n });\n\n if (!results.length) {\n console.debug(`No new tweets for ${competitor.name} since ${lastRunAt}`);\n return;\n }\n\n console.log(`Found ${results.length} tweets for ${competitor.name}`);\n\n // Store tweets in the database (filtering out retweets again just to be safe)\n let storedCount = 0;\n for (const tweet of results.filter(result => !result.is_retweet)) {\n const stored = await storeTweet({\n id: tweet.id,\n competitor: competitor.name,\n author_username: tweet.author_username,\n created_at: tweet!.created_at\n });\n\n if (stored) storedCount++;\n }\n\n console.log(`Stored ${storedCount} new tweets for ${competitor.name}`);\n } catch (error) {\n console.error(`Error tracking tweets for ${competitor.name}:`, error);\n }\n}","createdAt",["D",1747687987853],"branchVersion","branchId","444f7c12-34ee-11f0-8f96-9e149126039e","id","444e22a4-34ee-11f0-8f96-9e149126039e","twitterCompetitorMonitoring",["D",1747685840126],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","it costs like $5k month for basic social listening tools lol","imageUrl","28a12253-d65d-490e-97f1-5c00c30f3c90","pinnedFileId","cd4e9818-34ee-11f0-95e5-9e149126039e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",1,"orgId","de23cbae-f041-436a-b718-67f3be167b4d","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":55,"_104":105,"_106":25},"branch",{"_13":86,"_32":87,"_43":42,"_88":44,"_89":90,"_91":92,"_93":50,"_94":95,"_96":65,"_97":45,"_98":99},"isOwned",26,"main","projectId","forkedBranchId","daad77e8-26db-11f0-a5b3-569c3dd06744","forkedBranchVersion",21,"forkedProjectPrivacy","forkedProjectId","daad27e8-26db-11f0-a5b3-569c3dd06744","forkedProjectOrgId","projectName","userHandle","jamiedubs","handle","displayName","avatar","https://avatars.githubusercontent.com/u/1903?v=4","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":202,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":203,"_81":204,"_83":205,"_85":25},"tree",[185,186,187,188],"files",[185,186,187,188],"counts",{"_175":136,"_176":63,"_177":136,"_178":179,"_180":181},"contents",[141,142,143,144],"upstreamProject",{"_43":95,"_32":139,"_52":-5,"_54":-5,"_49":50,"_79":140},"upstreamBranch",{"_43":90,"_38":132,"_133":134,"_32":87,"_88":95,"_13":92,"_89":135,"_91":136,"_137":138,"_47":-5,"_85":25,"_49":50,"_98":99,"_64":65,"_97":139},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1746138615693],"updatedAt",["D",1720551623846],"e1e91fbe-1ae0-11f0-bddc-569c3dd06744",0,"lockfileKey","1746138879370-esm.town_v_jamiedubs_twitterAlert@21-main","twitterAlert",{"_100":99,"_107":103},{"_43":168,"_32":169,"_30":170,"_146":-5,"_41":42,"_40":171,"_147":25,"_38":172,"_13":164,"_33":20,"_35":173,"_24":25,"_150":-5,"_27":174},{"_43":160,"_32":161,"_30":57,"_146":-5,"_41":42,"_40":162,"_147":25,"_38":163,"_13":164,"_33":165,"_35":166,"_24":25,"_150":-5,"_27":167},{"_43":152,"_32":153,"_30":154,"_146":-5,"_41":42,"_40":155,"_147":59,"_38":156,"_13":136,"_33":157,"_35":158,"_24":25,"_150":-5,"_27":159},{"_43":145,"_32":28,"_30":31,"_146":-5,"_41":42,"_40":14,"_147":25,"_38":148,"_13":149,"_33":34,"_35":37,"_24":25,"_150":-5,"_27":151},"4473fa74-34f3-11f0-8a97-9e149126039e","parentId","latest",["D",1747687987853],4,"label",[28],"b1596ce6-34ee-11f0-ab9e-9e149126039e","db.ts","b1596dae-34ee-11f0-ab9e-9e149126039e",3,["D",1747686023074],"script","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table to store tweets mentioning competitors\nconst TWEETS_TABLE = 'competitor_tweets';\n\n// Initialize the database\nexport async function initDb() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TWEETS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n tweet_id TEXT UNIQUE NOT NULL,\n competitor TEXT NOT NULL,\n author_username TEXT NOT NULL,\n created_at TEXT NOT NULL\n )`);\n}\n\n// Store a tweet in the database\nexport async function storeTweet(tweet: {\n id: string;\n competitor: string;\n author_username: string;\n created_at: string;\n}) {\n try {\n await sqlite.execute(\n `INSERT INTO ${TWEETS_TABLE} (tweet_id, competitor, author_username, created_at)\n VALUES (?, ?, ?, ?)`,\n [tweet.id, tweet.competitor, tweet.author_username, tweet.created_at]\n );\n return true;\n } catch (error) {\n // If the tweet already exists (due to UNIQUE constraint), this will fail silently\n if (error.message.includes('UNIQUE constraint failed')) {\n return false;\n }\n throw error;\n }\n}\n\n// Get tweet counts per competitor per day\nexport async function getTweetCountsByDay() {\n const result = await sqlite.execute(\n `SELECT \n competitor,\n date(created_at) as day,\n COUNT(DISTINCT tweet_id) as count\n FROM ${TWEETS_TABLE}\n GROUP BY competitor, day\n ORDER BY day DESC, count DESC`\n );\n \n return result;\n}\n\n// Get the total tweet count for each competitor\nexport async function getTotalTweetCounts() {\n const result = await sqlite.execute(\n `SELECT \n competitor,\n COUNT(DISTINCT tweet_id) as count\n FROM ${TWEETS_TABLE}\n GROUP BY competitor\n ORDER BY count DESC`\n );\n \n return result;\n}",[153],"675a9f4e-34f2-11f0-8276-9e149126039e","api.ts",9,["D",1747687616913],2,"http","import { getTotalTweetCounts, getTweetCountsByDay, initDb } from \"./db.ts\";\n\nexport default async function(req: Request) {\n // Initialize the database\n await initDb();\n\n const url = new URL(req.url);\n\n // API endpoint to get tweet data as JSON\n if (url.pathname === \"/api/data\") {\n const dailyCounts = await getTweetCountsByDay();\n const totalCounts = await getTotalTweetCounts();\n\n return new Response(\n JSON.stringify({ dailyCounts, totalCounts }),\n {\n headers: {\n \"Content-Type\": \"application/json\",\n \"Cache-Control\": \"no-cache\",\n },\n },\n );\n }\n\n // Serve the main HTML page\n return serveHtmlPage();\n}\n\nfunction serveHtmlPage() {\n const html = `\n\n\n \n \n Competitor Tweet Tracker\n \n \n \n\n\n

Competitor Tweet Tracker

\n \n

Daily Tweet Mentions

\n \n

Total Tweet Mentions

\n\n \n\n`;\n\n return new Response(html, {\n headers: {\n \"Content-Type\": \"text/html\",\n \"Cache-Control\": \"no-cache\",\n },\n });\n}",[161],"d2feb9e6-34ee-11f0-9a91-9e149126039e","README.md","623a97b9-7fbb-4e77-b25c-572e68c9eb26",6,["D",1747686079518],"# Competitor Tweet Tracker\n\nThis Val Town project tracks tweets mentioning competitor URLs and visualizes the data in charts.\n\n## Components\n\n1. **Cron Job** (`main.tsx`): Runs hourly to search Twitter for mentions of competitor URLs and stores the results in a database.\n\n2. **Database** (`db.ts`): Uses SQLite to store tweet data and provides functions to query the data.\n\n3. **Web Interface** (`api.ts`): Serves an HTML page with charts showing tweet counts per competitor per day.\n\n## Competitors Tracked\n\n- poe.com\n- shapes.inc\n- manus.im\n- coze.com\n- gumloop.com\n- n8n.io\n- genspark.ai\n- pi.ai\n- character.ai\n\n## How to Use\n\n1. Set up the `TWITTER_BEARER_TOKEN` environment variable with your Twitter API bearer token.\n\n2. The cron job will automatically run every hour to collect data.\n\n3. Visit the HTTP endpoint to view the charts showing tweet counts.\n\n## Features\n\n- Tracks tweets mentioning competitor URLs\n- Avoids double-counting tweets by storing unique tweet IDs\n- Visualizes data in daily trend charts and total count charts\n- Automatically updates as new data is collected",[169],"pulls","branches","forks","envVars",{"_182":63,"_184":136},"connections",{"_182":136,"_183":136},"count","unfilledCount","emptyCount",{"_43":168,"_32":169,"_30":170,"_146":-5,"_41":42,"_40":171,"_147":25,"_38":199,"_13":164,"_33":20,"_35":173,"_24":25,"_150":-5,"_190":200,"_27":201},{"_43":160,"_32":161,"_30":57,"_146":-5,"_41":42,"_40":162,"_147":25,"_38":196,"_13":164,"_33":165,"_35":166,"_24":25,"_150":-5,"_190":197,"_27":198},{"_43":152,"_32":153,"_30":154,"_146":-5,"_41":42,"_40":155,"_147":59,"_38":193,"_13":136,"_33":157,"_35":158,"_24":25,"_150":-5,"_190":194,"_27":195},{"_43":145,"_32":28,"_30":31,"_146":-5,"_41":42,"_40":14,"_147":25,"_38":189,"_13":149,"_33":34,"_35":37,"_24":25,"_150":-5,"_190":191,"_27":192},["D",1747687987853],"children",[],[28],["D",1747686023074],[],[153],["D",1747687616913],[],[161],["D",1747686079518],[],[169],["D",1747685840126],{"_100":99,"_107":103},{"_100":99,"_101":-5,"_102":103,"_18":55,"_104":105,"_106":25},{"_13":86,"_32":87,"_43":42,"_88":44,"_89":90,"_91":92,"_93":50,"_94":95,"_96":65,"_97":45,"_98":99},"ctx",{"_79":-5,"_129":239,"_240":241,"_242":243,"_244":25,"_245":25,"_246":25,"_247":59,"_248":-5,"_249":-7,"_250":-7,"_251":136,"_252":25,"_253":25,"_254":-5,"_255":25,"_256":25,"_257":25,"_258":-5},"ENV",{"_210":211,"_212":213,"_214":87,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v11