Error loading jobs. Please try again.

';\n }\n}\n\n// Render jobs to the DOM\nfunction renderJobs() {\n if (jobs.length === 0) {\n jobsContainer.innerHTML = '

No jobs posted yet. Be the first!

';\n return;\n }\n\n jobsContainer.innerHTML = jobs.map(job => `\n

${sanitizeHTML(job.title)}

\n ${formatDate(job.created_at)}\n

${sanitizeHTML(job.company)}

${sanitizeHTML(job.description)}

Contact: ${sanitizeHTML(job.contact)}

\n `).join(\"\");\n}\n\n// Submit new job\njobForm.addEventListener(\"submit\", async (e) => {\n e.preventDefault();\n \n const newJob = {\n title: jobTitle.value.trim(),\n company: jobCompany.value.trim(),\n description: jobDescription.value.trim(),\n contact: jobContact.value.trim()\n };\n \n try {\n const response = await fetch(\"/api/jobs\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(newJob)\n });\n \n if (!response.ok) throw new Error(\"Failed to post job\");\n \n const job = await response.json();\n jobs.unshift(job); // Add to beginning of array\n renderJobs();\n \n // Clear form\n jobForm.reset();\n } catch (error) {\n console.error(\"Error posting job:\", error);\n alert(\"Error posting job. Please try again.\");\n }\n});\n\n// Load chat messages\nasync function loadMessages() {\n try {\n const response = await fetch(\"/api/messages\");\n if (!response.ok) throw new Error(\"Failed to load messages\");\n \n messages = await response.json();\n messages.reverse(); // Show oldest first\n renderMessages();\n } catch (error) {\n console.error(\"Error loading messages:\", error);\n chatContainer.innerHTML = '

Error loading messages. Please try again.

';\n }\n}\n\n// Render messages to the DOM\nfunction renderMessages() {\n if (messages.length === 0) {\n chatContainer.innerHTML = '

No messages yet. Start the conversation!

';\n return;\n }\n\n chatContainer.innerHTML = messages.map(message => `\n

\n ${sanitizeHTML(message.username)}\n ${formatDate(message.created_at)}\n

${sanitizeHTML(message.content)}

\n `).join(\"\");\n \n // Scroll to bottom\n chatContainer.scrollTop = chatContainer.scrollHeight;\n}\n\n// Submit new message\nchatForm.addEventListener(\"submit\", async (e) => {\n e.preventDefault();\n \n const content = chatInput.value.trim();\n if (!content) return;\n \n const newMessage = {\n username,\n content\n };\n \n try {\n const response = await fetch(\"/api/messages\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(newMessage)\n });\n \n if (!response.ok) throw new Error(\"Failed to send message\");\n \n const message = await response.json();\n messages.push(message);\n renderMessages();\n \n // Clear input\n chatForm.reset();\n } catch (error) {\n console.error(\"Error sending message:\", error);\n alert(\"Error sending message. Please try again.\");\n }\n});\n\n// Poll for new messages every 5 seconds\nfunction startMessagePolling() {\n setInterval(loadMessages, 5000);\n}\n\n// Initialize app\ncheckAuth();\nif (username) {\n loadJobs();\n loadMessages();\n startMessagePolling();\n}",[],[94,105],"4d966e84-31e2-11f0-9c4c-569c3dd06744","index.html","34892846-31e2-11f0-9cdd-569c3dd06744",10,["D",1747350848241],"\n\n\n \n \n Job Board with Chat\n \n \n \n \n \n \n\n\n \n \n\n \n

Job Board with Chat

\n Welcome, \n \n

\n\n

\n \n

Post a Job

\n \n

\n\n

Job Listings

\n \n

Loading jobs...

\n\n \n

Discussion Chat

\n \n

Loading messages...

\n \n

\n\n \n\n \n\n",[],[94,113],"48928bd4-31e2-11f0-9a73-569c3dd06744","favicon.svg","48928ca6-31e2-11f0-9a73-569c3dd06744",9,["D",1747350839831],"\n",[],[94,121],"55290cba-31e2-11f0-997f-569c3dd06744","55290d5a-31e2-11f0-997f-569c3dd06744",12,["D",1747350860956],"# Frontend\n\nThis directory contains the client-side code for the Job Board with Chat application.\n\n## Structure\n\n- `index.html` - Main HTML template\n- `index.js` - Frontend JavaScript\n- `favicon.svg` - Application icon\n\n## Features\n\n- Simple username-based authentication\n- Job posting form\n- Job listings display\n- Real-time chat functionality\n\n## Technologies\n\n- HTML5\n- JavaScript (ES6+)\n- Tailwind CSS for styling",[],[94,60],"16516d66-31e2-11f0-87b4-569c3dd06744","backend","68626bad-e95a-4ef2-8691-d49175d38d7f",2,["D",1747350755519],[142,143,144],[136],{"_35":161,"_13":162,"_38":163,"_40":137,"_42":43,"_44":138,"_46":47,"_48":164,"_17":50,"_51":68,"_53":-5,"_55":56,"_57":-5,"_79":165,"_18":166},{"_35":154,"_13":60,"_38":155,"_40":137,"_42":43,"_44":156,"_46":47,"_48":157,"_17":50,"_51":24,"_53":158,"_55":56,"_57":-5,"_79":159,"_18":160},{"_35":145,"_13":146,"_38":147,"_40":137,"_42":43,"_44":148,"_46":47,"_48":149,"_17":76,"_51":150,"_53":151,"_55":56,"_57":-5,"_79":152,"_18":153},"460294ae-31e2-11f0-9aeb-569c3dd06744","index.ts","224147cc-31e2-11f0-997f-569c3dd06744",8,["D",1747350835531],"http","import { Hono } from \"https://esm.sh/hono@3.12.6\";\nimport { cors } from \"https://esm.sh/hono@3.12.6/cors\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { initDatabase } from \"./database/migrations.ts\";\nimport { \n getAllJobs, \n createJob, \n getRecentMessages, \n createMessage \n} from \"./database/queries.ts\";\n\n// Initialize the app\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Enable CORS\napp.use(\"*\", cors());\n\n// Initialize database on startup\nawait initDatabase();\n\n// API Routes\napp.get(\"/api/jobs\", async (c) => {\n const jobs = await getAllJobs();\n return c.json(jobs);\n});\n\napp.post(\"/api/jobs\", async (c) => {\n const body = await c.req.json();\n \n // Validate required fields\n if (!body.title || !body.company || !body.description || !body.contact) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n \n const job = await createJob({\n title: body.title,\n company: body.company,\n description: body.description,\n contact: body.contact\n });\n \n return c.json(job, 201);\n});\n\napp.get(\"/api/messages\", async (c) => {\n const messages = await getRecentMessages();\n return c.json(messages);\n});\n\napp.post(\"/api/messages\", async (c) => {\n const body = await c.req.json();\n \n // Validate required fields\n if (!body.username || !body.content) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n \n const message = await createMessage({\n username: body.username,\n content: body.content\n });\n \n return c.json(message, 201);\n});\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Serve index.html for the root path\napp.get(\"/\", async (c) => {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\n// This is the entry point for HTTP vals\nexport default app.fetch;",[],[136,146],"52b9bb8c-31e2-11f0-b3b0-569c3dd06744","52b9bc2c-31e2-11f0-b3b0-569c3dd06744",11,["D",1747350856856],"# Backend\n\nThis directory contains the server-side code for the Job Board with Chat application.\n\n## Structure\n\n- `index.ts` - Main entry point with Hono API routes\n- `database/` - Database setup and queries\n - `migrations.ts` - Database schema definitions\n - `queries.ts` - Database query functions\n\n## API Endpoints\n\n### Jobs\n\n- `GET /api/jobs` - Get all job listings\n- `POST /api/jobs` - Create a new job listing\n\n### Messages\n\n- `GET /api/messages` - Get recent chat messages\n- `POST /api/messages` - Create a new chat message\n\n## Database\n\nThe application uses SQLite for data storage with two main tables:\n\n1. `jobs_v1` - Stores job listings\n2. `messages_v1` - Stores chat messages",[],[136,60],"16516f5a-31e2-11f0-87b4-569c3dd06744","database","16bfafca-4754-4171-9c1c-87d8d447fc5d",["D",1747350755519],[167,168],[136,162],{"_35":177,"_13":178,"_38":179,"_40":163,"_42":43,"_44":138,"_46":47,"_48":180,"_17":50,"_51":52,"_53":181,"_55":56,"_57":-5,"_79":182,"_18":183},{"_35":169,"_13":170,"_38":171,"_40":163,"_42":43,"_44":172,"_46":47,"_48":173,"_17":50,"_51":52,"_53":174,"_55":56,"_57":-5,"_79":175,"_18":176},"1bad031a-31e2-11f0-997f-569c3dd06744","queries.ts","1bad03e2-31e2-11f0-997f-569c3dd06744",3,["D",1747350764497],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { JOBS_TABLE, MESSAGES_TABLE } from \"./migrations.ts\";\n\n// Types\nexport interface Job {\n id: number;\n title: string;\n company: string;\n description: string;\n contact: string;\n created_at: number;\n}\n\nexport interface Message {\n id: number;\n username: string;\n content: string;\n created_at: number;\n}\n\n// Job queries\nexport async function getAllJobs(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${JOBS_TABLE} ORDER BY created_at DESC`\n );\n return result.rows;\n}\n\nexport async function createJob(job: Omit): Promise {\n const created_at = Date.now();\n const result = await sqlite.execute<{ id: number }>(\n `INSERT INTO ${JOBS_TABLE} (title, company, description, contact, created_at)\n VALUES (?, ?, ?, ?, ?)\n RETURNING id`,\n [job.title, job.company, job.description, job.contact, created_at]\n );\n \n return {\n id: result.rows[0].id,\n ...job,\n created_at\n };\n}\n\n// Message queries\nexport async function getRecentMessages(limit = 50): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${MESSAGES_TABLE} \n ORDER BY created_at DESC \n LIMIT ?`,\n [limit]\n );\n return result.rows;\n}\n\nexport async function createMessage(message: Omit): Promise {\n const created_at = Date.now();\n const result = await sqlite.execute<{ id: number }>(\n `INSERT INTO ${MESSAGES_TABLE} (username, content, created_at)\n VALUES (?, ?, ?)\n RETURNING id`,\n [message.username, message.content, created_at]\n );\n \n return {\n id: result.rows[0].id,\n ...message,\n created_at\n };\n}",[],[136,162,170],"16514958-31e2-11f0-87b4-569c3dd06744","migrations.ts","16514a16-31e2-11f0-87b4-569c3dd06744",["D",1747350755519],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names - use versioning for schema changes\nexport const JOBS_TABLE = \"jobs_v1\";\nexport const MESSAGES_TABLE = \"messages_v1\";\n\n/**\n * Initialize database tables\n */\nexport async function initDatabase() {\n // Create jobs table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${JOBS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n company TEXT NOT NULL,\n description TEXT NOT NULL,\n contact TEXT NOT NULL,\n created_at INTEGER NOT NULL\n )\n `);\n\n // Create messages table for chat\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${MESSAGES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n content TEXT NOT NULL,\n created_at INTEGER NOT NULL\n )\n `);\n}",[],[136,162,178],"0595b72a-31e2-11f0-82d1-569c3dd06744",["D",1747350727452],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","e5091e30-2cb8-11f0-8b3c-8566c5f34604","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","788ca030-1c76-430d-8973-cb5112a92588","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_236":232},"org",{"_11":12,"_230":-5,"_231":232,"_193":194,"_233":234,"_235":56},"branch",{"_17":62,"_13":16,"_35":43,"_222":184,"_223":-5,"_224":-5,"_225":-5,"_226":-5,"_227":-5,"_228":14,"_229":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ3cXlGNGdHR3o4ZzFmdm1xd3Y5T0FYRVU4biJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":184,"_13":14,"_48":315,"_186":-5,"_187":56,"_188":189,"_190":189,"_191":-5,"_192":-5,"_193":194,"_195":147,"_196":47,"_197":47,"_198":-5,"_199":50,"_200":201,"_202":-5,"_203":-5,"_204":-5,"_205":-5,"_206":207,"_208":207,"_209":210,"_211":210,"_212":210,"_213":207,"_214":207,"_215":316,"_217":317,"_219":318,"_221":56},[270,276,281,284],"files",[270,271,272,273,274,275,276,277,278,279,280,281,282,283,284],"counts",{"_261":50,"_262":76,"_263":50,"_32":264,"_265":266},[257,258],{"_35":66,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":45,"_46":47,"_48":67,"_17":50,"_51":68,"_53":-5,"_55":56,"_57":-5,"_18":256},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":63,"_17":50,"_51":24,"_53":64,"_55":56,"_57":-5,"_18":260},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_18":259},[19,37],[19,60],"pulls","branches","forks",{"_267":50,"_269":50},"connections",{"_267":50,"_268":50},"count","unfilledCount","emptyCount",{"_35":135,"_13":136,"_38":137,"_40":-5,"_42":43,"_44":138,"_46":47,"_48":139,"_17":50,"_51":68,"_53":-5,"_55":56,"_57":-5,"_79":313,"_18":314},{"_35":161,"_13":162,"_38":163,"_40":137,"_42":43,"_44":138,"_46":47,"_48":164,"_17":50,"_51":68,"_53":-5,"_55":56,"_57":-5,"_79":311,"_18":312},{"_35":177,"_13":178,"_38":179,"_40":163,"_42":43,"_44":138,"_46":47,"_48":180,"_17":50,"_51":52,"_53":181,"_55":56,"_57":-5,"_79":309,"_18":310},{"_35":169,"_13":170,"_38":171,"_40":163,"_42":43,"_44":172,"_46":47,"_48":173,"_17":50,"_51":52,"_53":174,"_55":56,"_57":-5,"_79":307,"_18":308},{"_35":154,"_13":60,"_38":155,"_40":137,"_42":43,"_44":156,"_46":47,"_48":157,"_17":50,"_51":24,"_53":158,"_55":56,"_57":-5,"_79":305,"_18":306},{"_35":145,"_13":146,"_38":147,"_40":137,"_42":43,"_44":148,"_46":47,"_48":149,"_17":76,"_51":150,"_53":151,"_55":56,"_57":-5,"_79":303,"_18":304},{"_35":93,"_13":94,"_38":95,"_40":-5,"_42":43,"_44":96,"_46":47,"_48":97,"_17":50,"_51":68,"_53":-5,"_55":56,"_57":-5,"_79":301,"_18":302},{"_35":128,"_13":60,"_38":129,"_40":95,"_42":43,"_44":130,"_46":47,"_48":131,"_17":50,"_51":24,"_53":132,"_55":56,"_57":-5,"_79":299,"_18":300},{"_35":120,"_13":121,"_38":122,"_40":95,"_42":43,"_44":123,"_46":47,"_48":124,"_17":50,"_51":24,"_53":125,"_55":56,"_57":-5,"_79":297,"_18":298},{"_35":112,"_13":113,"_38":114,"_40":95,"_42":43,"_44":115,"_46":47,"_48":116,"_17":76,"_51":24,"_53":117,"_55":56,"_57":-5,"_79":295,"_18":296},{"_35":104,"_13":105,"_38":106,"_40":95,"_42":43,"_44":107,"_46":47,"_48":108,"_17":50,"_51":52,"_53":109,"_55":56,"_57":-5,"_79":293,"_18":294},{"_35":66,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":45,"_46":47,"_48":82,"_17":50,"_51":68,"_53":-5,"_55":56,"_57":-5,"_79":291,"_18":292},{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":90,"_17":50,"_51":24,"_53":64,"_55":56,"_57":-5,"_79":289,"_18":290},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":87,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_79":287,"_18":288},{"_35":74,"_13":60,"_38":75,"_40":-5,"_42":43,"_44":76,"_46":47,"_48":77,"_17":50,"_51":24,"_53":78,"_55":56,"_57":-5,"_79":285,"_18":286},[],[60],[],[19,37],[],[19,60],[282,283],[19],[],[94,105],[],[94,113],[],[94,121],[],[94,60],[277,278,279,280],[94],[],[136,146],[],[136,60],[],[136,162,170],[],[136,162,178],[272,273],[136,162],[271,274,275],[136],["D",1747350727452],{"_11":12,"_236":232},{"_11":12,"_230":-5,"_231":232,"_193":194,"_233":234,"_235":56},{"_17":62,"_13":16,"_35":43,"_222":184,"_223":-5,"_224":-5,"_225":-5,"_226":-5,"_227":-5,"_228":14,"_229":12},"ctx",{"_215":-5,"_253":352,"_353":354,"_355":356,"_357":56,"_358":56,"_359":56,"_360":47,"_361":-5,"_362":-7,"_363":-7,"_364":50,"_365":56,"_366":56,"_367":-5,"_368":56,"_369":56,"_370":56,"_371":-5},"ENV",{"_323":324,"_325":326,"_327":16,"_328":329,"_330":331,"_332":333,"_334":335,"_336":337,"_338":339,"_340":341,"_342":343,"_344":345,"_346":347,"_348":349,"_350":351},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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"]