[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_257":258,"_259":260},"routes/_app.x.$handle.$name",{"_105":104,"_32":50,"_113":92,"_27":114,"_13":14,"_115":-5,"_11":116,"_117":118,"_119":120,"_121":122,"_123":124,"_21":-5,"_125":126,"_127":128,"_129":25,"_130":131,"_132":64,"_133":-5,"_134":-5,"_135":136},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_48":49,"_32":50,"_38":51,"_52":-5,"_53":25,"_54":55,"_56":55,"_57":58,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":64,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":25},"version",20,"changes",[19,20],"aiChatInfo","userId",{"_21":43,"_23":-7,"_24":25,"_26":25,"_27":44,"_29":44},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous","deleted",false,"deletedHere","path","utils/competitors.ts","latestPath","fileId","94f5589a-4087-11f0-a555-76b3cceeab13","name","competitors.ts","fileType","script","content","/**\n * Parse competitors from environment variable\n * Expected format: comma-separated list of hostnames\n * Example: \"val.town,poe.com,shapes.inc\"\n */\nexport function getCompetitors(): string[] {\n const competitorsEnv = Deno.env.get(\"COMPETITORS\");\n \n if (!competitorsEnv) {\n // Default to val.town if no competitors are specified\n return [\"val.town\"];\n }\n \n return competitorsEnv\n .split(\",\")\n .map(competitor => competitor.trim())\n .filter(competitor => competitor.length > 0);\n}\n\n/**\n * Validate that competitors list is not empty\n */\nexport function validateCompetitors(): void {\n const competitors = getCompetitors();\n if (competitors.length === 0) {\n throw new Error(\"No competitors specified. Please set the COMPETITORS environment variable.\");\n }\n}","createdAt",["D",1748961151227],"branchVersion","branchId","444f7c12-34ee-11f0-8f96-9e149126039e",{"_30":45,"_32":44,"_34":46,"_36":-5,"_38":47,"_40":14,"_41":42,"_24":25},"utils","21020d56-b425-451f-b850-6aab22a73c88","directory",["D",1748961151227],"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",{"_105":104,"_112":108},"org",{"_105":104,"_106":-5,"_107":108,"_18":60,"_109":110,"_111":25},"branch",{"_13":91,"_32":92,"_48":42,"_93":49,"_94":95,"_96":97,"_98":55,"_99":100,"_101":70,"_102":50,"_103":104},"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",{"_48":49,"_32":50,"_38":253,"_52":-5,"_53":25,"_54":55,"_56":55,"_57":58,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":64,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":254,"_86":255,"_88":256,"_90":25},"tree",[206,208,211,212,213,214],"files",[206,207,208,209,210,211,212,213,214],"counts",{"_196":141,"_197":68,"_198":141,"_199":200,"_201":202},"contents",[146,147,148,149,150,151],"upstreamProject",{"_48":100,"_32":144,"_57":-5,"_59":-5,"_54":55,"_84":145},"upstreamBranch",{"_48":95,"_38":137,"_138":139,"_32":92,"_93":100,"_13":97,"_94":140,"_96":141,"_142":143,"_52":-5,"_90":25,"_54":55,"_103":104,"_69":70,"_102":144},"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",{"_105":104,"_112":108},{"_48":193,"_32":44,"_30":45,"_155":-5,"_41":42,"_40":14,"_157":64,"_38":194,"_13":141,"_34":46,"_36":-5,"_24":25,"_162":-5,"_27":195},{"_48":187,"_32":188,"_30":189,"_155":-5,"_41":42,"_40":190,"_157":64,"_38":191,"_13":141,"_34":46,"_36":-5,"_24":25,"_162":-5,"_27":192},{"_48":179,"_32":180,"_30":181,"_155":-5,"_41":42,"_40":182,"_157":25,"_38":183,"_13":184,"_34":21,"_36":185,"_24":25,"_162":-5,"_27":186},{"_48":171,"_32":172,"_30":62,"_155":-5,"_41":42,"_40":173,"_157":25,"_38":174,"_13":175,"_34":176,"_36":177,"_24":25,"_162":-5,"_27":178},{"_48":164,"_32":165,"_30":166,"_155":-5,"_41":42,"_40":167,"_157":64,"_38":168,"_13":141,"_34":35,"_36":169,"_24":25,"_162":-5,"_27":170},{"_48":152,"_32":153,"_30":154,"_155":-5,"_41":42,"_40":156,"_157":25,"_38":158,"_13":159,"_34":160,"_36":161,"_24":25,"_162":-5,"_27":163},"8b61418c-3500-11f0-bb2c-9e149126039e","main.tsx","573aad4c-19b9-4099-aa1a-6ca58ff30ffe","parentId",14,"latest",["D",1747693690308],7,"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: 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 bearerToken = Deno.env.get(\"TWITTER_BEARER_TOKEN\");\n if (!bearerToken) throw new Error(\"TWITTER_BEARER_TOKEN is required\");\n const results = await twitterSearch({\n query,\n start_time: lastRunAt,\n bearerToken,\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",[153],"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}",[165],"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}",[172],"2a4de7b4-4087-11f0-b1cc-76b3cceeab13","README.md","623a97b9-7fbb-4e77-b25c-572e68c9eb26",17,["D",1748960972291],5,"# 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.\n2. **Database** (`db.ts`): Uses SQLite to store tweet data and provides functions to query the data.\n3. **Web Interface** (`api.ts`): Serves an HTML page with charts showing tweet counts per competitor per day.\n\n\n## How to Use\n\n1. Set up the `TWITTER_BEARER_TOKEN` environment variable with your Twitter API bearer token.\n2. The cron job will automatically run every hour to collect data.\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",[180],"81be5d76-4087-11f0-a981-76b3cceeab13","views","bed97ec8-118f-4101-b178-7fd5ae6ec307",18,["D",1748961118991],[188],"94f561fa-4087-11f0-a555-76b3cceeab13",["D",1748961151227],[44],"pulls","branches","forks","envVars",{"_203":68,"_205":141},"connections",{"_203":141,"_204":141},"count","unfilledCount","emptyCount",{"_48":193,"_32":44,"_30":45,"_155":-5,"_41":42,"_40":14,"_157":64,"_38":250,"_13":141,"_34":46,"_36":-5,"_24":25,"_162":-5,"_216":251,"_27":252},{"_48":246,"_32":33,"_30":31,"_155":45,"_41":42,"_40":14,"_157":64,"_38":247,"_13":141,"_34":35,"_36":37,"_24":25,"_162":-5,"_216":248,"_27":249},{"_48":187,"_32":188,"_30":189,"_155":-5,"_41":42,"_40":190,"_157":64,"_38":243,"_13":141,"_34":46,"_36":-5,"_24":25,"_162":-5,"_216":244,"_27":245},{"_48":235,"_32":236,"_30":237,"_155":189,"_41":42,"_40":238,"_157":64,"_38":239,"_13":141,"_34":35,"_36":240,"_24":25,"_162":-5,"_216":241,"_27":242},{"_48":228,"_32":229,"_30":230,"_155":189,"_41":42,"_40":190,"_157":64,"_38":231,"_13":141,"_34":21,"_36":232,"_24":25,"_162":-5,"_216":233,"_27":234},{"_48":179,"_32":180,"_30":181,"_155":-5,"_41":42,"_40":182,"_157":25,"_38":225,"_13":184,"_34":21,"_36":185,"_24":25,"_162":-5,"_216":226,"_27":227},{"_48":171,"_32":172,"_30":62,"_155":-5,"_41":42,"_40":173,"_157":25,"_38":222,"_13":175,"_34":176,"_36":177,"_24":25,"_162":-5,"_216":223,"_27":224},{"_48":164,"_32":165,"_30":166,"_155":-5,"_41":42,"_40":167,"_157":64,"_38":219,"_13":141,"_34":35,"_36":169,"_24":25,"_162":-5,"_216":220,"_27":221},{"_48":152,"_32":153,"_30":154,"_155":-5,"_41":42,"_40":156,"_157":25,"_38":215,"_13":159,"_34":160,"_36":161,"_24":25,"_162":-5,"_216":217,"_27":218},["D",1747693690308],"children",[],[153],["D",1747686023074],[],[165],["D",1747687616913],[],[172],["D",1748960972291],[],[180],"81be52d6-4087-11f0-a981-76b3cceeab13","index.html","81be53c6-4087-11f0-a981-76b3cceeab13",["D",1748961118991],"\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",[],[188,229],"8fb5b488-4087-11f0-97d4-76b3cceeab13","charts.js","8fb5b53c-4087-11f0-97d4-76b3cceeab13",19,["D",1748961142424],"// Function to generate random colors for chart\nfunction generateColors(count) {\n const colors = [\n '#4299E1', '#48BB78', '#F6AD55', '#F56565', '#9F7AEA',\n '#ED64A6', '#38B2AC', '#ECC94B', '#667EEA', '#FC8181'\n ];\n \n // If we need more colors than in our predefined list, generate random ones\n if (count > colors.length) {\n for (let i = colors.length; i < count; i++) {\n const r = Math.floor(Math.random() * 255);\n const g = Math.floor(Math.random() * 255);\n const b = Math.floor(Math.random() * 255);\n colors.push(`rgb(${r}, ${g}, ${b})`);\n }\n }\n \n return colors.slice(0, count);\n}\n\n// Fetch data and render charts\nasync function renderCharts() {\n try {\n const response = await fetch('/api/data');\n const data = await response.json();\n console.log({ data });\n \n renderDailyChart(data.dailyCounts);\n renderTotalChart(data.totalCounts);\n } catch (error) {\n console.error('Error fetching data:', error);\n document.body.innerHTML += '

Error loading data. Please try again later.

';\n }\n}\n\n// Render daily tweet chart\nfunction renderDailyChart(dailyData) {\n if (!dailyData || dailyData.length === 0) {\n document.getElementById('dailyChart').parentNode.innerHTML = '

No data available yet.

';\n return;\n }\n \n // Process data for chart\n const days = [...new Set(dailyData.map(item => item.day))].sort();\n const competitors = [...new Set(dailyData.map(item => item.competitor))];\n const colors = generateColors(competitors.length);\n \n // Create datasets\n const datasets = competitors.map((competitor, index) => {\n const competitorData = days.map(day => {\n const match = dailyData.find(item => item.day === day && item.competitor === competitor);\n return match ? match.count : 0;\n });\n \n return {\n label: competitor,\n data: competitorData,\n backgroundColor: colors[index],\n borderColor: colors[index],\n borderWidth: 2,\n tension: 0.1,\n fill: false\n };\n });\n \n // Create chart\n new Chart(document.getElementById('dailyChart'), {\n type: 'line',\n data: {\n labels: days,\n datasets: datasets\n },\n options: {\n responsive: true,\n maintainAspectRatio: false,\n scales: {\n y: {\n beginAtZero: true,\n title: {\n display: true,\n text: 'Tweet Count'\n }\n },\n x: {\n title: {\n display: true,\n text: 'Date'\n }\n }\n },\n plugins: {\n legend: {\n position: 'top',\n },\n tooltip: {\n mode: 'index',\n intersect: false\n }\n }\n }\n });\n}\n\n// Render total tweet chart\nfunction renderTotalChart(totalData) {\n if (!totalData || totalData.length === 0) {\n document.getElementById('totalChart').parentNode.innerHTML = '

No data available yet.

';\n return;\n }\n \n // Sort by count descending\n totalData.sort((a, b) => b.count - a.count);\n \n const competitors = totalData.map(item => item.competitor);\n const counts = totalData.map(item => item.count);\n const colors = generateColors(competitors.length);\n \n // Create chart\n new Chart(document.getElementById('totalChart'), {\n type: 'bar',\n data: {\n labels: competitors,\n datasets: [{\n label: 'Total Tweets',\n data: counts,\n backgroundColor: colors,\n borderColor: colors,\n borderWidth: 1\n }]\n },\n options: {\n responsive: true,\n maintainAspectRatio: false,\n scales: {\n y: {\n beginAtZero: true,\n title: {\n display: true,\n text: 'Tweet Count'\n }\n },\n x: {\n title: {\n display: true,\n text: 'Competitor'\n }\n }\n },\n plugins: {\n legend: {\n display: false\n }\n }\n }\n });\n}\n\n// Initialize charts when page loads\ndocument.addEventListener('DOMContentLoaded', renderCharts);",[],[188,236],["D",1748961118991],[209,210],[188],"94f557c8-4087-11f0-a555-76b3cceeab13",["D",1748961151227],[],[44,33],["D",1748961151227],[207],[44],["D",1747685840126],{"_105":104,"_112":108},{"_105":104,"_106":-5,"_107":108,"_18":60,"_109":110,"_111":25},{"_13":91,"_32":92,"_48":42,"_93":49,"_94":95,"_96":97,"_98":55,"_99":100,"_101":70,"_102":50,"_103":104},"ctx",{"_84":-5,"_134":290,"_291":292,"_293":294,"_295":25,"_296":25,"_297":25,"_298":64,"_299":-5,"_300":-7,"_301":-7,"_302":141,"_303":25,"_304":25,"_305":-5,"_306":25,"_307":25,"_308":25,"_309":-5},"ENV",{"_261":262,"_263":264,"_265":92,"_266":267,"_268":269,"_270":271,"_272":273,"_274":275,"_276":277,"_278":279,"_280":281,"_282":283,"_284":285,"_286":287,"_288":289},"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 · v20