[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_204":205,"_206":207},"routes/_app.x.$handle.$name",{"_99":98,"_32":45,"_107":86,"_27":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":120,"_121":122,"_123":25,"_124":125,"_126":58,"_127":-5,"_128":-5,"_129":130},"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":31,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",7,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":37,"_35":36,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","api.ts","latestPath","fileId","cd4e9818-34ee-11f0-95e5-9e149126039e","name","fileType","script","content","import { getTweetCountsByDay, getTotalTweetCounts, 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}","http","createdAt",["D",1747686087329],"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","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",{"_99":98,"_106":102},"org",{"_99":98,"_100":-5,"_101":102,"_18":55,"_103":104,"_105":25},"branch",{"_13":85,"_32":86,"_43":42,"_87":44,"_88":89,"_90":91,"_92":50,"_93":94,"_95":64,"_96":45,"_97":98},"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":200,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":201,"_80":202,"_82":203,"_84":25},"tree",[183,184,185,186],"files",[183,184,185,186],"counts",{"_173":135,"_174":62,"_175":135,"_176":177,"_178":179},"contents",[140,141,142,143],"upstreamProject",{"_43":94,"_32":138,"_52":-5,"_54":-5,"_49":50,"_78":139},"upstreamBranch",{"_43":89,"_38":131,"_132":133,"_32":86,"_87":94,"_13":91,"_88":134,"_90":135,"_136":137,"_47":-5,"_84":25,"_49":50,"_97":98,"_63":64,"_96":138},"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",{"_99":98,"_106":102},{"_43":165,"_32":166,"_30":167,"_147":-5,"_41":42,"_40":168,"_149":25,"_38":169,"_13":170,"_33":20,"_35":171,"_24":25,"_153":-5,"_27":172},{"_43":162,"_32":28,"_30":31,"_147":-5,"_41":42,"_40":14,"_149":25,"_38":163,"_13":62,"_33":37,"_35":36,"_24":25,"_153":-5,"_27":164},{"_43":155,"_32":156,"_30":157,"_147":-5,"_41":42,"_40":158,"_149":58,"_38":159,"_13":135,"_33":34,"_35":160,"_24":25,"_153":-5,"_27":161},{"_43":144,"_32":145,"_30":146,"_147":-5,"_41":42,"_40":148,"_149":25,"_38":150,"_13":62,"_33":151,"_35":152,"_24":25,"_153":-5,"_27":154},"ba257a22-34ee-11f0-b227-9e149126039e","main.tsx","573aad4c-19b9-4099-aa1a-6ca58ff30ffe","parentId",4,"latest",["D",1747686037827],"interval","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: string) {\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 });\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}","label",[145],"b1596ce6-34ee-11f0-ab9e-9e149126039e","db.ts","b1596dae-34ee-11f0-ab9e-9e149126039e",3,["D",1747686023074],"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}",[156],"d7a71b78-34ee-11f0-902c-9e149126039e",["D",1747686087329],[28],"d2feb9e6-34ee-11f0-9a91-9e149126039e","README.md","623a97b9-7fbb-4e77-b25c-572e68c9eb26",6,["D",1747686079518],2,"# 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",[166],"pulls","branches","forks","envVars",{"_180":62,"_182":135},"connections",{"_180":135,"_181":135},"count","unfilledCount","emptyCount",{"_43":165,"_32":166,"_30":167,"_147":-5,"_41":42,"_40":168,"_149":25,"_38":197,"_13":170,"_33":20,"_35":171,"_24":25,"_153":-5,"_188":198,"_27":199},{"_43":162,"_32":28,"_30":31,"_147":-5,"_41":42,"_40":14,"_149":25,"_38":194,"_13":62,"_33":37,"_35":36,"_24":25,"_153":-5,"_188":195,"_27":196},{"_43":155,"_32":156,"_30":157,"_147":-5,"_41":42,"_40":158,"_149":58,"_38":191,"_13":135,"_33":34,"_35":160,"_24":25,"_153":-5,"_188":192,"_27":193},{"_43":144,"_32":145,"_30":146,"_147":-5,"_41":42,"_40":148,"_149":25,"_38":187,"_13":62,"_33":151,"_35":152,"_24":25,"_153":-5,"_188":189,"_27":190},["D",1747686037827],"children",[],[145],["D",1747686023074],[],[156],["D",1747686087329],[],[28],["D",1747686079518],[],[166],["D",1747685840126],{"_99":98,"_106":102},{"_99":98,"_100":-5,"_101":102,"_18":55,"_103":104,"_105":25},{"_13":85,"_32":86,"_43":42,"_87":44,"_88":89,"_90":91,"_92":50,"_93":94,"_95":64,"_96":45,"_97":98},"ctx",{"_78":-5,"_128":237,"_238":239,"_240":241,"_242":25,"_243":25,"_244":25,"_245":58,"_246":-5,"_247":-7,"_248":-7,"_249":135,"_250":25,"_251":25,"_252":-5,"_253":25,"_254":25,"_255":25,"_256":-5},"ENV",{"_208":209,"_210":211,"_212":86,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236},"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 · v7