[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_301":302,"_303":304},"routes/_app.x.$handle.$name",{"_94":93,"_31":43,"_102":84,"_26":103,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":24,"_117":118,"_119":56,"_120":-5,"_121":-5,"_122":123},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":30,"_55":56,"_57":56,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":24},"version",42,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","api.ts","latestPath","fileId","cfeb2b1c-c8d8-11f0-8358-42dde27851f2","name","fileType","script","content","import { Hono } from \"https://esm.sh/hono@latest\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nimport { checkSchema, createSchema } from \"./schema.ts\";\n\nconst app = new Hono();\n\nconst VALID_TASK_TYPES = [\n\t\"send_email\",\n\t\"webhook\",\n\t\"log_message\",\n\t\"http_request\",\n] as const;\n\ntype TaskType = (typeof VALID_TASK_TYPES)[number];\n\napp.get(\"/schema\", async (c) => {\n\ttry {\n\t\tconst exists = await checkSchema();\n\t\tif (exists) {\n\t\t\treturn c.json({ success: true, message: \"Queue schema already exists\" });\n\t\t}\n\t\tconst result = await createSchema();\n\t\treturn c.json(result);\n\t} catch (error) {\n\t\tif (error instanceof Error) {\n\t\t\treturn c.json({ success: false, error: error.message }, 500);\n\t\t}\n\t\treturn c.json(\n\t\t\t{\n\t\t\t\tsuccess: false,\n\t\t\t\terror: `Unknown error occurred during schema initialization: ${error}`,\n\t\t\t},\n\t\t\t500,\n\t\t);\n\t}\n});\n\napp.post(\"/enqueue\", async (c) => {\n\tconst body = await c.req.json();\n\tconst {\n\t\ttask_type,\n\t\tpayload,\n\t\tpriority = 0,\n\t\tmax_attempts = 3,\n\t\tscheduled_for = null,\n\t} = body;\n\n\ttry {\n\t\tif (!task_type) {\n\t\t\treturn c.json({ error: \"task_type is required\" }, 400);\n\t\t}\n\n\t\tif (!VALID_TASK_TYPES.includes(task_type)) {\n\t\t\treturn Response.json(\n\t\t\t\t{\n\t\t\t\t\terror: `Invalid task_type. Must be one of: ${VALID_TASK_TYPES.join(\", \")}`,\n\t\t\t\t\tvalid_types: VALID_TASK_TYPES,\n\t\t\t\t},\n\t\t\t\t{ status: 400 },\n\t\t\t);\n\t\t}\n\n\t\tif (payload === undefined) {\n\t\t\treturn c.json({ error: \"payload is required\" }, 400);\n\t\t}\n\n\t\tconst result = await sqlite.execute({\n\t\t\tsql: `INSERT INTO queue (task_type, payload, priority, max_attempts, scheduled_for)\n VALUES (?, ?, ?, ?, ?)`,\n\t\t\targs: [\n\t\t\t\ttask_type,\n\t\t\t\tJSON.stringify(payload),\n\t\t\t\tpriority,\n\t\t\t\tmax_attempts,\n\t\t\t\tscheduled_for,\n\t\t\t],\n\t\t});\n\n\t\treturn c.json({\n\t\t\tsuccess: true,\n\t\t\ttask_id: result.lastInsertRowid?.toString(),\n\t\t\tstatus: scheduled_for ? \"scheduled\" : \"queued\",\n\t\t\tscheduled_for: scheduled_for\n\t\t\t\t? new Date(scheduled_for * 1000).toISOString()\n\t\t\t\t: null,\n\t\t});\n\t} catch (error) {\n\t\tconsole.error(\"Error enqueueing task:\", error);\n\t\treturn c.json({ error: error.message }, 500);\n\t}\n});\n\napp.get(\"/monitor\", async (c) => {\n\ttry {\n\t\t// Get overall stats\n\t\tconst statsResult = await sqlite.execute(`\n SELECT\n status,\n COUNT(*) as count,\n AVG(CASE\n WHEN completed_at IS NOT NULL AND started_at IS NOT NULL\n THEN completed_at - started_at\n ELSE NULL\n END) as avg_duration_seconds\n FROM queue\n GROUP BY status\n `);\n\n\t\tconst stats: Record<\n\t\t\tstring,\n\t\t\t{ count: number; avg_duration_seconds: number | null }\n\t\t> = {};\n\t\tfor (const row of statsResult.rows) {\n\t\t\tstats[String(row[0])] = {\n\t\t\t\tcount: Number(row[1]),\n\t\t\t\tavg_duration_seconds: row[2]\n\t\t\t\t\t? Math.round(Number(row[2]) * 100) / 100\n\t\t\t\t\t: null,\n\t\t\t};\n\t\t}\n\n\t\t// Get task type breakdown\n\t\tconst taskTypesResult = await sqlite.execute(`\n SELECT task_type, COUNT(*) as count\n FROM queue\n GROUP BY task_type\n ORDER BY count DESC\n `);\n\n\t\tconst taskTypes: Record =\n\t\t\ttaskTypesResult.rows.reduce(\n\t\t\t\t(acc, row) => {\n\t\t\t\t\tacc[String(row[0]) as TaskType] = { count: Number(row[1]) };\n\t\t\t\t\treturn acc;\n\t\t\t\t},\n\t\t\t\t{} as Record,\n\t\t\t);\n\n\t\tconst dlqResult = await sqlite.execute(\n\t\t\t`SELECT COUNT(*) as count FROM dead_letter_queue`,\n\t\t);\n\n\t\tconst dlqCount = Number(dlqResult.rows[0][0]);\n\n\t\tconst recentFailedResult = await sqlite.execute(`\n SELECT id, task_type, error, attempts, created_at\n FROM dead_letter_queue\n ORDER BY moved_to_dlq_at DESC\n LIMIT 5\n `);\n\n\t\tconst recentFailed: {\n\t\t\tid: number;\n\t\t\ttask_type: TaskType;\n\t\t\terror: string;\n\t\t\tattempts: number;\n\t\t\tcreated_at: string | null;\n\t\t}[] = recentFailedResult.rows.map((row) => ({\n\t\t\tid: Number(row[0]),\n\t\t\ttask_type: String(row[1]) as TaskType,\n\t\t\terror: String(row[2] || \"\"),\n\t\t\tattempts: Number(row[3]),\n\t\t\tcreated_at: row[4] ? new Date(Number(row[4]) * 1000).toISOString() : null,\n\t\t}));\n\n\t\t// Get upcoming scheduled tasks\n\t\tconst scheduledResult = await sqlite.execute(`\n SELECT id, task_type, scheduled_for, priority\n FROM queue\n WHERE scheduled_for IS NOT NULL AND status = 'pending'\n ORDER BY scheduled_for ASC\n LIMIT 10\n `);\n\n\t\tconst scheduled: {\n\t\t\tid: number;\n\t\t\ttask_type: TaskType;\n\t\t\tscheduled_for: string | null;\n\t\t\tpriority: number;\n\t\t}[] = scheduledResult.rows.map((row) => ({\n\t\t\tid: Number(row[0]),\n\t\t\ttask_type: String(row[1]) as TaskType,\n\t\t\tscheduled_for: row[2]\n\t\t\t\t? new Date(Number(row[2]) * 1000).toISOString()\n\t\t\t\t: null,\n\t\t\tpriority: Number(row[3]),\n\t\t}));\n\n\t\treturn c.json(\n\t\t\t{\n\t\t\t\ttimestamp: new Date().toISOString(),\n\t\t\t\tstats,\n\t\t\t\ttask_types: taskTypes,\n\t\t\t\tdead_letter_queue: {\n\t\t\t\t\tcount: dlqCount,\n\t\t\t\t\trecent: recentFailed,\n\t\t\t\t},\n\t\t\t\tscheduled_tasks: scheduled,\n\t\t\t},\n\t\t\t200,\n\t\t);\n\t} catch (error) {\n\t\tconsole.error(\"Error fetching monitor data:\", error);\n\t\treturn c.json({ error: error.message }, 500);\n\t}\n});\n\nexport default app.fetch;\n","createdAt",["D",1763949397510],"branchVersion","branchId","a11a5c9c-c8cc-11f0-b211-42dde27851f2","id","a11a0396-c8cc-11f0-b211-42dde27851f2","lightweightQueue",["D",1763944165015],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","SQLite-based queue system for Val Town","imageUrl","5d1042a9-7b0b-499d-8a72-3a8ac7a4e185","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","5f80108f-7ca4-4327-b77b-089dbe4b5a82","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":53,"_98":99,"_100":24},"branch",{"_13":83,"_31":84,"_41":40,"_85":42,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":43,"_92":93},"isOwned",78,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","nbbaier","handle","displayName","avatar","https://secure.gravatar.com/avatar/0129a541b7b3574e92c4afd06c5e32da&d=identicon","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_41":42,"_31":43,"_36":297,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":30,"_55":56,"_57":56,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":298,"_78":299,"_80":300,"_82":24},"tree",[244,245,246,247,248,249,250,251,252,253,254,255,256],"files",[244,245,246,247,248,249,250,251,252,253,254,255,256],"counts",{"_234":60,"_235":170,"_236":60,"_237":238,"_239":240},"contents",[124,125,126,127,128,129,130,131,132,133,134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":227,"_31":228,"_29":229,"_140":-5,"_39":40,"_38":230,"_142":56,"_36":231,"_13":60,"_32":20,"_34":232,"_23":24,"_147":-5,"_26":233},{"_41":220,"_31":221,"_29":222,"_140":-5,"_39":40,"_38":223,"_142":56,"_36":224,"_13":170,"_32":20,"_34":225,"_23":24,"_147":-5,"_26":226},{"_41":213,"_31":214,"_29":215,"_140":-5,"_39":40,"_38":216,"_142":24,"_36":217,"_13":144,"_32":20,"_34":218,"_23":24,"_147":-5,"_26":219},{"_41":206,"_31":207,"_29":208,"_140":-5,"_39":40,"_38":209,"_142":24,"_36":210,"_13":161,"_32":20,"_34":211,"_23":24,"_147":-5,"_26":212},{"_41":202,"_31":27,"_29":30,"_140":-5,"_39":40,"_38":14,"_142":24,"_36":203,"_13":60,"_32":33,"_34":35,"_23":24,"_147":204,"_26":205},{"_41":195,"_31":196,"_29":197,"_140":-5,"_39":40,"_38":198,"_142":56,"_36":199,"_13":60,"_32":20,"_34":200,"_23":24,"_147":-5,"_26":201},{"_41":188,"_31":189,"_29":190,"_140":-5,"_39":40,"_38":191,"_142":24,"_36":192,"_13":170,"_32":20,"_34":193,"_23":24,"_147":-5,"_26":194},{"_41":180,"_31":181,"_29":182,"_140":-5,"_39":40,"_38":183,"_142":24,"_36":184,"_13":185,"_32":162,"_34":186,"_23":24,"_147":-5,"_26":187},{"_41":173,"_31":174,"_29":175,"_140":-5,"_39":40,"_38":176,"_142":24,"_36":177,"_13":144,"_32":162,"_34":178,"_23":24,"_147":-5,"_26":179},{"_41":165,"_31":166,"_29":167,"_140":-5,"_39":40,"_38":168,"_142":24,"_36":169,"_13":170,"_32":33,"_34":171,"_23":24,"_147":-5,"_26":172},{"_41":156,"_31":157,"_29":158,"_140":-5,"_39":40,"_38":159,"_142":24,"_36":160,"_13":161,"_32":162,"_34":163,"_23":24,"_147":-5,"_26":164},{"_41":149,"_31":150,"_29":151,"_140":-5,"_39":40,"_38":152,"_142":56,"_36":153,"_13":144,"_32":33,"_34":154,"_23":24,"_147":-5,"_26":155},{"_41":137,"_31":138,"_29":139,"_140":-5,"_39":40,"_38":141,"_142":24,"_36":143,"_13":144,"_32":145,"_34":146,"_23":24,"_147":-5,"_26":148},"1535c40e-c8d2-11f0-86fc-42dde27851f2","worker.ts","03b2afe4-c8cd-11f0-98d4-42dde27851f2","parentId",34,"latest",["D",1763946506656],2,"interval","import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { processTask } from \"./processors.ts\";\n\n/**\n * Queue worker - runs every minute to process pending tasks\n * This is an interval val that automatically runs on a schedule\n */\nexport default async function () {\n\tconsole.log(\"Queue worker starting...\");\n\n\ttry {\n\t\t// Fetch pending tasks that are ready to process\n\t\tconst result = await sqlite.execute(`\n SELECT id, task_type, payload, status, attempts, max_attempts\n FROM queue \n WHERE status = 'pending' \n AND attempts < max_attempts\n AND (scheduled_for IS NULL OR scheduled_for <= unixepoch())\n ORDER BY priority DESC, created_at ASC \n LIMIT 10\n `);\n\n\t\tconst tasks = result.rows;\n\n\t\tif (tasks.length === 0) {\n\t\t\tconsole.log(\"No tasks to process\");\n\t\t\treturn { processed: 0, success: 0, failed: 0 };\n\t\t}\n\n\t\tconsole.log(`Found ${tasks.length} tasks to process`);\n\n\t\tlet successCount = 0;\n\t\tlet failCount = 0;\n\n\t\tfor (const row of tasks) {\n\t\t\tconst task = {\n\t\t\t\tid: Number(row[0]),\n\t\t\t\ttask_type: String(row[1]),\n\t\t\t\tpayload: JSON.parse(String(row[2])),\n\t\t\t\tstatus: String(row[3]),\n\t\t\t\tattempts: Number(row[4]),\n\t\t\t\tmax_attempts: Number(row[5]),\n\t\t\t};\n\n\t\t\t// Mark as processing\n\t\t\tawait sqlite.execute({\n\t\t\t\tsql: `UPDATE queue \n SET status = 'processing', \n started_at = unixepoch(), \n attempts = attempts + 1 \n WHERE id = ?`,\n\t\t\t\targs: [task.id],\n\t\t\t});\n\n\t\t\ttry {\n\t\t\t\t// Process the task\n\t\t\t\tawait processTask(task);\n\n\t\t\t\t// Mark as completed\n\t\t\t\tawait sqlite.execute({\n\t\t\t\t\tsql: `UPDATE queue \n SET status = 'completed', \n completed_at = unixepoch() \n WHERE id = ?`,\n\t\t\t\t\targs: [task.id],\n\t\t\t\t});\n\n\t\t\t\tconsole.log(`Task ${task.id} completed successfully`);\n\t\t\t\tsuccessCount++;\n\t\t\t} catch (error) {\n\t\t\t\tconsole.error(`Task ${task.id} failed:`, error.message);\n\n\t\t\t\t// Check if max attempts reached\n\t\t\t\tconst newAttempts = task.attempts + 1;\n\t\t\t\tconst maxReached = newAttempts >= task.max_attempts;\n\n\t\t\t\tif (maxReached) {\n\t\t\t\t\t// Move to dead letter queue\n\t\t\t\t\tawait sqlite.batch([\n\t\t\t\t\t\t{\n\t\t\t\t\t\t\tsql: `INSERT INTO dead_letter_queue \n SELECT id, task_type, payload, status, created_at, started_at, \n completed_at, attempts, max_attempts, priority, ?, unixepoch()\n FROM queue WHERE id = ?`,\n\t\t\t\t\t\t\targs: [error.message, task.id],\n\t\t\t\t\t\t},\n\t\t\t\t\t\t{\n\t\t\t\t\t\t\tsql: `DELETE FROM queue WHERE id = ?`,\n\t\t\t\t\t\t\targs: [task.id],\n\t\t\t\t\t\t},\n\t\t\t\t\t]);\n\n\t\t\t\t\tconsole.log(`Task ${task.id} moved to dead letter queue`);\n\t\t\t\t} else {\n\t\t\t\t\t// Mark as failed (will retry on next run)\n\t\t\t\t\tawait sqlite.execute({\n\t\t\t\t\t\tsql: `UPDATE queue \n SET status = 'pending', \n error = ? \n WHERE id = ?`,\n\t\t\t\t\t\targs: [error.message, task.id],\n\t\t\t\t\t});\n\t\t\t\t}\n\n\t\t\t\tfailCount++;\n\t\t\t}\n\t\t}\n\n\t\tconst summary = {\n\t\t\tprocessed: tasks.length,\n\t\t\tsuccess: successCount,\n\t\t\tfailed: failCount,\n\t\t};\n\n\t\tconsole.log(\"Worker completed:\", summary);\n\t\treturn summary;\n\t} catch (error) {\n\t\tconsole.error(\"Worker error:\", error);\n\t\tthrow error;\n\t}\n}\n","label",[138],"f6d50934-c8d1-11f0-aefb-42dde27851f2","test.ts","3871c642-c8ce-11f0-a873-42dde27851f2",25,["D",1763946456294],"/**\n * Test the queue system by enqueueing a few tasks\n */\nexport default async function () {\n\tconst enqueueUrl =\n\t\t\"https://nbbaier--c5bd3e20c8cc11f0a88c42dde27851f2.web.val.run\";\n\n\t// Test 1: Simple log message\n\tconst test1 = await fetch(enqueueUrl, {\n\t\tmethod: \"POST\",\n\t\theaders: { \"Content-Type\": \"application/json\" },\n\t\tbody: JSON.stringify({\n\t\t\ttask_type: \"log_message\",\n\t\t\tpayload: {\n\t\t\t\tmessage: \"Testing the queue system!\",\n\t\t\t\tlevel: \"info\",\n\t\t\t},\n\t\t}),\n\t});\n\n\tconst result1 = await test1.json();\n\tconsole.log(\"Test 1 (log_message):\", result1);\n\n\t// Test 2: High priority task\n\tconst test2 = await fetch(enqueueUrl, {\n\t\tmethod: \"POST\",\n\t\theaders: { \"Content-Type\": \"application/json\" },\n\t\tbody: JSON.stringify({\n\t\t\ttask_type: \"log_message\",\n\t\t\tpayload: {\n\t\t\t\tmessage: \"High priority task!\",\n\t\t\t\tlevel: \"warn\",\n\t\t\t},\n\t\t\tpriority: 10,\n\t\t}),\n\t});\n\n\tconst result2 = await test2.json();\n\tconsole.log(\"Test 2 (high priority):\", result2);\n\n\t// Test 3: Scheduled task (30 seconds from now)\n\tconst scheduledTime = Math.floor(Date.now() / 1000) + 30;\n\tconst test3 = await fetch(enqueueUrl, {\n\t\tmethod: \"POST\",\n\t\theaders: { \"Content-Type\": \"application/json\" },\n\t\tbody: JSON.stringify({\n\t\t\ttask_type: \"log_message\",\n\t\t\tpayload: {\n\t\t\t\tmessage: \"This was scheduled for 30 seconds in the future!\",\n\t\t\t\tlevel: \"info\",\n\t\t\t},\n\t\t\tscheduled_for: scheduledTime,\n\t\t}),\n\t});\n\n\tconst result3 = await test3.json();\n\tconsole.log(\"Test 3 (scheduled):\", result3);\n\n\treturn {\n\t\ttest1: result1,\n\t\ttest2: result2,\n\t\ttest3: result3,\n\t\tmessage:\n\t\t\t\"All tests completed! Check the monitor endpoint to see queue status.\",\n\t};\n}\n",[150],"14d48a68-c8d2-11f0-9f0b-42dde27851f2","schema.ts","ba92dd0c-c8cc-11f0-9798-42dde27851f2",30,["D",1763946506645],4,"http","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n/**\n * Initialize the queue database schema\n * Visit this endpoint to set up your queue tables\n */\nexport default async function (_req: Request): Promise {\n\ttry {\n\t\t// Create the main queue table\n\t\tawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS queue (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n task_type TEXT NOT NULL,\n payload TEXT NOT NULL,\n status TEXT DEFAULT 'pending',\n created_at INTEGER DEFAULT (unixepoch()),\n started_at INTEGER,\n completed_at INTEGER,\n scheduled_for INTEGER,\n attempts INTEGER DEFAULT 0,\n max_attempts INTEGER DEFAULT 3,\n priority INTEGER DEFAULT 0,\n error TEXT\n )\n `);\n\n\t\t// Create indexes for efficient queries\n\t\tawait sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_status_priority \n ON queue(status, priority DESC, created_at)\n `);\n\n\t\tawait sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_scheduled \n ON queue(scheduled_for) \n WHERE scheduled_for IS NOT NULL\n `);\n\n\t\t// Create dead letter queue table\n\t\tawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS dead_letter_queue (\n id INTEGER PRIMARY KEY,\n task_type TEXT NOT NULL,\n payload TEXT NOT NULL,\n status TEXT,\n created_at INTEGER,\n started_at INTEGER,\n completed_at INTEGER,\n attempts INTEGER,\n max_attempts INTEGER,\n priority INTEGER,\n error TEXT,\n moved_to_dlq_at INTEGER DEFAULT (unixepoch())\n )\n `);\n\n\t\tconsole.log(\"Queue schema initialized successfully!\");\n\n\t\treturn Response.json({\n\t\t\tsuccess: true,\n\t\t\tmessage: \"Queue schema initialized successfully!\",\n\t\t\ttables: [\"queue\", \"dead_letter_queue\"],\n\t\t});\n\t} catch (error) {\n\t\tconsole.error(\"Schema initialization error:\", error);\n\t\treturn Response.json(\n\t\t\t{ success: false, error: error.message },\n\t\t\t{ status: 500 },\n\t\t);\n\t}\n}\n",[157],"14de1506-c8d2-11f0-a369-42dde27851f2","processors.ts","f6681cde-c8cc-11f0-979e-42dde27851f2",31,["D",1763946506644],1,"import { email } from \"https://esm.town/v/std/email\";\n\n/**\n * Task processors for different task types\n * Add your own task processors here\n */\n\nexport interface Task {\n\tid: number;\n\ttask_type: string;\n\tpayload: any;\n\tstatus: string;\n\tattempts: number;\n\tmax_attempts: number;\n}\n\nexport async function processTask(task: Task): Promise {\n\tconst { task_type, payload } = task;\n\n\tconsole.log(`Processing task ${task.id} of type: ${task_type}`);\n\n\tswitch (task_type) {\n\t\tcase \"send_email\":\n\t\t\tawait processSendEmail(payload);\n\t\t\tbreak;\n\n\t\tcase \"webhook\":\n\t\t\tawait processWebhook(payload);\n\t\t\tbreak;\n\n\t\tcase \"log_message\":\n\t\t\tawait processLogMessage(payload);\n\t\t\tbreak;\n\n\t\tcase \"http_request\":\n\t\t\tawait processHttpRequest(payload);\n\t\t\tbreak;\n\n\t\tdefault:\n\t\t\tthrow new Error(`Unknown task type: ${task_type}`);\n\t}\n}\n\nasync function processSendEmail(payload: any) {\n\tconst { to, subject, text } = payload;\n\n\tif (!to || !subject || !text) {\n\t\tthrow new Error(\"Email requires: to, subject, text\");\n\t}\n\n\tawait email.send({\n\t\tto,\n\t\tsubject,\n\t\ttext,\n\t});\n\n\tconsole.log(`Email sent to ${to}`);\n}\n\nasync function processWebhook(payload: any) {\n\tconst { url, method = \"POST\", body, headers = {} } = payload;\n\n\tif (!url) {\n\t\tthrow new Error(\"Webhook requires url\");\n\t}\n\n\tconst response = await fetch(url, {\n\t\tmethod,\n\t\theaders: {\n\t\t\t\"Content-Type\": \"application/json\",\n\t\t\t...headers,\n\t\t},\n\t\tbody: body ? JSON.stringify(body) : undefined,\n\t});\n\n\tif (!response.ok) {\n\t\tthrow new Error(\n\t\t\t`Webhook failed: ${response.status} ${response.statusText}`,\n\t\t);\n\t}\n\n\tconsole.log(`Webhook sent to ${url}`);\n}\n\nasync function processLogMessage(payload: any) {\n\tconst { message, level = \"info\" } = payload;\n\tconsole.log(`[${level.toUpperCase()}] ${message}`);\n}\n\nasync function processHttpRequest(payload: any) {\n\tconst { url, method = \"GET\", body, headers = {} } = payload;\n\n\tif (!url) {\n\t\tthrow new Error(\"HTTP request requires url\");\n\t}\n\n\tconst response = await fetch(url, {\n\t\tmethod,\n\t\theaders,\n\t\tbody: body ? JSON.stringify(body) : undefined,\n\t});\n\n\tif (!response.ok) {\n\t\tthrow new Error(\n\t\t\t`HTTP request failed: ${response.status} ${response.statusText}`,\n\t\t);\n\t}\n\n\tconsole.log(`HTTP ${method} request to ${url} completed`);\n}\n",[166],"14d19a4c-c8d2-11f0-906c-42dde27851f2","monitor.ts","20366bc4-c8cd-11f0-ba6f-42dde27851f2",29,["D",1763946506636],"import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n/**\n * Monitoring endpoint for queue statistics\n * GET /monitor\n */\nexport default async function (_req: Request): Promise {\n\ttry {\n\t\t// Get overall stats\n\t\tconst statsResult = await sqlite.execute(`\n SELECT \n status,\n COUNT(*) as count,\n AVG(CASE \n WHEN completed_at IS NOT NULL AND started_at IS NOT NULL \n THEN completed_at - started_at \n ELSE NULL \n END) as avg_duration_seconds\n FROM queue\n GROUP BY status\n `);\n\n\t\tconst stats: Record = {};\n\t\tfor (const row of statsResult.rows) {\n\t\t\tstats[String(row[0])] = {\n\t\t\t\tcount: Number(row[1]),\n\t\t\t\tavg_duration_seconds: row[2]\n\t\t\t\t\t? Math.round(Number(row[2]) * 100) / 100\n\t\t\t\t\t: null,\n\t\t\t};\n\t\t}\n\n\t\t// Get task type breakdown\n\t\tconst taskTypesResult = await sqlite.execute(`\n SELECT task_type, COUNT(*) as count\n FROM queue\n GROUP BY task_type\n ORDER BY count DESC\n `);\n\n\t\tconst taskTypes = taskTypesResult.rows.map((row) => ({\n\t\t\ttype: String(row[0]),\n\t\t\tcount: Number(row[1]),\n\t\t}));\n\n\t\t// Get dead letter queue count\n\t\tconst dlqResult = await sqlite.execute(\n\t\t\t`SELECT COUNT(*) as count FROM dead_letter_queue`,\n\t\t);\n\t\tconst dlqCount = Number(dlqResult.rows[0][0]);\n\n\t\t// Get recent failed tasks\n\t\tconst recentFailedResult = await sqlite.execute(`\n SELECT id, task_type, error, attempts, created_at\n FROM dead_letter_queue\n ORDER BY moved_to_dlq_at DESC\n LIMIT 5\n `);\n\n\t\tconst recentFailed = recentFailedResult.rows.map((row) => ({\n\t\t\tid: Number(row[0]),\n\t\t\ttask_type: String(row[1]),\n\t\t\terror: String(row[2] || \"\"),\n\t\t\tattempts: Number(row[3]),\n\t\t\tcreated_at: row[4] ? new Date(Number(row[4]) * 1000).toISOString() : null,\n\t\t}));\n\n\t\t// Get upcoming scheduled tasks\n\t\tconst scheduledResult = await sqlite.execute(`\n SELECT id, task_type, scheduled_for, priority\n FROM queue\n WHERE scheduled_for IS NOT NULL AND status = 'pending'\n ORDER BY scheduled_for ASC\n LIMIT 10\n `);\n\n\t\tconst scheduled = scheduledResult.rows.map((row) => ({\n\t\t\tid: Number(row[0]),\n\t\t\ttask_type: String(row[1]),\n\t\t\tscheduled_for: row[2]\n\t\t\t\t? new Date(Number(row[2]) * 1000).toISOString()\n\t\t\t\t: null,\n\t\t\tpriority: Number(row[3]),\n\t\t}));\n\n\t\treturn Response.json(\n\t\t\t{\n\t\t\t\ttimestamp: new Date().toISOString(),\n\t\t\t\tstats,\n\t\t\t\ttask_types: taskTypes,\n\t\t\t\tdead_letter_queue: {\n\t\t\t\t\tcount: dlqCount,\n\t\t\t\t\trecent: recentFailed,\n\t\t\t\t},\n\t\t\t\tscheduled_tasks: scheduled,\n\t\t\t},\n\t\t\t{\n\t\t\t\theaders: {\n\t\t\t\t\t\"Content-Type\": \"application/json\",\n\t\t\t\t},\n\t\t\t},\n\t\t);\n\t} catch (error) {\n\t\tconsole.error(\"Error fetching monitor data:\", error);\n\t\treturn Response.json({ error: error.message }, { status: 500 });\n\t}\n}\n",[174],"14e9c4be-c8d2-11f0-9f0b-42dde27851f2","enqueue.ts","c5bd3e20-c8cc-11f0-a88c-42dde27851f2",32,["D",1763946506795],3,"import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n/**\n * HTTP endpoint to enqueue tasks\n *\n * POST /enqueue\n * Body: {\n * task_type: string,\n * payload: any,\n * priority?: number (default: 0, higher = more important),\n * max_attempts?: number (default: 3),\n * scheduled_for?: number (unix timestamp, optional - for delayed execution)\n * }\n */\nexport default async function (req: Request): Promise {\n\tif (req.method !== \"POST\") {\n\t\treturn Response.json(\n\t\t\t{ error: \"Method not allowed. Use POST.\" },\n\t\t\t{ status: 405 },\n\t\t);\n\t}\n\n\ttry {\n\t\tconst body = await req.json();\n\t\tconst {\n\t\t\ttask_type,\n\t\t\tpayload,\n\t\t\tpriority = 0,\n\t\t\tmax_attempts = 3,\n\t\t\tscheduled_for = null,\n\t\t} = body;\n\n\t\t// Validate required fields\n\t\tif (!task_type) {\n\t\t\treturn Response.json({ error: \"task_type is required\" }, { status: 400 });\n\t\t}\n\n\t\t// Validate task type\n\t\tconst VALID_TASK_TYPES = [\n\t\t\t\"send_email\",\n\t\t\t\"webhook\",\n\t\t\t\"log_message\",\n\t\t\t\"http_request\",\n\t\t];\n\t\tif (!VALID_TASK_TYPES.includes(task_type)) {\n\t\t\treturn Response.json(\n\t\t\t\t{\n\t\t\t\t\terror: `Invalid task_type. Must be one of: ${VALID_TASK_TYPES.join(\", \")}`,\n\t\t\t\t\tvalid_types: VALID_TASK_TYPES,\n\t\t\t\t},\n\t\t\t\t{ status: 400 },\n\t\t\t);\n\t\t}\n\n\t\tif (payload === undefined) {\n\t\t\treturn Response.json({ error: \"payload is required\" }, { status: 400 });\n\t\t}\n\n\t\t// Insert task into queue\n\t\tconst result = await sqlite.execute({\n\t\t\tsql: `INSERT INTO queue (task_type, payload, priority, max_attempts, scheduled_for)\n VALUES (?, ?, ?, ?, ?)`,\n\t\t\targs: [\n\t\t\t\ttask_type,\n\t\t\t\tJSON.stringify(payload),\n\t\t\t\tpriority,\n\t\t\t\tmax_attempts,\n\t\t\t\tscheduled_for,\n\t\t\t],\n\t\t});\n\n\t\treturn Response.json({\n\t\t\tsuccess: true,\n\t\t\ttask_id: result.lastInsertRowid?.toString(),\n\t\t\tstatus: scheduled_for ? \"scheduled\" : \"queued\",\n\t\t\tscheduled_for: scheduled_for\n\t\t\t\t? new Date(scheduled_for * 1000).toISOString()\n\t\t\t\t: null,\n\t\t});\n\t} catch (error) {\n\t\tconsole.error(\"Error enqueueing task:\", error);\n\t\treturn Response.json({ error: error.message }, { status: 500 });\n\t}\n}\n",[181],"1503e6aa-c8d2-11f0-b747-42dde27851f2","deno.json","f6c357b6-c8d1-11f0-99b0-42dde27851f2",33,["D",1763946506648],"{\n\t\"$schema\": \"https://raw.githubusercontent.com/denoland/deno/348900b8b79f4a434cab4c74b3bc8d4d2fa8ee74/cli/schemas/config-file.v1.json\",\n\t\"compilerOptions\": {\n\t\t\"lib\": [\n\t\t\t\"dom\",\n\t\t\t\"dom.iterable\",\n\t\t\t\"dom.asynciterable\",\n\t\t\t\"deno.ns\",\n\t\t\t\"deno.unstable\"\n\t\t],\n\t\t\"noImplicitAny\": false,\n\t\t\"strict\": false,\n\t\t\"types\": [\"https://www.val.town/types/valtown.d.ts\"]\n\t},\n\t\"experimental\": {\n\t\t\"unstable-node-globals\": true,\n\t\t\"unstable-sloppy-imports\": true,\n\t\t\"unstable-temporal\": true,\n\t\t\"unstable-worker-options\": true\n\t},\n\t\"imports\": {\n\t\t\"@biomejs/biome\": \"npm:@biomejs/biome@^2.3.7\"\n\t},\n\t\"lint\": {\n\t\t\"files\": {\n\t\t\t\"include\": [\"deno:/https/esm.town/**/*\"]\n\t\t},\n\t\t\"rules\": {\n\t\t\t\"exclude\": [\"no-explicit-any\", \"no-import-prefix\"]\n\t\t}\n\t},\n\t\"lock\": false,\n\t\"nodeModulesDir\": \"auto\"\n}\n",[189],"f6ddc4b6-c8d1-11f0-91f3-42dde27851f2","biome.json","f6ddc588-c8d1-11f0-91f3-42dde27851f2",26,["D",1763946456231],"{\n\t\"$schema\": \"https://biomejs.dev/schemas/2.3.7/schema.json\",\n\t\"vcs\": {\n\t\t\"enabled\": false,\n\t\t\"clientKind\": \"git\",\n\t\t\"useIgnoreFile\": false\n\t},\n\t\"files\": {\n\t\t\"ignoreUnknown\": false\n\t},\n\t\"formatter\": {\n\t\t\"enabled\": true,\n\t\t\"indentStyle\": \"tab\"\n\t},\n\t\"linter\": {\n\t\t\"enabled\": true,\n\t\t\"rules\": {\n\t\t\t\"recommended\": true\n\t\t}\n\t},\n\t\"javascript\": {\n\t\t\"formatter\": {\n\t\t\t\"quoteStyle\": \"double\"\n\t\t}\n\t},\n\t\"assist\": {\n\t\t\"enabled\": true,\n\t\t\"actions\": {\n\t\t\t\"source\": {\n\t\t\t\t\"organizeImports\": \"on\"\n\t\t\t}\n\t\t}\n\t}\n}\n",[196],"cfeb2a7c-c8d8-11f0-8358-42dde27851f2",["D",1763949397510],"lqw",[27],"f4615082-c8d0-11f0-8873-42dde27851f2","README.md","41df3cf6-c8cd-11f0-83d5-42dde27851f2",21,["D",1763946022715],"# Lightweight Queue System\n\nA SQLite-based queue system for Val Town with support for priorities, delayed\nexecution, retries, and dead letter queue.\n\n## Setup\n\n1. **Initialize the database schema** (run once):\n\n```bash\n# Visit the schema.ts val and run it\nhttps://www.val.town/v/nbbaier/lightweightQueue/schema.ts\n```\n\n2. **The worker will automatically run every minute** to process queued tasks\n\n## Usage\n\n### Enqueue a Task\n\nPOST to the `enqueue.ts` endpoint:\n\n```bash\ncurl -X POST https://lightweightqueue-enqueue.val.run/ \\\n -H \"Content-Type: application/json\" \\\n -d '{\n \"task_type\": \"log_message\",\n \"payload\": {\n \"message\": \"Hello from the queue!\",\n \"level\": \"info\"\n }\n }'\n```\n\n### Task Options\n\n- `task_type` (required): Type of task to run\n- `payload` (required): Data for the task\n- `priority` (optional, default: 0): Higher numbers = higher priority\n- `max_attempts` (optional, default: 3): Max retry attempts\n- `scheduled_for` (optional): Unix timestamp for delayed execution\n\n### Available Task Types\n\nBuilt-in task types in `processors.ts`:\n\n1. **send_email**\n\n```json\n{\n \"task_type\": \"send_email\",\n \"payload\": {\n \"to\": \"user@example.com\",\n \"subject\": \"Test Email\",\n \"text\": \"This is a test\"\n }\n}\n```\n\n2. **webhook**\n\n```json\n{\n \"task_type\": \"webhook\",\n \"payload\": {\n \"url\": \"https://example.com/webhook\",\n \"method\": \"POST\",\n \"body\": { \"data\": \"value\" },\n \"headers\": { \"Authorization\": \"Bearer token\" }\n }\n}\n```\n\n3. **log_message**\n\n```json\n{\n \"task_type\": \"log_message\",\n \"payload\": {\n \"message\": \"Something happened\",\n \"level\": \"info\"\n }\n}\n```\n\n4. **http_request**\n\n```json\n{\n \"task_type\": \"http_request\",\n \"payload\": {\n \"url\": \"https://api.example.com/data\",\n \"method\": \"GET\"\n }\n}\n```\n\n### Priority Example\n\n```bash\ncurl -X POST https://lightweightqueue-enqueue.val.run/ \\\n -H \"Content-Type: application/json\" \\\n -d '{\n \"task_type\": \"log_message\",\n \"payload\": { \"message\": \"High priority task!\" },\n \"priority\": 10\n }'\n```\n\n### Delayed Execution Example\n\n```bash\n# Schedule task for 1 hour from now\nSCHEDULED_TIME=$(($(date +%s) + 3600))\n\ncurl -X POST https://lightweightqueue-enqueue.val.run/\n\n\n\n\n\\\n -H \"Content-Type: application/json\" \\\n -d \"{\n \\\"task_type\\\": \\\"log_message\\\",\n \\\"payload\\\": { \\\"message\\\": \\\"This is delayed!\\\" },\n \\\"scheduled_for\\\": $SCHEDULED_TIME\n }\"\n```\n\n### Monitor the Queue\n\nVisit the monitoring endpoint:\n\n```\nhttps://lightweightqueue-monitor.val.run/\n```\n\nThis shows:\n\n- Task counts by status\n- Average processing duration\n- Task type breakdown\n- Dead letter queue count\n- Recent failures\n- Upcoming scheduled tasks\n\n## Adding Custom Task Types\n\nEdit `processors.ts` and add a new case to the `processTask` function:\n\n```typescript\ncase \"my_custom_task\":\n await processMyCustomTask(payload);\n break;\n```\n\nThen implement your processor function:\n\n```typescript\nasync function processMyCustomTask(payload: any) {\n // Your custom logic here\n console.log(\"Processing custom task:\", payload);\n}\n```\n\n## Architecture\n\n- **schema.ts**: Database initialization\n- **enqueue.ts**: HTTP endpoint to add tasks\n- **worker.ts**: Interval val that processes tasks every minute\n- **processors.ts**: Task processing logic\n- **monitor.ts**: HTTP endpoint for queue statistics\n\n## Features\n\n- ✅ Priority-based processing\n- ✅ Delayed/scheduled execution\n- ✅ Automatic retries with configurable max attempts\n- ✅ Dead letter queue for failed tasks\n- ✅ Task status tracking (pending, processing, completed, failed)\n- ✅ Built-in monitoring endpoint\n- ✅ Processing duration tracking\n- ✅ Extensible task processors\n\n## Notes\n\n- Worker processes up to 10 tasks per minute\n- Failed tasks are retried up to `max_attempts` times\n- Tasks exceeding max attempts move to dead letter queue\n- SQLite provides ACID guarantees for queue operations",[207],"0f58a68c-c8d2-11f0-a0ff-42dde27851f2","QUICKSTART.md","955f6422-c8ce-11f0-9c36-42dde27851f2",27,["D",1763946497450],"# Quick Start Guide\n\nYour lightweight queue system is set up and ready to use!\n\n## 🎯 What's Been Created\n\nA complete SQLite-based queue system with:\n\n- ✅ Database schema initialized\n- ✅ Priority-based task processing\n- ✅ Delayed/scheduled execution\n- ✅ Automatic retries with dead letter queue\n- ✅ Worker running every minute\n- ✅ Built-in monitoring\n\n## 🚀 Quick Start\n\n### 1. View Your Val\n\nVisit: https://www.val.town/x/nbbaier/lightweightQueue\n\n### 2. Enqueue Your First Task\n\n```bash\ncurl -X POST https://nbbaier--c5bd3e20c8cc11f0a88c42dde27851f2.web.val.run \\\n -H \"Content-Type: application/json\" \\\n -d '{\n \"task_type\": \"log_message\",\n \"payload\": {\n \"message\": \"Hello from my queue!\",\n \"level\": \"info\"\n }\n }'\n```\n\n### 3. Monitor Queue Status\n\nVisit: https://lightweightqueue-monitor.val.run/\n\n## 📊 Key Endpoints\n\n| Endpoint | Purpose | URL |\n| ----------- | ---------------------------- | ------------------------------------------------------------- |\n| **Enqueue** | Add tasks to queue | https://lightweightqueue-enqueue.val.run/ |\n| **Monitor** | View queue stats | https://lightweightqueue-monitor.val.run/ |\n| **Schema** | Initialize DB (already done) | https://nbbaier--ba92dd0cc8cc11f0979842dde27851f2.web.val.run |\n\n## 🎮 Built-in Task Types\n\n1. **log_message** - Log a message\n2. **send_email** - Send an email via Val Town\n3. **webhook** - Call an external webhook\n4. **http_request** - Make HTTP requests\n\n## 💡 Examples\n\n### High Priority Task\n\n```json\n{\n \"task_type\": \"log_message\",\n \"payload\": { \"message\": \"Important task!\" },\n \"priority\": 10\n}\n```\n\n### Scheduled Task (1 hour from now)\n\n```json\n{\n \"task_type\": \"log_message\",\n \"payload\": { \"message\": \"Future task!\" },\n \"scheduled_for\": 1732406400\n}\n```\n\n### Send Email Task\n\n```json\n{\n \"task_type\": \"send_email\",\n \"payload\": {\n \"to\": \"user@example.com\",\n \"subject\": \"Test\",\n \"text\": \"Hello from the queue!\"\n }\n}\n```\n\n## 🔧 Customization\n\n### Add Your Own Task Types\n\nEdit `processors.ts` and add a new processor:\n\n```typescript\ncase \"my_custom_task\":\n await processMyCustomTask(payload);\n break;\n```\n\n## 📁 File Structure\n\n- `schema.ts` - Database initialization\n- `enqueue.ts` - API to add tasks\n- `worker.ts` - Processes tasks every minute\n- `processors.ts` - Task processing logic\n- `monitor.ts` - Queue statistics API\n- `test.ts` - Example test cases\n- `README.md` - Full documentation\n\n## 🔍 Next Steps\n\n1. Run the test file to see it in action\n2. Check the monitor endpoint to see queue stats\n3. Add your own custom task processors\n4. Adjust worker interval if needed (currently 1 minute)\n\n## 📖 Full Documentation\n\nSee `README.md` for complete documentation including:\n\n- All task type examples\n- API reference\n- Architecture details\n- Error handling\n- Best practices\n\n---\n\n**Note:** The worker processes up to 10 tasks per minute. Failed tasks are\nautomatically retried up to 3 times before moving to the dead letter queue.\n",[214],"0f5ee790-c8d2-11f0-bb1d-42dde27851f2","AGENTS.md","f6c8126a-c8d1-11f0-afd6-42dde27851f2",28,["D",1763946497459],"You are an advanced assistant specialized in generating Val Town code.\n\n## Core Guidelines\n\n- Ask clarifying questions when requirements are ambiguous\n- Provide complete, functional solutions rather than skeleton implementations\n- Test your logic against edge cases before presenting the final solution\n- Ensure all code follows Val Town's specific platform requirements\n- If a section of code that you're working on is getting too complex, consider\n refactoring it into subcomponents\n\n## Code Standards\n\n- Generate code in TypeScript or TSX\n- Add appropriate TypeScript types and interfaces for all data structures\n- Prefer official SDKs or libraries than writing API calls directly\n- Ask the user to supply API or library documentation if you are at all unsure\n about it\n- **Never bake in secrets into the code** - always use environment variables\n- Include comments explaining complex logic (avoid commenting obvious\n operations)\n- Follow modern ES6+ conventions and functional programming practices if\n possible\n\n## Types of triggers\n\n### 1. HTTP Trigger\n\n- Create web APIs and endpoints\n- Handle HTTP requests and responses\n- Example structure:\n\n```ts\nexport default async function (req: Request) {\n return new Response(\"Hello World\");\n}\n```\n\nFiles that are HTTP triggers have http in their name like `foobar.http.tsx`\n\n### 2. Cron Triggers\n\n- Run on a schedule\n- Use cron expressions for timing\n- Example structure:\n\n```ts\nexport default async function () {\n // Scheduled task code\n}\n```\n\nFiles that are Cron triggers have cron in their name like `foobar.cron.tsx`\n\n### 3. Email Triggers\n\n- Process incoming emails\n- Handle email-based workflows\n- Example structure:\n\n```ts\nexport default async function (email: Email) {\n // Process email\n}\n```\n\nFiles that are Email triggers have email in their name like `foobar.email.tsx`\n\n## Val Town Standard Libraries\n\nVal Town provides several hosted services and utility functions.\n\n### Blob Storage\n\n```ts\nimport { blob } from \"https://esm.town/v/std/blob\";\nawait blob.setJSON(\"myKey\", { hello: \"world\" });\nlet blobDemo = await blob.getJSON(\"myKey\");\nlet appKeys = await blob.list(\"app_\");\nawait blob.delete(\"myKey\");\n```\n\n### SQLite\n\n```ts\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nconst TABLE_NAME = \"todo_app_users_2\";\n// Create table - do this before usage and change table name when modifying schema\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL\n)`);\n// Query data\nconst result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} WHERE id = ?`,\n [1]\n);\n```\n\nNote: When changing a SQLite table's schema, change the table's name (e.g., add\n\\_2 or \\_3) to create a fresh table.\n\n### OpenAI\n\n```ts\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nconst openai = new OpenAI();\nconst completion = await openai.chat.completions.create({\n messages: [{ role: \"user\", content: \"Say hello in a creative way\" }],\n model: \"gpt-4o-mini\",\n max_tokens: 30,\n});\n```\n\n### Email\n\n```ts\nimport { email } from \"https://esm.town/v/std/email\";\n// By default emails the owner of the val\nawait email({\n subject: \"Hi\",\n text: \"Hi\",\n html: \"

Hi

\",\n});\n```\n\n## Val Town Utility Functions\n\nVal Town provides several utility functions to help with common project tasks.\n\n### Importing Utilities\n\nAlways import utilities with version pins to avoid breaking changes:\n\n```ts\nimport {\n parseProject,\n readFile,\n serveFile,\n} from \"https://esm.town/v/std/utils@85-main/index.ts\";\n```\n\n### Available Utilities\n\n#### **serveFile** - Serve project files with proper content types\n\nFor example, in Hono:\n\n```ts\n// serve all files in frontend/ and shared/\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n```\n\n#### **readFile** - Read files from within the project:\n\n```ts\n// Read a file from the project\nconst fileContent = await readFile(\"/frontend/index.html\", import.meta.url);\n```\n\n#### **listFiles** - List all files in the project\n\n```ts\nconst files = await listFiles(import.meta.url);\n```\n\n#### **parseProject** - Extract information about the current project from import.meta.url\n\nThis is useful for including info for linking back to a val, ie in \"view source\"\nurls:\n\n```ts\nconst projectVal = parseProject(import.meta.url);\nconsole.log(projectVal.username); // Owner of the project\nconsole.log(projectVal.name); // Project name\nconsole.log(projectVal.version); // Version number\nconsole.log(projectVal.branch); // Branch name\nconsole.log(projectVal.links.self.project); // URL to the project page\n```\n\nHowever, it's _extremely importing_ to note that `parseProject` and other\nStandard Library utilities ONLY RUN ON THE SERVER. If you need access to this\ndata on the client, run it in the server and pass it to the client by splicing\nit into the HTML page or by making an API request for it.\n\n## Val Town Platform Specifics\n\n- **Redirects:** Use\n `return new Response(null, { status: 302, headers: { Location: \"/place/to/redirect\" }})`\n instead of `Response.redirect` which is broken\n- **Images:** Avoid external images or base64 images. Use emojis, unicode\n symbols, or icon fonts/libraries instead\n- **AI Image:** To inline generate an AI image use:\n `

`\n- **Storage:** DO NOT use the Deno KV module for storage\n- **Browser APIs:** DO NOT use the `alert()`, `prompt()`, or `confirm()` methods\n- **Weather Data:** Use open-meteo for weather data (doesn't require API keys)\n unless otherwise specified\n- **View Source:** Add a view source link by importing & using\n `import.meta.url.replace(\"ems.sh\", \"val.town)\"` (or passing this data to the\n client) and include `target=\"_top\"` attribute\n- **Error Debugging:** Add\n `` to HTML to capture\n client-side errors\n- **Error Handling:** Only use try...catch when there's a clear local\n resolution; Avoid catches that merely log or return 500s. Let errors bubble up\n with full context\n- **Environment Variables:** Use `Deno.env.get('keyname')` when you need to, but\n generally prefer APIs that don't require keys\n- **Imports:** Use `https://esm.sh` for npm and Deno dependencies to ensure\n compatibility on server and browser\n- **Storage Strategy:** Only use backend storage if explicitly required; prefer\n simple static client-side sites\n- **React Configuration:** When using React libraries, pin versions with\n `?deps=react@18.2.0,react-dom@18.2.0` and start the file with\n `/** @jsxImportSource https://esm.sh/react@18.2.0 */`\n- Ensure all React dependencies and sub-dependencies are pinned to the same\n version\n- **Styling:** Default to using TailwindCSS via\n `` unless otherwise\n specified\n\n## Project Structure and Design Patterns\n\n### Recommended Directory Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Schema definitions\n│ │ ├── queries.ts # DB query functions\n│ │ └── README.md\n│ └── routes/ # Route modules\n│ ├── [route].ts\n│ └── static.ts # Static file serving\n│ ├── index.ts # Main entry point\n│ └── README.md\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx\n│ │ └── [Component].tsx\n│ ├── favicon.svg\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # Frontend JS entry point\n│ ├── README.md\n│ └── style.css\n├── README.md\n└── shared/\n ├── README.md\n └── utils.ts # Shared types and functions\n```\n\n### Backend (Hono) Best Practices\n\n- Hono is the recommended API framework\n- Main entry point should be `backend/index.ts`\n- **Static asset serving:** Use the utility functions to read and serve project\n files:\n\n ```ts\n import {\n readFile,\n serveFile,\n } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n\n // serve all files in frontend/ and shared/\n app.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\n app.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n // For index.html, often you'll want to bootstrap with initial data\n app.get(\"/\", async (c) => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n // Inject data to avoid extra round-trips\n const initialData = await fetchInitialData();\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n });\n ```\n\n- Create RESTful API routes for CRUD operations\n- Always include this snippet at the top-level Hono app to re-throwing errors to\n see full stack traces:\n ```ts\n // Unwrap Hono errors to see original error details\n app.onError((err, c) => {\n throw err;\n });\n ```\n\n### Database Patterns\n\n- Run migrations on startup or comment out for performance\n- Change table names when modifying schemas rather than altering\n- Export clear query functions with proper TypeScript typing\n\n## Common Gotchas and Solutions\n\n1. **Environment Limitations:**\n\n - Val Town runs on Deno in a serverless context, not Node.js\n - Code in `shared/` must work in both frontend and backend environments\n - Cannot use `Deno` keyword in shared code\n - Use `https://esm.sh` for imports that work in both environments\n\n2. **SQLite Peculiarities:**\n\n - Limited support for ALTER TABLE operations\n - Create new tables with updated schemas and copy data when needed\n - Always run table creation before querying\n\n3. **React Configuration:**\n\n - All React dependencies must be pinned to 18.2.0\n - Always include `@jsxImportSource https://esm.sh/react@18.2.0` at the top of\n React files\n - Rendering issues often come from mismatched React versions\n\n4. **File Handling:**\n\n - Val Town only supports text files, not binary\n - Use the provided utilities to read files across branches and forks\n - For files in the project, use `readFile` helpers\n\n5. **API Design:**\n - `fetch` handler is the entry point for HTTP vals\n - Run the Hono app with\n `export default app.fetch // This is the entry point for HTTP vals`\n",[221],"f6cd0a54-c8d1-11f0-a89d-42dde27851f2",".vtignore","f6cd0b30-c8d1-11f0-a89d-42dde27851f2",24,["D",1763946456246],".git\n.vscode\n.cursor\n.DS_Store\nnode_modules\nvendor",[228],"pulls","branches","forks","envVars",{"_241":60,"_243":60},"connections",{"_241":60,"_242":60},"count","unfilledCount","emptyCount",{"_41":227,"_31":228,"_29":229,"_140":-5,"_39":40,"_38":230,"_142":56,"_36":294,"_13":60,"_32":20,"_34":232,"_23":24,"_147":-5,"_258":295,"_26":296},{"_41":220,"_31":221,"_29":222,"_140":-5,"_39":40,"_38":223,"_142":56,"_36":291,"_13":170,"_32":20,"_34":225,"_23":24,"_147":-5,"_258":292,"_26":293},{"_41":213,"_31":214,"_29":215,"_140":-5,"_39":40,"_38":216,"_142":24,"_36":288,"_13":144,"_32":20,"_34":218,"_23":24,"_147":-5,"_258":289,"_26":290},{"_41":206,"_31":207,"_29":208,"_140":-5,"_39":40,"_38":209,"_142":24,"_36":285,"_13":161,"_32":20,"_34":211,"_23":24,"_147":-5,"_258":286,"_26":287},{"_41":202,"_31":27,"_29":30,"_140":-5,"_39":40,"_38":14,"_142":24,"_36":282,"_13":60,"_32":33,"_34":35,"_23":24,"_147":204,"_258":283,"_26":284},{"_41":195,"_31":196,"_29":197,"_140":-5,"_39":40,"_38":198,"_142":56,"_36":279,"_13":60,"_32":20,"_34":200,"_23":24,"_147":-5,"_258":280,"_26":281},{"_41":188,"_31":189,"_29":190,"_140":-5,"_39":40,"_38":191,"_142":24,"_36":276,"_13":170,"_32":20,"_34":193,"_23":24,"_147":-5,"_258":277,"_26":278},{"_41":180,"_31":181,"_29":182,"_140":-5,"_39":40,"_38":183,"_142":24,"_36":273,"_13":185,"_32":162,"_34":186,"_23":24,"_147":-5,"_258":274,"_26":275},{"_41":173,"_31":174,"_29":175,"_140":-5,"_39":40,"_38":176,"_142":24,"_36":270,"_13":144,"_32":162,"_34":178,"_23":24,"_147":-5,"_258":271,"_26":272},{"_41":165,"_31":166,"_29":167,"_140":-5,"_39":40,"_38":168,"_142":24,"_36":267,"_13":170,"_32":33,"_34":171,"_23":24,"_147":-5,"_258":268,"_26":269},{"_41":156,"_31":157,"_29":158,"_140":-5,"_39":40,"_38":159,"_142":24,"_36":264,"_13":161,"_32":162,"_34":163,"_23":24,"_147":-5,"_258":265,"_26":266},{"_41":149,"_31":150,"_29":151,"_140":-5,"_39":40,"_38":152,"_142":56,"_36":261,"_13":144,"_32":33,"_34":154,"_23":24,"_147":-5,"_258":262,"_26":263},{"_41":137,"_31":138,"_29":139,"_140":-5,"_39":40,"_38":141,"_142":24,"_36":257,"_13":144,"_32":145,"_34":146,"_23":24,"_147":-5,"_258":259,"_26":260},["D",1763946506656],"children",[],[138],["D",1763946456294],[],[150],["D",1763946506645],[],[157],["D",1763946506644],[],[166],["D",1763946506636],[],[174],["D",1763946506795],[],[181],["D",1763946506648],[],[189],["D",1763946456231],[],[196],["D",1763949397510],[],[27],["D",1763946022715],[],[207],["D",1763946497450],[],[214],["D",1763946497459],[],[221],["D",1763946456246],[],[228],["D",1763944165015],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":53,"_98":99,"_100":24},{"_13":83,"_31":84,"_41":40,"_85":42,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":43,"_92":93},"ctx",{"_76":-5,"_121":334,"_335":336,"_337":338,"_339":24,"_340":24,"_341":24,"_342":56,"_343":-5,"_344":-7,"_345":-7,"_346":60,"_347":24,"_348":24,"_349":-5,"_350":24,"_351":24,"_352":24,"_353":-5},"ENV",{"_305":306,"_307":308,"_309":84,"_310":311,"_312":313,"_314":315,"_316":317,"_318":319,"_320":321,"_322":323,"_324":325,"_326":327,"_328":329,"_330":331,"_332":333},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5a709144666c9e69e88140f015c586412f0fd8d3","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 · v42