[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_193":194,"_195":196},"routes/_app.x.$handle.$name",{"_101":100,"_32":49,"_109":91,"_27":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_21":-5,"_121":-5,"_122":-5,"_123":25,"_124":125,"_126":25,"_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",{"_47":48,"_32":49,"_37":50,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":57,"_58":-5,"_18":59,"_60":61,"_62":63,"_64":63,"_65":-5,"_66":67,"_68":69,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":25},"version",3,"changes",[19,20],"aiChatInfo","userId",{"_21":42,"_23":-7,"_24":25,"_26":25,"_27":43,"_29":43},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":21,"_35":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous","deleted",false,"deletedHere","path","frontend/index.html","latestPath","fileId","854f5bac-3443-11f0-baca-9e149126039e","name","index.html","fileType","content","\n\n\n \n \n Job Board with Chat\n \n \n \n\n\n

Job Board with Chat

Find opportunities and discuss them with others

\n\n

\n \n

Job Listings

Loading job listings...

\n\n \n

Post a Job

\n \n

\n\n \n

Opportunity Chat

Loading chat messages...

\n \n

\n\n \n

\n\n \n\n","createdAt",["D",1747612505246],"branchVersion","branchId","fdd0be32-3442-11f0-b570-9e149126039e",{"_30":44,"_32":43,"_34":45,"_35":-5,"_37":46,"_39":14,"_40":41,"_24":25},"frontend","2c0cdac2-d296-4fc1-a942-1f5ea8a9dc8f","directory",["D",1747612505246],"id","fdd084bc-3442-11f0-b570-9e149126039e","JobApp",["D",1747612277925],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Creating a job app with chat forum","imageUrl","dcf86e80-3442-11f0-b519-ff88f6bc2fe6","pinnedFileId","635ddb04-3443-11f0-b77c-9e149126039e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",1,"orgId","d12e9468-0713-4b2e-926d-7ccecb147081","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_101":100,"_108":104},"org",{"_101":100,"_102":-5,"_103":104,"_18":59,"_105":106,"_107":25},"branch",{"_13":90,"_32":91,"_47":41,"_92":48,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":49,"_99":100},"isOwned",15,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","excel","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeEk0TXdTZ1pDYmt1Y0FqSmFkNWwxMUx6UkMifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_47":48,"_32":49,"_37":189,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":57,"_58":-5,"_18":59,"_60":61,"_62":63,"_64":63,"_65":-5,"_66":67,"_68":69,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":190,"_85":191,"_87":192,"_89":25},"tree",[163,165,167],"files",[163,164,165,166,167],"counts",{"_153":140,"_154":67,"_155":140,"_156":157,"_158":159},"contents",[131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":147,"_32":148,"_30":149,"_137":-5,"_40":41,"_39":150,"_138":63,"_37":151,"_13":140,"_34":45,"_35":-5,"_24":25,"_142":-5,"_27":152},{"_47":144,"_32":43,"_30":44,"_137":-5,"_40":41,"_39":14,"_138":63,"_37":145,"_13":140,"_34":45,"_35":-5,"_24":25,"_142":-5,"_27":146},{"_47":134,"_32":135,"_30":136,"_137":-5,"_40":41,"_39":67,"_138":63,"_37":139,"_13":140,"_34":21,"_35":141,"_24":25,"_142":-5,"_27":143},"58c02b5c-3443-11f0-8796-9e149126039e","README.md","58c02c6a-3443-11f0-8796-9e149126039e","parentId","latest",["D",1747612430487],0,"# Job Board with Chat\n\nA simple application that allows users to:\n- Post job opportunities\n- View job listings\n- Participate in a public chat room to discuss opportunities\n\n## Features\n\n- Create and view job postings\n- Real-time public chat room\n- Simple, responsive UI with Tailwind CSS\n\n## Project Structure\n\n- `/backend` - Hono API server and SQLite database\n- `/frontend` - HTML, CSS, and JavaScript for the client-side application\n- `/shared` - Shared types and utilities\n\n## Technologies Used\n\n- Backend: Hono, SQLite\n- Frontend: HTML, JavaScript, Tailwind CSS\n- Data Storage: SQLite\n\n## How to Use\n\n1. Visit the main page to see job listings and the chat room\n2. Use the \"Post a Job\" form to create new job listings\n3. Enter your name and message in the chat form to participate in discussions","label",[135],"855016aa-3443-11f0-baca-9e149126039e",["D",1747612505246],[43],"635dffbc-3443-11f0-b77c-9e149126039e","backend","d90fca17-6935-40e6-aa6e-b0f77c646c1b",2,["D",1747612448297],[148],"pulls","branches","forks","envVars",{"_160":140,"_162":140},"connections",{"_160":140,"_161":140},"count","unfilledCount","emptyCount",{"_47":147,"_32":148,"_30":149,"_137":-5,"_40":41,"_39":150,"_138":63,"_37":186,"_13":140,"_34":45,"_35":-5,"_24":25,"_142":-5,"_169":187,"_27":188},{"_47":179,"_32":180,"_30":61,"_137":149,"_40":41,"_39":150,"_138":25,"_37":181,"_13":140,"_34":182,"_35":183,"_24":25,"_142":-5,"_169":184,"_27":185},{"_47":144,"_32":43,"_30":44,"_137":-5,"_40":41,"_39":14,"_138":63,"_37":176,"_13":140,"_34":45,"_35":-5,"_24":25,"_142":-5,"_169":177,"_27":178},{"_47":172,"_32":33,"_30":31,"_137":44,"_40":41,"_39":14,"_138":63,"_37":173,"_13":140,"_34":21,"_35":36,"_24":25,"_142":-5,"_169":174,"_27":175},{"_47":134,"_32":135,"_30":136,"_137":-5,"_40":41,"_39":67,"_138":63,"_37":168,"_13":140,"_34":21,"_35":141,"_24":25,"_142":-5,"_169":170,"_27":171},["D",1747612430487],"children",[],[135],"854f5af8-3443-11f0-baca-9e149126039e",["D",1747612505246],[],[43,33],["D",1747612505246],[166],[43],"635dda3c-3443-11f0-b77c-9e149126039e","index.ts",["D",1747612448297],"script","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { cors } from \"https://esm.sh/hono@3.11.7/middleware\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n\n// Initialize Hono 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// Database setup\nconst JOBS_TABLE = \"job_postings\";\nconst CHAT_TABLE = \"chat_messages\";\n\nasync function setupDatabase() {\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 description TEXT NOT NULL,\n company TEXT NOT NULL,\n location TEXT NOT NULL,\n salary TEXT,\n contact TEXT NOT NULL,\n created_at TEXT NOT NULL\n )\n `);\n\n // Create chat messages table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${CHAT_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n message TEXT NOT NULL,\n created_at TEXT NOT NULL\n )\n `);\n}\n\n// Run database setup\nsetupDatabase().catch(console.error);\n\n// API Routes\n\n// Get all job postings\napp.get(\"/api/jobs\", async (c) => {\n const jobs = await sqlite.execute(`SELECT * FROM ${JOBS_TABLE} ORDER BY created_at DESC`);\n return c.json(jobs);\n});\n\n// Create a new job posting\napp.post(\"/api/jobs\", async (c) => {\n const body = await c.req.json();\n const { title, description, company, location, salary, contact } = body;\n \n if (!title || !description || !company || !location || !contact) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n \n const created_at = new Date().toISOString();\n \n await sqlite.execute(\n `INSERT INTO ${JOBS_TABLE} (title, description, company, location, salary, contact, created_at) \n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [title, description, company, location, salary || \"\", contact, created_at]\n );\n \n return c.json({ success: true });\n});\n\n// Get chat messages\napp.get(\"/api/chat\", async (c) => {\n const messages = await sqlite.execute(\n `SELECT * FROM ${CHAT_TABLE} ORDER BY created_at DESC LIMIT 100`\n );\n return c.json(messages.reverse()); // Return in chronological order\n});\n\n// Post a chat message\napp.post(\"/api/chat\", async (c) => {\n const body = await c.req.json();\n const { username, message } = body;\n \n if (!username || !message) {\n return c.json({ error: \"Username and message are required\" }, 400);\n }\n \n const created_at = new Date().toISOString();\n \n await sqlite.execute(\n `INSERT INTO ${CHAT_TABLE} (username, message, created_at) VALUES (?, ?, ?)`,\n [username, message, created_at]\n );\n \n return c.json({ success: true });\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// Export the Hono app\nexport default app.fetch;",[],[148,180],["D",1747612448297],[164],[148],["D",1747612277925],{"_101":100,"_108":104},{"_101":100,"_102":-5,"_103":104,"_18":59,"_105":106,"_107":25},{"_13":90,"_32":91,"_47":41,"_92":48,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":49,"_99":100},"ctx",{"_83":-5,"_128":226,"_227":228,"_229":230,"_231":25,"_232":25,"_233":25,"_234":63,"_235":-5,"_236":-7,"_237":-7,"_238":140,"_239":25,"_240":25,"_241":-5,"_242":25,"_243":25,"_244":25,"_245":-5},"ENV",{"_197":198,"_199":200,"_201":91,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e8c4b7030cb7600e4eb0736b15f422c8b8bd130f","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 · v3